About the position
Senior Data Engineer
Full-Time | Office-Based | Fixed-Term Contract (possibility of permanent)
Role Purpose
The Senior Data Engineer / Data Warehouse Lead will design, develop, and govern the company’s enterprise data infrastructure. This role will drive the transition from the current SSIS-based ETL environment to a modern, scalable Azure-based cloud data warehouse.
As both a strategic and hands-on position, the role requires close collaboration with business leaders, BI developers, analysts, and IT teams to ensure solutions are business-aligned, compliant with governance standards, and ready to support advanced analytics. The successful candidate will mentor junior engineers, influence architectural decisions, and promote best practices across the organisation.
Key Responsibilities
1. Data Warehouse Architecture & Leadership
- Lead the design and implementation of the Azure-based enterprise data warehouse.
- Oversee optimisation of the existing SSIS-based ETL environment during transition.
- Define and execute the long-term data platform strategy with BI and IT leadership.
2. Data Governance & Compliance
- Own and enforce the data governance framework, covering quality, security, lineage, and access control.
- Partner with compliance and legal teams to ensure regulatory requirements are met.
- Implement and champion data cataloguing and metadata management solutions.
3. Collaboration & Stakeholder Engagement
- Translate business requirements into technical solutions by working with senior stakeholders.
- Act as the key liaison between BI, engineering, and external vendors for infrastructure matters.
- Facilitate workshops, architectural reviews, and cross-functional design sessions.
4. Technical Delivery & Mentorship
- Lead the build, testing, and deployment of robust ETL/ELT pipelines.
- Oversee smooth migration of historical and real-time data to the new warehouse with minimal downtime.
- Mentor junior and mid-level engineers, ensuring adherence to best practices.
5. Performance Monitoring & Continuous Improvement
- Implement monitoring and alerting tools to track system performance.
- Drive ongoing improvements in architecture, tooling, and governance.
Minimum Requirements
Education
Mandatory
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field.
Preferred
- Master’s degree in Data Engineering, Computer Science, or related discipline.
- Business Management or Project Management certification.
- Azure Data Engineer Associate (or equivalent cloud certification).
- Data Governance certification (DAMA, DCAM, or equivalent).
Experience & Technical Skills
Mandatory
- 5+ years in data engineering with strong experience in data warehouse design and delivery.
- Hands-on expertise with SSIS for ETL processes.
- Proven experience with Azure Data Platform components (Data Factory, Synapse Analytics, SQL Database, Data Lake).
- Advanced SQL (T-SQL preferred).
- Implementation of data governance principles (data quality, security, access controls, metadata management).
- Solid data modelling expertise (Kimball, Star Schema, Snowflake).
- Strong performance tuning and troubleshooting skills.
Preferred
- Experience with Python or other scripting languages for data processing/automation.
- Knowledge of Azure Purview or other cataloguing solutions.
- Experience with Azure DevOps and CI/CD pipelines for data solutions.
- Integration experience with Power BI and Azure datasets.
Competencies
Technical
- Expertise in designing and optimising ETL/ELT workflows.
- Skilled in working with large-scale, high-volume data sets.
- Strong problem-solving mindset with focus on automation and scalability.
- Proficient with version control tools (e.g., Git).
Behavioural
- Collaborative, able to connect technical and business perspectives.
- Strong leadership and mentoring capabilities.
- Excellent English communication and stakeholder management skills.
- Strategic thinker with strong delivery focus.
- Adaptable and resilient in a fixed-term, high-delivery environment.
Desired Skills:
- Azure
- Data Engineer
- SQL Database
- SSIS for ETL processes
