ETL Lead Developer
Education and Experience Required: Bachelor's degree in IT, Computer Science, Data Engineering, or related field (or equivalent experience). 7+ years developing/supporting ETL, ELT, data integration, engineering, or warehouse solutions. 3+ years in senior developer/technical lead role for complex data integration delivery. Hands-on experience with CI/CD (Azure DevOps), Snowflake, Matillion, Microsoft Azure, Microsoft SQL Server. Leadership in design, code review, release coordination, troubleshooting, and mentoring. Preferred: Master s degree in related fields. Experience in regulated industries (healthcare, insurance, finance) with strong compliance requirements. Experience migrating legacy ETL platforms to Snowflake and Azure. Experience integrating multiple data sources (databases, flat files, APIs, SaaS, vendor feeds). Relevant certifications (SnowPro, Matillion, Azure Data Engineer, etc.). Experience working with agile teams, MSPs, offshore partners, vendors, stakeholders. Key Knowledge and Skills Snowflake: Advanced SQL, warehouse management, file handling, performance & cost optimization, security. Matillion: Advanced orchestration, job management, reusable components, error handling, deployment. Azure: Data and integration services, cloud security, secrets management, deployment automation. Strong understanding of ETL/ELT architectures, batch/incremental loading, CDC, slowly changing dimensions. Ability to translate business/data requirements into integration designs. Knowledge of data warehousing concepts: dimensional modeling, normalization, data lakes, reporting layers. Data quality and audit frameworks, including lineage, control totals, exception processing. Secure engineering for sensitive data: encryption, least privilege, masking, logging, environment separation. Git and Azure DevOps-based source control and deployment processes. Diagnosing complex issues across data, application, database, network, authentication. Familiarity with SDLC, DevOps, change/incident/problem management, production support. Leadership in technical design, standards, mentoring, and influencing delivery. Soft Skills Strong analytical, organizational, and prioritization skills. Excellent communication for technical and non-technical audiences. Ability to work within agile, waterfall, hybrid, and ITIL-based models.