Sierra Solutions is a major healthcare organization seeking an ETL Engineer to drive data integration solutions within the cloud ecosystem. The role involves designing and implementing high-performing ETL/ELT pipelines using Azure Data Factory and collaborating with cross-functional teams to manage large volumes of data.
Responsibilities:
- Design, develop, deploy, and monitor robust ETL/ELT data pipelines using Azure Data Factory (ADF)
- Optimize data workflows across the broader Microsoft cloud ecosystem, leveraging Azure SQL Database, Azure Data Lake, Azure Blob Storage, and Azure Synapse Analytics
- Utilize strong SQL skills and data modeling concepts to process large datasets efficiently and maximize performance
- Manage version control and pipeline deployments seamlessly using Azure DevOps
- Partner with cross-functional teams to align data strategies while strictly adhering to cloud security best practices and compliance standards
Requirements:
- Hands-on experience with Azure Data Factory (ADF) pipeline design, development, and debugging
- Strong Provider Data experience working within a Health Plan / Payer environment
- Deep familiarity with Azure SQL, Data Lake, Blob Storage, and Synapse Analytics
- Advanced SQL writing capabilities, solid data modeling foundations, and experience managing large, complex datasets
- Exposure to Azure DevOps for CI/CD pipeline management and version control
- Excellent troubleshooting and debugging skills for complex data flows and integration anomalies