Description

You will manage and maintain data integrity through automated processes and manual investigation. You will develop, optimize, and document SQL-based solutions using MS SQL Server tools.

Responsibilities

• Develop and automate data management processes using MS SQL Server, SSIS, and Tableau.
• Execute SQL development activities including data extraction, transformation, formatting, and validation.
• Build QA and performance dashboards to measure data integrity, validity, accuracy, and completeness.
• Optimize SQL scripts and processes to increase system efficiency and performance.
• Analyze and resolve data anomalies using advanced SQL scripts within SSMS.

Required Skills

• 5+ years of experience in data management and SQL development.
• Extensive experience with MS SQL Server and SSMS.
• Proficiency in SSIS for data integration and automation.
• Experience with SSRS for reporting.
• Ability to build data quality dashboards in Tableau.
• Strong SQL skills for data extraction and complex transformations.
• Experience managing data security and confidentiality.
• Ability to gather and document data migration requirements.

Preferred Skills

• Experience with Tableau or similar data visualization software.

Key Skills

Education

Any Graduate