T Sql Jobs in Virginia (NOW HIRING)

Job Summary:
InterSources Inc is a Certified Diverse Supplier and an Award-Winning Global Software Consultancy founded in 2007. They are seeking a T-SQL Programmer Analyst to manage and maintain data quality, develop data management processes, and collaborate with peers to ensure data meets reporting requirements.
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.
• Assist in gathering and documenting data needs and migration requirements for use in the migration tool design, as well as 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.
• Extensive experience implementing relevant, trend-based data quality measurements and assessing 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
• Assist in responding to data requests, data analysis using SQL and automation/generation of ad-hoc reports
• Provide assistance in various data management activities as assigned
• Collaborates with peers to ensure formatted data received meets reporting and system requirements within the Office of Epidemiology (OEPI).
• May write reports or facilitate data access by other means as needed, to include SSIS, SSRS, Tableau, etc.
• Participates in internal and external meetings.
Qualifications:
Required:
• 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
• Assist in gathering and documenting data needs and migration requirements for use in the migration tool design, as well as 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
• Extensive experience implementing relevant, trend-based data quality measurements and assessing 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
• Assist in responding to data requests, data analysis using SQL and automation/generation of ad-hoc reports
• Provide assistance in various data management activities as assigned
• Collaborates with peers to ensure formatted data received meets reporting and system requirements within the Office of Epidemiology (OEPI)
• May write reports or facilitate data access by other means as needed, to include SSIS, SSRS, Tableau, etc.
• Participates in internal and external meetings
Company:
InterSources Inc. solves operational problems where protection, performance, compliance, AI, and workforce capability must work together. Founded in 2007, the company is headquartered in Fremont, USA, with a team of 501-1000 employees. The company is currently Late Stage.