Data Engineer - Informatica
Senior Data Engineer - Informatica
Whitehall Resources currently require an experienced Data Engineer to work with a key client based in London
**Please note this role falls INSIDE IR35**
What you’ll do
• Engineer production grade data pipelines on AWS (EMR, S3, Lambda), using PySpark/Python and SQL, with a focus on performance, resilience, testing, and observability.
• Migrate and modernise legacy workloads (e.g., ETL jobs and reporting feeds) onto cloud native services, creating reusable components and shared frameworks.
• Support reporting & MI use cases, including transformations and data models that feed downstream tools (e.g., Power BI).
• Own CI/CD and version control practices (e.g., Git/GitLab), review code, and enforce engineering standards.
• Coach and mentor engineers, provide technical guidance/code reviews, and contribute to architectural decisions across squads.
• Work in Agile delivery, collaborating across product, data, and platform teams using Jira/Confluence; translate requirements into robust engineering tasks.
• Embed security and compliance by design, aligning with BPSS/SC constraints and department data handling policies.
Essential skills & experience
• Hands on expertise in AWS & Spark: Amazon EMR, S3, Lambda; strong PySpark/Python and SQL for large scale batch processing.
• Data engineering at scale in government or similarly complex domains, including performance tuning and data quality management.
• CI/CD & DevOps: pipelines and IaC (e.g., Terraform), automated testing, and release governance.
• Version control & collaboration: Git/GitLab, code review, branching strategies, and trunk/PR workflows.
• APIs & integration: building/consuming data services to move and expose data safely and reliably.
• Agile ways of working with Jira/Confluence; clear stakeholder communication and concise technical documentation.
• Security clearance: BPSS (minimum) and SC cleared or SC clearable for UK government work.
Desirable
• Data warehousing & modeling (e.g., Redshift; dimensional modeling; dbt).
• Basic Power BI familiarity to partner with BI developers and validate end to end data flows.
• AWS ecosystem depth (Athena, Redshift, EC2, CloudWatch, IAM) and event driven patterns.
Certifications (nice to have)
• AWS Certified Cloud Practitioner (or higher), Azure AI Fundamentals (awareness of ML/AI services).
SFIA Level 4 (Enable) alignment
• Autonomy: Works under general direction; plans own work; designs and implements PySpark jobs on EMR, modernising legacy code with minimal supervision.
• Influence: Shapes standards through code reviews and mentoring; influences delivery outcomes across teams.
• Complexity: Handles substantial, multifaceted engineering tasks (e.g., migration to new MI platform; data quality resolution; estimating effort).
• Business skills: Communicates effectively with stakeholders; aligns data products to reporting/decision making needs; contributes to Agile ceremonies.