ELT Developer
TechDigital Group, Cary, NC, United States
Overview
Mandatory Skills: Matillion with Snowflake
The BI / ELT Developers will be responsible for leading the design, development, and delivery of enterprise‑grade data solutions with a strong focus on automation, 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.
Responsibilities
Technical Leadership
Lead end‑to‑end data engineering delivery including ingestion, transformation, and persistence layers.
Own technical decisions related to
database 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.
ETL & Data Engineering
Design and implement
Matillion/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.
Automation & DevOps
Drive
automation‑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.
Data Architecture & Modeling
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.
Agile Delivery & Collaboration
Lead data engineering workstreams in
Agile 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.
Governance & Quality
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.
Required Skills & Experience
Must Have
10+ years of experience in
Data Engineering / BI / Data Platforms /Snowflake
Strong hands‑on experience with
Matillion/Snowflake
Strong SQL expertise and
database design / data modeling
Experience with
data transformations , large‑scale ETL pipelines
Strong automation mindset and implementation experience
Experience with cloud data platforms (Snowflake preferred)
Agile delivery experience
Good to Have
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
Key Behaviors
Strong ownership mindset
Ability to mentor and guide data engineers
Clear communication with technical and non‑technical stakeholders
Proactive problem‑solving and risk identification
#J-18808-Ljbffr
Mandatory Skills: Matillion with Snowflake
The BI / ELT Developers will be responsible for leading the design, development, and delivery of enterprise‑grade data solutions with a strong focus on automation, 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.
Responsibilities
Technical Leadership
Lead end‑to‑end data engineering delivery including ingestion, transformation, and persistence layers.
Own technical decisions related to
database 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.
ETL & Data Engineering
Design and implement
Matillion/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.
Automation & DevOps
Drive
automation‑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.
Data Architecture & Modeling
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.
Agile Delivery & Collaboration
Lead data engineering workstreams in
Agile 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.
Governance & Quality
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.
Required Skills & Experience
Must Have
10+ years of experience in
Data Engineering / BI / Data Platforms /Snowflake
Strong hands‑on experience with
Matillion/Snowflake
Strong SQL expertise and
database design / data modeling
Experience with
data transformations , large‑scale ETL pipelines
Strong automation mindset and implementation experience
Experience with cloud data platforms (Snowflake preferred)
Agile delivery experience
Good to Have
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
Key Behaviors
Strong ownership mindset
Ability to mentor and guide data engineers
Clear communication with technical and non‑technical stakeholders
Proactive problem‑solving and risk identification
#J-18808-Ljbffr