Senior Data Engineer

We believe in the power of ingenuity to build a positive human future.  

As strategies, technologies, and innovation collide, we create opportunity from complexity. 

Our teams of interdisciplinary experts combine innovative thinking and breakthrough technologies to progress further, faster. Our clients adapt and transform, and together we achieve enduring results. 

We are over 4,000 strategists, innovators, designers, consultants, digital experts, scientists, engineers, and technologists. And we have deep expertise in consumer and manufacturing, defence and security, energy and utilities, financial services, government and public services, health and life sciences, and transport.  

Our teams operate globally from offices across the UK, Ireland, US, Nordics, and Netherlands. 

PA. Bringing Ingenuity to Life. 

This is an exciting opportunity to join the internal Data and Analytics team within the Group Systems corporate IT function. As a Senior Data Engineer, you will lead the design and build of our business-critical Data and Analytics systems, helping us unlock predictive insights for strategic decision-making.

What We’re Looking For

We are seeking a proactive, highly skilled Data Engineer to deliver modern data solutions to solve complex business problems. You’ll have deep expertise in Microsoft Fabric and Microsoft Database technologies and use your knowledge to translate business requirements into technical solutions.

Key Responsibilities

• Lead small technical project teams to deliver solutions aligned with the business requirements
• Develop and deliver business change, alongside internal comms and handover to teams to ensure successful adoption
• Engage with senior stakeholders to understand high-level business goals and transform these into detailed functional and non-functional requirements
• Provide support and expertise to Identify and fix live issues

Hybrid working - our approach is to be in the office or on client site a minimum of 2 days per week. 

Key Skills and Experience

• Holds or eligible for UK Security Clearance (L2 – SC)
• Data Engineering & Fabric Development - Design and implement ETL/ELT data pipelines
• SQL Server – Develop, optimize and manage complex T-SQL queries, stored procedures, and functions using
• Tabular model development / DAX – create Power BI semantic models / Analysis Services including row-level security (RLS) and object-level security (OLS).
• Proven history of delivery and support of key financial and operational/management analytics.

Desirable Technical Skills

• Governance & Compliance - Microsoft Purview
• Building forecasting and predictive analytics - Azure Machine Learning

• Microsoft Certified: Fabric Analytics Engineer Associate, Azure Data Engineer Associate, Power BI Data Analyst Associate, SQL Server Database Administrator/Developer

We know the skill-gap and ‘somewhat need to tick every box’ can get in the way of meeting brilliant candidates, so please don’t hesitate to apply – we’d love to hear from you.

Apply today by completing our online application

Please be aware that some of our UK roles at PA Consulting require a UK security clearance.

All PA people are required to undergo background checks and to achieve the Baseline Personnel Security Standard however, some UK roles also require higher levels of National Security Vetting, where applicants must have at least 5 years of continuous residency in the UK.

We therefore ask that you only apply if you meet the residency requirements (i.e. you are a British citizen or have been resident in the UK for the past 5 years), as this is the prerequisite for a security clearance. If you're unsure about your eligibility, we encourage you to review the UK Government’s guidance on security vetting before applying.

Life At PA encompasses our peoples' experience at PA. It's about how we enrich peoples’ working lives by giving them access to unique people and growth opportunities and purpose led meaningful work. 

Our purpose guides how we work with our clients and our teams, and support our communities, to deliver insight and impact, solving the world’s most complex challenges. We're focused on building a workplace that values human difference and diverse mindsets, and a culture of inclusion and equality that unlocks the potential in our people so everyone can be their best self. 

Find out more about Life at PA here. 

We are dedicated to supporting the physical, emotional, social and financial well-being of our people. Check out some of our extensive benefits: 

• Health and lifestyle perks accompanying private healthcare
• 25 days annual leave (plus a bonus half day on Christmas Eve) with the opportunity to buy 5 additional days 
• Generous company pension scheme 
• Opportunity to get involved with community and charity-based initiatives 
• Annual performance-based bonus 
• PA share ownership 
• Tax efficient benefits (cycle to work, give as you earn) 

We’re committed to advancing equality. We recruit, retain, reward and develop our people based solely on their abilities and contributions and without reference to their age, background, disability, genetic information, parental or family status, religion or belief, race, ethnicity, nationality, sex, sexual orientation, gender identity (or expression), political belief, veteran status, or any other range of human difference brought about by identity and experience. We welcome applications from underrepresented groups. 

Adjustments or accommodations - Should you need any adjustments or accommodations to the recruitment process, at either application or interview, please contact us on [email protected] 

#LI-AG1