Description

You design, develop, and optimize ETL/ELT solutions using MS SQL and Azure Data Factory, ensuring data quality and architectural alignment.

This role is remote.

Responsibilities

• Design and deploy reliable ETL workflows with robust error handling, rollback mechanisms, and automated validation processes.
• Translate complex business requirements into technical data models, extracting and loading data into staging areas and data warehouses.
• Build custom reports, data-driven subscriptions, and business dashboards using Power BI, Tableau, or similar enterprise analytics tools.
• Manage database administration tasks including job scheduling, performance tuning, backup/recovery strategies, and data security standards.
• Lead design reviews, conduct code reviews, and provide Level 3 support while mentoring junior developers on best practices.

Required Skills

• 8+ years of experience in MS SQL Development, including complex queries, stored procedures, and functions.
• Extensive experience with Azure Data Factory for designing and implementing ETL/ELT pipelines.
• Strong background in data warehouse design, data mapping, and optimizing data quality throughout the lifecycle.
• Proficiency with web service integrations including WWS, SOAP, REST, WSDL, and XML.
• Hands-on experience with BI tools such as Power BI and Tableau for reporting and dashboard creation.
• Ability to use Azure DevOps for agile project management and work prioritization.
• Bachelor's degree in a relevant technical field.

Preferred Skills

• Experience with integration tools like Boomi.
• Valid driver's license and acceptable driving record for occasional onsite project support.

Key Skills

Education

Bachelor's degree