Simpson Associates transforms raw data into actionable insights that drive positive change. Our Microsoft data expertise, our specialist sector knowledge, plus our innovative and trusted advice and guidance are just some of the reasons clients choose to work with us. Our mission is to help purpose-led organisations from within the public and private sectors to harness data as a lever for change and enable them to realise business value more quickly. We provide the full range of services to support organisations on their data transformation journey. We are a Microsoft Solutions Partner, holding Specialisations in AI Platform on Microsoft Azure, Analytics on Microsoft Azure, Data Warehouse Migration to Microsoft Azure and Migrate Enterprise Applications to Microsoft Azure, as well as holding Solutions Partner designations in Data & AI (Azure); Digital & App Innovation (Azure); Infrastructure (Azure) and Security. But it's not just about the badges. We are proud to be recognised as the winner of the 2024 Microsoft Community Response Partner of the Year award, reflecting our dedication to using technology for positive change. We are also a Databricks partner, and an IBM Gold Partner, specialising in Cognos Analytics and Planning Analytics. With offices in York and Sheffield, and a team based throughout the UK – we champion creativity, innovation and collaboration in the workplace.
Data Engineer
Location
United Kingdom
Posted
6 days ago
Salary
0
Seniority
Mid Level
Job Description
Data Engineer
Simpson Associates
Role Description The Data Engineer plays a pivotal role within the Delivery capabilities delivering high-quality solutions using Microsoft Fabric, Databricks and Azure-native technologies. The role may involve running projects independently or leading workstreams within larger and more complex engagements under the direction of a Principal Consultant. The Data Engineer is the primary point of contact for customers during delivery and is expected to combine strong technical capability with excellent consultancy, communication and leadership skills. You will be responsible for shaping solutions, guiding delivery teams, and ensuring projects are delivered to time, cost and quality expectations, while supporting the development of junior consultants. Key Responsibilities - Lead the end-to-end delivery of data engineering projects, either independently or as part of larger multi-disciplinary programmes. - Act as the primary service delivery contact for customers, building trusted relationships and providing clear technical leadership. - Demonstrate deep technical expertise in data engineering, understanding how solutions fit within wider customer architectures and business requirements. - Work with customers to identify, challenge and prioritise business and technical requirements, including running design and discovery workshops. - Translate functional and non-functional requirements into robust, scalable data platform architectures and technical designs. - Design and implement data engineering solutions using Microsoft Fabric and Databricks, following best-practice approaches. - Produce clear technical documentation and communicate designs using appropriate visualisations (e.g. architecture diagrams, data flows). - Accurately estimate delivery effort, contributing to proposals and addressing variances between pre-sales estimates and detailed requirements. - Convert estimates into delivery plans and manage these throughout the project lifecycle, working with Project Management and Scheduling as required. - Provide hands-on technical delivery alongside other consultants when appropriate. - Take overall responsibility for solution and delivery quality, including code reviews, testing strategies and customer acceptance. - Identify, manage and mitigate delivery risks and issues early, drawing on experience to pre-empt likely challenges. - Ensure appropriate deployment, handover and transition into support or managed services. - Mentor and support junior consultants, contributing to capability development within the Data Engineering team. - Contribute to intellectual property, reusable assets, marketing content, case studies and blogs. Qualifications - Strong experience designing and delivering modern data engineering solutions on Azure. - Hands-on expertise with Microsoft Fabric, including Lakehouse, Data Engineering and orchestration capabilities. - Strong experience with Databricks, including Spark-based data processing and optimisation. - Solid understanding of data modelling, data integration patterns, and ELT/ETL pipelines. - Experience working with Azure data services such as Azure Data Lake, Azure SQL and related platform components. - Knowledge of DevOps and deployment practices for data platforms (e.g. CI/CD, version control, automated testing). Requirements - Proven experience delivering projects within agreed time, cost and quality constraints. - Strong ability to communicate complex technical concepts clearly to both technical and non-technical stakeholders. - Experience leading delivery in both waterfall and agile environments and adapting approach to suit the customer and engagement. - Commercial awareness and consultative mindset, with the ability to identify additional opportunities and add value for customers. Personal Attributes - Confident, proactive problem-solver who remains calm and reassuring in customer-facing situations. - Strong organisational and time management skills, with the ability to manage multiple priorities simultaneously. - A proven self-starter, comfortable working independently while contributing positively to team delivery. - Commitment to continuous professional development and maintaining up-to-date technical and consultancy skills. - Willingness to mentor others and contribute to a collaborative, knowledge-sharing culture. Company Description Simpson Associates transforms raw data into actionable insights that drive positive change. Our Microsoft data expertise, our specialist sector knowledge, plus our innovative and trusted advice and guidance are just some of the reasons clients choose to work with us. Our mission is to help purpose-led organisations from within the public and private sectors to harness data as a lever for change and enable them to realise business value more quickly. We provide the full range of services to support organisations on their data transformation journey. We are a Microsoft Solutions Partner, holding Specialisations in AI Platform on Microsoft Azure, Analytics on Microsoft Azure, Data Warehouse Migration to Microsoft Azure and Migrate Enterprise Applications to Microsoft Azure, as well as holding Solutions Partner designations in Data & AI (Azure); Digital & App Innovation (Azure); Infrastructure (Azure) and Security. But it's not just about the badges. We are proud to be recognised as the winner of the 2024 Microsoft Community Response Partner of the Year award, reflecting our dedication to using technology for positive change. We are also a Databricks partner, and an IBM Gold Partner, specialising in Cognos Analytics and Planning Analytics. With offices in York and Sheffield, and a team based throughout the UK – we champion creativity, innovation and collaboration in the workplace.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer
ViaductMachine learning platform to empower OEMs and their partners to make vehicles safer, more reliable, and personalized.
• Creating and supporting batch, incremental, and real-time ETL pipelines • Standardizing ingestion, validation, and cleaning processes across clients • Automating data validation to increase data quality • Managing and evolving schemas in all parts of our pipeline • Monitoring, tuning, and optimizing Spark jobs • Becoming a domain-expert in connected vehicle data
Senior Data Engineer
Definitive Healthcare, USDefinitive Healthcare (NASDAQ: DH) is passionate about turning data, analytics, and expertise into meaningful intelligence that helps our customers achieve success and shape the future of healthcare. We empower them to uncover the right markets, opportunities, and people—paving the way for smarter decisions and greater impact. Headquartered just outside of Boston, Massachusetts. Operates across North America, Europe, and India. Supports a growing global client base of more than 2,400 customers since our founding in 2011. Earned multiple workplace honors, including Built In’s 100 Best Places to Work in Boston (2024 and 2025), a Stevie Bronze Award for Great Employers, and recognition as a Great Place to Work in India. Fosters a collaborative, inclusive culture where diverse perspectives drive innovation.
Role Description You’ll be joining a team of engineers to work on a broad spectrum of descriptive data sets related to providers across the healthcare continuum. Definitive Healthcare is a rapidly growing and fast-paced company, and it is essential that you are able to successfully manage multiple competing priorities. The ideal candidate for this position will identify problems, analyze information, and formulate creative solutions and processes. As a Senior Data Engineer, the projects that you and your team will tackle on a daily basis are dynamic and innovative by nature. You must be comfortable speaking up, sharing ideas, and driving change. What You’ll Do - Managing data coming from various sources and integrating data into our product utilizing expertise in SQL, Python, AWS Argo and/or Airflow workflows. - Integrating new data assets into our product and re-engineering existing data flows for optimal performance utilizing SQL, Python, and AWS workflows. - Adding value to our product through creativity and ability to explore innovative solutions pertaining to optimizing and operationalizing the ways in which we currently collect and transform data and regarding how to best incorporate new and evolving data sets based in your SQL and ETL expertise and familiarity with automation tools. - Working collaboratively with other engineers on large scale projects and serve as a mentor for junior engineers, helping them hone their technical acumen relating to SQL, Python and AWS. - Working closely with Product Management and Product Engineering teams on the development and engineering of our product and the complex data and data structures it contains. Additionally, partnering with teams to support the continuous evolution and growth of our product and its intricacy. Qualifications - 5+ years of professional experience, ideally in a data engineering role - Intermediate to advanced SQL proficiency - Experience using Python or a similar language - Experience using ETL tools. Preferably AWS Argo and/or Airflow. Nice to have SSIS. - Experience with data engineering, preferred within healthcare - Understand data modelling concepts - Familiar with code repos such as GitHub and/or Azure - Experience with database systems such as SQL Server and Postgres - Familiar with AWS S3 storage and Databricks unified data platform - Leverage AI tools to help facilitate code development - Desire to take on more responsibility and ownership of your work - Excellent analytical skills, including working with large data sets Benefits - The salary range for this position is $106,000 – $198,000 per year, which represents the base pay the company reasonably and in good faith expects to pay for this role. Actual pay within this range will be determined based on factors such as relevant experience, skills, and qualifications. - Depending on the position, employees may also be eligible to participate in a company bonus or commission plan. - All employees are eligible for a comprehensive benefits package, including medical, dental, and vision coverage. - Unlimited paid time off. - Participation in the company’s 401(k) plan with employer contribution. Company Description Definitive Healthcare (NASDAQ: DH) is passionate about turning data, analytics, and expertise into meaningful intelligence that helps our customers achieve success and shape the future of healthcare. We empower them to uncover the right markets, opportunities, and people—paving the way for smarter decisions and greater impact. - Headquartered just outside of Boston, Massachusetts. - Operates across North America, Europe, and India. - Supports a growing global client base of more than 2,400 customers since our founding in 2011. - Earned multiple workplace honors, including Built In’s 100 Best Places to Work in Boston (2024 and 2025), a Stevie Bronze Award for Great Employers, and recognition as a Great Place to Work in India. - Fosters a collaborative, inclusive culture where diverse perspectives drive innovation.
Data Specialist in Track Geometry
CentioCentios övergripande mål är att vara ett konsultbolag som erbjuder smarta och hållbara lösningar som utvecklar samhället på ett positivt sätt. Läs gärna mer om oss på centio.se.
Role Description Vi söker en Dataspecialist inom specialiststöd spårgeometri till Trafikverket. Detta är ett konsultuppdrag med möjlighet att arbeta på distans från hela Sverige. Uppdraget omfattar 60 % av en heltid. Uppdraget innebär ett nära samarbete med kunden vilket ställer stora krav på flexibilitet och samarbetsförmåga. Dataspecialisten arbetar med ajourhållning och specialiststöd inom spårgeometri samt stödjer verksamheten inom järnvägsdata, leverans av förvaltningsdata och kvalitetssäkring av levererad information. Rollen omfattar även arbete med import och export av spårgeometri samt utredning av kvalitetsbrister. Qualifications - Minst 4 års erfarenhet av verksamhet för spårprojektering - Mycket god IT-vana inom järnvägsområdet - Goda kunskaper inom järnvägsdataområdet - Flytande svenska i tal och skrift Requirements - Specialiststöd vid ajourhållning av spårgeometri - Specialiststöd till investeringsverksamhet vid leverans av förvaltningsdata - Importarbeten, d.v.s. koppla ihop ny levererad spårgeometri med befintlig spårgeometri i databasen - Exportarbeten, d.v.s. leverera ut beställda geometrier till projekt och underhållsarbeten - Mottagningskontrollera levererad data - Utreda befintliga kvalitetsbrister Benefits - Villkor anpassade för individen, inklusive arbetstider och arbetsomfattning - Kompetensutveckling anpassad utifrån medarbetarens behov - Arbete i små grupper för att bidra med och ta del av erfarenheter - Fokus på välmående och balans mellan arbete och fritid - Nollvision mot stress och prioritering av trivsel och hälsa
Senior Data Engineer – Snowflake, Amazon QuickSight
3Pillar GlobalBuilding digital businesses, together.
• Design, develop, and optimize scalable **ETL/ELT pipelines** for enterprise data platforms • Build and maintain robust data solutions using **Snowflake, Python, and AWS services** • Develop advanced SQL queries using **CTEs, window functions, query tuning, and performance optimization techniques** • Work with **Snowflake warehouses, tasks, streams, and data pipelines** for efficient data processing • Create and maintain data transformation workflows using **dbt (data build tool)** • Develop reporting datasets and support dashboarding solutions using **Amazon QuickSight** • Perform **data validation, data integrity checks, and root cause analysis** to ensure data accuracy and reliability • Integrate and manage data across platforms including **DynamoDB, S3, AWS Glue, Lambda, and Rockset** • Collaborate with cross-functional teams including analytics, product, and clinical stakeholders to support reporting requirements • Monitor pipeline performance and troubleshoot production data issues


