Pearson Carter
Senior Data Engineer / Consultant
Position Summary
The Senior Data Engineer / Consultant is responsible for leading the delivery of data engineering engagements, ensuring high-quality technical outcomes, strong client collaboration, and effective support of delivery teams.
This role combines advanced data engineering expertise with consulting leadership. It is highly hands-on and delivery-focused, requiring autonomous execution and a strong billable contribution. The role also includes mentoring team members, contributing to solution design, and maintaining high engineering standards.
Key Responsibilities
Data Engineering
- Design, build, and maintain data pipelines and integrations across data lakes, lakehouses, and data warehouses
- Develop and optimise data transformations for reporting, analytics, and AI/ML use cases
- Apply data modelling techniques, including star and snowflake schemas
- Write, test, and maintain high-quality, well-documented, and performant code
- Troubleshoot and resolve technical issues efficiently
- Implement modern engineering patterns and well-architected principles
- Work with Databricks and related tools (e.g., Delta Live Tables, workflows)
Infrastructure & DevOps
- Lead the use of source control systems (e.g., Git, Azure DevOps)
- Design and maintain CI/CD pipelines and environment management processes
- Implement automated testing and data validation for pipelines
- Conduct performance testing and optimisation of data solutions
Testing & Quality Assurance
- Design and review unit and integration tests
- Ensure data accuracy, reliability, and performance through robust testing
- Maintain documentation of issues and resolutions
- Uphold engineering quality standards and best practices
- Contribute to improving internal frameworks, templates, and processes
Consulting & Client Engagement
- Act as the primary engineering contact for client engagements
- Lead technical discussions and contribute to requirements gathering
- Translate business needs into technical solutions and documentation
- Communicate progress, risks, and blockers to stakeholders
- Support project estimation, scoping, and planning activities
Leadership & Mentoring
- Lead delivery workstreams and ensure high-quality outputs
- Mentor and coach junior and intermediate team members
- Conduct peer reviews and enforce engineering standards
- Collaborate with architects on solution design
Continuous Improvement
- Contribute to internal knowledge sharing and team learning
- Stay up to date with modern data technologies and practices (AI/ML, cloud, visualisation)
- Support development of internal processes, templates, and documentation
- Engage in training and certification aligned with the organisation’s technology stack
Work Planning & Delivery
- Manage tasks and deliverables to meet timelines and quality expectations
- Provide accurate effort estimates and project input
- Maintain clear and timely reporting of progress and dependencies
- Participate in planning, review, and retrospective sessions
Health & Safety
- Adhere to workplace health and safety policies
- Ensure safe work practices for self and others
Key Outcomes
- Delivery of scalable, maintainable, and high-quality data solutions
- Strong leadership in planning, estimation, and documentation
- Effective client communication and collaboration
- Continuous improvement in engineering standards and practices
- Reliable, accurate, and well-tested data outputs
Skills & Experience
Required
- 6 years of experience in data engineering or a related field
- 4 years of hands-on experience with Databricks (including Delta Live Tables, notebooks, workflows)
- Strong proficiency in Python and SQL
- Experience with data modelling (star and snowflake schemas)
- Understanding of medallion architecture and scalable data design
- Experience with DevOps practices (CI/CD, version control, automation)
- Experience with testing and data quality frameworks
- Familiarity with data visualisation tools (e.g., Power BI or similar)
Preferred
- Exposure to Microsoft Fabric concepts
- Relevant certifications (e.g., Databricks Associate/Professional) or ongoing certification efforts
Personal Attributes
- Strong communication skills (verbal and written)
- High attention to detail
- Self-driven, proactive, and results-oriented
- Ability to manage multiple priorities and deadlines
- Strong problem-solving mindset
- Adaptable and flexible in a dynamic environment
- Excellent interpersonal and relationship-building skills