Join us in shaping the future of sustainable housing. We're building a cutting-edge regional data platform that unites retrofit programme data from local authorities, contractors, and IoT telemetry to drive smarter decisions and demonstrate real-world impact. As a Data Engineer, you'll design and develop scalable data pipelines and dimensional models on an enterprise-grade data lake, enabling high-quality, insight-rich datasets and APIs. Your work will power dashboards and reporting tools that help partners track outcomes, measure value, and accelerate carbon reduction. If you're passionate about data, innovation, and making a tangible difference, we want to hear from you! Please note, this is a fixed term contract for a period of 12 months. What you will be doing. Design and develop Extract, Transform and Load (ETL) pipeline processes to automate the access to source data, quality check and increase the usage. Asist with the development of new data analysis and reporting systems. Develop Dimensional Data Models using various frameworks. To analyse various datasets, seeking to correlate and integrate these with other secondary and primary data sources in order to generate insight. To identify and obtain key data sets that will add enhance insight. Assist development and maintenance of the data platform, tools and data library. Model, map and document data and processes from source through to utilisation within business processes. Assist with the operation and maintenance of data portals to enable data access for users whilst supporting data licensing and GDPR compliance. Respond efficiently to requests for intelligence from colleagues, partners and stakeholders as appropriate. What’s essential. Extensive working experience using Azure Synapse Analytics and Azure Data Factory Experience using GIS in a commercial or public sector environment and building mapping-based data analysis solutions Programming and scripting experience (e.g. FME, Python, DAX, JavaScript etc) to extract, transform and manage data Experience of data capture, analysis and management of complex datasets across a variety of applications from a variety of sources (API’s etc.) Experience of collecting and validating intelligence, assessing the credibility of information and reliability of sources Extensive experience using the Microsoft business intelligence stack e.g. Power Platform, SQL Server, SSAS, SSRS etc. Detailed understanding of underlying database technologies (SQL Server) including SQL syntax and queries Evidence of working as a member of a team to ensure shared goals are achieved Ability to prioritise own workload effectively, prioritising and working to tight deadlines DAX programming skills: ability to construct new data models, and create complex measures to deliver valuable insight High level of accuracy and attention to detail Demonstrate legal understanding of data licensing Knowledge of the relevant Acts of Parliament and related legislation for data protection Strong analytical and problem-solving skills, with the ability to analyse data, determine data quality and apply the findings using and developing PC based analysis and graphics software Excellent communication and interpersonal skills to interact with internal and external partners in a diplomatic and professional manner Excellent verbal, presentational and report writing skills, utilising multiple channels including desktop and web based tools and comfortable communicating with a wide range of audiences Ability to determine and develop appropriate data visualisation to communicate data meaning effectively and efficiently Educated to Degree level or equivalent Location. The location for this role is 16 Summer Lane, Birmingham, B19 3SD with at least 2 days a week spent in the office. How to apply. Applying for a role with WMCA is straight forward. Follow these steps to get started. Create your Careers Account. Register with your name, email address, and a password. Build your Profile. Upload your CV to help populate your career and education details. Write your Supporting Statement. Make sure to address each of the required essential criteria. Submit your application. Do one final check and once complete, click submit. Anonymised Applications. Your uploaded CV won’t be visible after submission. Our process is anonymised, and only the information in your profile is used for shortlisting. Be thorough in each section. it’s your chance to showcase your skills and experience. Using Artificial Intelligence (AI) We cannot stop anyone from using AI help write application content. Used right, it can be a great tool. If you choose to use AI, then use it as a helper rather than relying on it wholly to write your application. Applications that rely too heavily on AI may be rejected during shortlisting. For help on how to write a supporting statement, please visit the FAQs section of our careers site. Reasonable adjustments. If you have an accessibility need, disability, or condition that means you might require changes to the application or recruitment process, please get in touch with our Recruitment Team ( careers@wmca.org.uk ). Salary and benefits. We advertise salary ranges, with new appointments typically starting at the lowest salary point. In exceptional cases, the salary point may be adjusted to secure the best candidate. This approach allows for potential year-on-year salary increases, offering progression and appropriate rewards to employees. Requests for salaries above the maximum advertised range will not be considered. We offer a comprehensive benefits package that includes: Local Government Pension Scheme ( one of the most generous pension schemes in the UK ). 28 days paid annual leave (with an option to purchase more) EV car benefit scheme Ethical saving options and healthcare plans. Discounted gym membership, will writing and mortgage advice. An option to buy a bicycle, including e-bikes and adapted pedal cycles, at a discounted rate. 3 days of paid leave each year to volunteer. Interest free financing through SmartTech to buy the latest technology Discounted shopping with over 2,000 big-name retailers, and more. For more information, please visit the benefits page on our career site. Why join WMCA? WMCA is laser-focused on improving the West Midlands, bringing economic growth, jobs, homes, and better journeys to the region. We target local needs where it matters most, ensuring everyone has a job that pays well and has access to safe and affordable places they can call home. We put people and place at the heart of everything we do, working hand in hand with our partners to direct funding where it's needed most. What you do, really matters. Your expertise will help make a big difference, improving people's lives, every day. Creating an inclusive workplace. WMCA holds diversity accreditations, such as the RACE Code Quality Mark, Armed Forces Covenant (Gold status) and has been recognised as one of the Inclusive Top 50 Employers and The Times Top 50 Employers for Women. We’re a Disability Confident Employer with ‘Leader’ status, committed to interviewing applicants with disabilities who meet all the essential role criteria. We recognise that certain groups, such as women and people of colour, may be less likely to apply for roles if they feel they do not meet all the requirements. However, we encourage individuals who are passionate about the role and want to make a difference to still apply. We value potential and encourage applicants to highlight their skills, including transferable ones, even if they don't fit the traditional "perfect candidate" mould. We gladly consider part-time, flexible, and job share arrangements, so please don't let these factors deter you from applying Right to Work in the UK Proof of Right to Work in the UK will be required for all applicants in accordance with UK Home Office requirements, before any employment offer can be confirmed. Non-UK applicants (excluding Ireland) would be required to hold a relevant Visa from the UK Visas and Immigration (UKVI). Attached documents Data Engineer - JD.pdf