Senior ETL Developer (Azure & MDM/Reltio Focus)
Indexed description
What We Offer
- Flexible time off policy
- 401K Company match (up to 4% - dollar for dollar)
- Professional development, training, and tuition reimbursement programs
- Excellent medical, dental, vision, and life insurance policy options
- Opportunities for career advancement with an industry leading company!
The ideal candidate has strong hands-on experience building enterprise-grade data pipelines, integrating complex data sources, and ensuring high data quality and governance across analytical and operational systems.
This position will be able to work remotely from anywhere in the United States but the ability to work East Coast hours is strongly preferred.
Key Responsibilities
Data Integration & ETL Development
- Design, develop, and maintain ETL/ELT pipelines using Azure Data Factory and Microsoft Fabric Data Pipelines
- Build scalable data ingestion frameworks for structured and semi-structured data (SQL, APIs, flat files, streaming sources)
- Develop transformations using Synapse SQL, Spark (Synapse/Fabric), or Dataflows Gen2
- Optimize pipeline performance, reliability, and cost efficiency
- Develop and manage solutions leveraging:
- Azure Synapse Analytics (dedicated & serverless pools)
- Microsoft Fabric (Lakehouse, Warehouse, Data Engineering experiences)
- Azure Data Lake Storage Gen2
- Implement medallion architecture (Bronze/Silver/Gold layers) where applicable
- Collaborate with architects to design scalable data platform solutions
- Design and implement MDM integration workflows with Reltio
- Build and maintain pipelines to ingest, synchronize, and publish master data
- Work with business and data governance teams on:
- Data quality rules
- Matching and survivorship logic
- Golden record management
- Integrate Reltio with downstream analytics and operational systems
- Implement data validation, cleansing, and lineage tracking
- Ensure compliance with governance policies and standards
- Support auditing, monitoring, and alerting for data pipelines
- Work closely with data architects, analysts, and business stakeholders
- Participate in Agile delivery (Scrum/Kanban)
- Mentor junior developers
- Contribute to coding standards and best practices
- Participate in a rotating on-call support schedule for production data pipelines and platforms
- On-call coverage begins as early as 5:30 AM and includes weekend support as needed
- Each rotation lasts two weeks, approximately four times per year
- Troubleshoot and resolve production issues, ensuring minimal disruption to business operations
- Perform root cause analysis and implement long-term fixes for recurring issues
- Bachelor’s degree or equivalent experience
- 5–8+ years of experience in ETL/data engineering
- Strong expertise in:
- Azure Data Factory (ADF) – pipelines, triggers, integration runtimes
- Azure Synapse Analytics – SQL, Spark, pipeline orchestration
- Microsoft Fabric (preferred or emerging experience)
- Solid experience with:
- SQL (advanced query tuning and development)
- Python and/or PySpark
- REST APIs and data integration patterns
- Hands-on experience with Reltio MDM including:
- Data model configuration
- Match & merge rules
- Data onboarding and outbound integrations
- ETL/ELT design patterns
- Data warehousing and dimensional modeling (Kimball, Data Vault familiarity a plus)
- Data lake architectures
- Performance tuning and scaling
- Experience with:
- Delta Lake / Lakehouse architecture
- CI/CD for data pipelines (Azure DevOps, Git integration)
- Infrastructure as Code (ARM, Bicep, Terraform)
- Data governance tools (Purview or similar)
- Certifications (nice to have):
- Azure Data Engineer Associate
- Fabric Analytics Engineer (emerging)
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search