Description

Designs, develops, and optimizes ETL/ELT solutions using MS SQL, Azure Data Factory, and data warehouse best practices.

This role is remote.

Responsibilities

• Design and deploy ETL job workflows with reliable error handling and rollback mechanisms.
• Analyze complex source data and business requirements to determine optimal extraction, transformation, and loading strategies.
• Develop automated data audit and validation processes to ensure data quality and integrity.
• Create ad-hoc reports, data-driven subscriptions, and business dashboards using Power BI or Tableau.
• Mentor junior developers, conduct code reviews, and provide Level 3 support for supported platforms.

Required Skills

• Expert knowledge in MS SQL Development, including complex SQL queries, stored procedures, and functions.
• Extensive experience with Azure Data Factory and Azure SQL for ETL/ELT solution design.
• Strong proficiency in web service integrations, including WWS, SOAP, REST, WSDL, and XML.
• Hands-on experience with Azure DevOps for prioritizing and completing work in an agile methodology.
• Proven ability to design access control mechanisms and enforce data security standards.
• Experience with backup/recovery strategies and performance tuning for SQL Server.
• 5+ years of experience in database and integration tool development.

Preferred Skills

• Experience with Boomi or similar integration platforms.
• Ability to lead design review sessions and align solutions with architectural specifications.

Key Skills

Education

Bachelor's degree