First seen by Alion on Nov 17, 2026.
- 1-year contract, renewable
- Government project
- Hybrid work arrangement
About the Role
We are seeking a Data Engineer to join the data team at a government agency. You will design and build data models, curated datasets and pipelines that support business intelligence, analytics and data science.
Working closely with business stakeholders, you will translate business needs into reliable, well-structured and reusable data products. The technology stack is primarily built on Databricks and AWS.
This role focuses on analytics engineering: shaping data for business use and building dependable ingestion and transformation pipelines.
Key Responsibilities
- Engage business stakeholders to understand their requirements and translate them into data models, datasets and pipelines.
- Design and develop data models and transformation pipelines to integrate, clean, harmonise and curate data from multiple source systems.
- Build and maintain scalable, reliable and reusable pipelines using Databricks, Apache Spark and SQL.
- Design datasets and data structures for downstream reporting, analytics and data science use cases.
- Implement data quality checks, validation and reconciliation to support accurate and consistent data.
- Monitor pipeline performance and troubleshoot operational issues.
- Document data models, datasets, transformations and pipeline dependencies.
- Work with data engineers, analysts and data scientists to deliver solutions that meet business needs.
Requirements
- Strong proficiency in SQL, with experience in relational databases and data warehousing.
- Strong experience in data modelling, including dimensional modelling and the design of analytical datasets.
- Proficiency in Python for data processing and pipeline development.
- Hands-on experience with Databricks, Apache Spark and Delta Lake.
- Ability to work with business stakeholders, understand business processes and translate requirements into technical data solutions.
- A degree in Computer Science, Information Technology, Data Engineering or a related discipline.
Preferred Qualifications
- Experience designing and developing ETL/ELT pipelines and data transformation workflows.
- Experience with AWS data services and cloud-based data platforms.
- Familiarity with Git, CI/CD and data pipeline orchestration.
- Experience with Databricks Workflows and Unity Catalog.
- Experience designing data products for business intelligence and self-service analytics.
- Familiarity with data governance, access control and data quality practices.
- Experience working in a government or other highly regulated environment.
We are particularly interested in candidates who can use SQL and Python to structure data around business needs. Experience focused mainly on infrastructure provisioning or platform operations is less relevant to this role.
/Ref: T24-291
Skills
Apache Spark, Data Modelling, Data Analysis, ETL Tools, Pipeline Management, Data Pipeline, Business Process Development, Databricks, requirements from stakeholders, Computer Science, data consistency, Analytics, Cloud-Based Platform, Dimensional Modeling, Data Warehousing, computational skills

