TC
ELT Developer
TechDigital Corporation
Location not stated
Remote
5 months ago
- Snowflake
- ELT
- ETL
- Data Modeling
- SQL
- Devops
- CI/CD
- Git
- Data Architecture
- Agile
- Salesforce
- ADO
5 months ago
Role Summary
The BI / ELT Developers will be responsible for leading the design, development, and delivery of enterprise‐grade data solutions with a strong focus onautomation, ETL orchestration (Matillion), database design(Snowflake) , and data transformations. This role will provide technical leadership across the data engineering lifecycle and partner closely with architects, API teams, QA, and business stakeholders to enable scalable and reliable data platforms.
Key Responsibilities
Technical Leadership
- Lead end‐to‐end data engineering delivery including ingestion, transformation, and persistence layers.
- Own technical decisions related todatabase architecture, schema design, and data modeling.
- Review and guide development of complex SQL, transformations, and performance‐optimized data pipelines.
- Act as the primary technical escalation point for data‐related issues.
- Design and implementMatillion/Snowflake ETL pipelines for structured and semi‐structured data.
- Build reusable, metadata‐driven transformation frameworks.
- Optimize data loads, transformations, and Snowflake performance.
- Ensure data quality, consistency, and reconciliation across pipelines.
- Driveautomation‐first approach across:
- ETL deployments
- Validation and reconciliation
- Regression and data sanity checks
- Enable CI/CD pipelines for data platforms (Git, automated deployments, environment promotion).
- Collaborate with DevOps teams to enforce coding standards and release controls.
- Reduce manual intervention through robust automation and monitoring.
- Design and maintain:
- Enterprise data warehouse schemas
- Fact and dimension models
- Conformed layer structures
- Partner with Data Architects to align logical and physical models.
- Ensure scalability, extensibility, and performance of data structures.
- Lead data engineering workstreams inAgile sprints.
- Support backlog grooming, estimation, and technical story readiness.
- Collaborate with:
- API teams for data consumption
- Salesforce/UI teams for downstream enablement
- QA for test data, automation, and validation strategy
- Actively participate in sprint ceremonies and technical reviews.
- Enforce data engineering best practices and standards.
- Ensure adherence to security, compliance, and data governance guidelines.
- Proactively identify risks, dependencies, and technical gaps.
- Contribute to RAID management and mitigation plans.
Must Have
- 10+ years of experience inData Engineering / BI / Data Platforms /Snowflake
- Strong hands‐on experience withMatillion/Snowflake
- Strong SQL expertise anddatabase design / data modeling
- Experience withdata transformations, large‐scale ETL pipelines
- Strong automation mindset and implementation experience
- Experience with cloud data platforms (Snowflake preferred)
- Agile delivery experience
- CI/CD for data platforms (ADO, Git, deployment automation)
- API data integration experience
- Data quality frameworks and monitoring
- Experience in healthcare, insurance, or enterprise data domains
- Strong ownership mindset
- Ability to mentor and guide data engineers
- Clear communication with technical and non‐technical stakeholders
- Proactive problem‐solving and risk identification
ELT Developer · TechDigital Corporation