Design and build end-to-end data pipelines (batch and streaming) -from source extraction and ingestion through transformation, quality validation, and delivery. You own the data infrastructure, not just a piece of it.
Develop modern data transformation layers using dbt , implementing modular SQL models, testing frameworks, documentation, and CI/CD practices that ensure data quality and maintainability.
Build and orchestrate workflows using Microsoft Fabric, Apache Airflow, Dagster, Databricks Workflows, or similar tools to automate complex data processing at scale.
Architect lakehouse solutions using open table formats (Delta Lake, Apache Iceberg) on Microsoft Fabric, Snowflake, and Databricks-designing schemas, optimizing performance, and implementing governance frameworks.
Ensure data quality and observability -implementing testing frameworks (dbt tests, Great Expectations), monitoring, alerting, and lineage tracking that maintain trust in data assets.
Collaborate directly with clients to understand business requirements, translate data needs into technical solutions, and communicate architecture decisions to both technical and executive audiences.
Required Qualifications
2+ years (3+ years for Senior Associate) of hands-on experience building and deploying data pipelines in production -not just ad-hoc queries and exports. You've built ETL/ELT systems that run reliably and scale.
Strong SQL and Python programming skills with experience in PySpark for distributed data processing. SQL for analytics and data modeling; Python/PySpark for pipeline development and large-scale transformations.
Experience with modern data transformation tools , particularly dbt (data build tool). You understand modular SQL development, testing, and documentation practices.
Experience with cloud data platforms and lakehouse architectures -Snowflake, Databricks, and familiarity with open table formats (Delta Lake, Apache Iceberg). We're platform-flexible but Microsoft-preferred.
Familiarity with workflow orchestration tools such as Apache Airflow, Dagster, Prefect, or Microsoft Data Factory. You understand DAGs, scheduling, and dependency management.
Solid understanding of data modeling concepts : dimensional modeling, data vault, normalization/denormalization, and knowing when different approaches are appropriate.
Ability to communicate technical concepts to non-technical stakeholders and work effectively with cross-functional teams including data scientists, analysts, and business users.
Bachelor's degree in Computer Science, Engineering, Mathematics, or related technical field (or equivalent practical experience).
Flexibility to work in a hybrid model with periodic travel to client sites as needed.
Requirements
Experience in Financial Services, Manufacturing, or Energy & Utilities industries.
Background in building data infrastructure for ML/AI system
Benefits
Flexible schedule
Additional Information
Huron is a global consultancy that collaborates with clients to drive strategic growth, ignite innovation and navigate constant change. Through a combination of strategy, expertise and creativity, we help clients accelerate operational, digital and cultural transformation, enabling the change they need to own their future.
Join our team as the expert you are now and create your future.
Data Engineer
We're seeking a Data Engineer to join the Data Science & Machine Learning team in our Commercial Digital practice, where you'll design, build, and optimize the data infrastructure that powers intelligent systems across Financial Services, Manufacturing, Energy & Utilities, and other commercial industries.
This isn't a maintenance role or a ticket queue-you'll own the full data lifecycle from source integration through analytics-ready delivery. You'll build pipelines that matter: real-time data architectures that feed mission-critical ML models, transformation layers that turn messy enterprise data into trusted datasets, and orchestration systems that ensure reliability at scale. Our clients are Fortune 500 companies looking for partners who can engineer solutions, not just write SQL.
The variety is real. In your first year, you might architect a lakehouse solution for a global manufacturer's IoT data, build a real-time streaming pipeline for a financial services firm's trading analytics, and design a data mesh implementation for a utility company's distribution systems. If you thrive on solving complex data challenges and shipping production systems that ML teams and analysts depend on, this role is for you.
Huron Consulting · Belfast - 20 Adelaide Street