Join our dynamic team in Richmond, VA, as a T-SQL Programmer Analyst. This role offers the flexibility of remote work, but candidates must be available to come onsite when requested. We are looking for a skilled individual who can explore and understand data structures, manage data quality, and develop efficient data management processes.
Responsibilities
- Explore and understand the data structure and contents in the data repositories.
- Assist in the review of data quality, troubleshooting, and data cleanup process.
- Manage and maintain large volumes of data using manual and automated techniques for investigation and resolution of data quality issues.
- Gather and document data needs and migration requirements for use in the migration tool design and other reporting measures.
- Develop, automate, and maintain data management and data improvement processes using MS SQL SSMS, MS SQL Server Jobs, SSIS, and Tableau.
- Utilize SQL server environment for all SQL development activities including data extraction, data quality, transformation and formatting, testing, modification, and validation.
- Participate in the development of effective solutions and enhancements to increase efficiency of system operations, availability, and reporting of high-quality data.
- Routinely review SQL scripts and processes to optimize performance.
- Develop QA and performance dashboards measuring data quality dimensions including integrity, validity, accuracy, consistency, and completeness using Tableau or similar software.
- Implement relevant, trend-based data quality measurements and assess scope, frequency, and severity of data anomalies using advanced SQL scripts within MS SQL Server Management Studio.
- Maintain documentation of processes, procedures, and manuals.
- Assist in managing and maintaining the confidentiality and security of the data at all times.
- Respond to data requests, perform data analysis using SQL, and automate/generate ad-hoc reports.
- Provide assistance in various data management activities as assigned.
- Collaborate with peers to ensure formatted data received meets reporting and system requirements.
- Write reports or facilitate data access by other means as needed, including SSIS, SSRS, Tableau, etc.
- Participate in internal and external meetings.
#INDIT