Data Analytics Developer

Working closely with our Azure Data Engineer, Power Platform specialists and business stakeholders, you will:

• Design and develop robust data models, semantic models, datasets, dashboards and analytics products.
• Build and enhance solutions using Microsoft Fabric, including lakehouses, warehouses, pipelines and notebooks.
• Create engaging and insightful Power BI dashboards that support operational and strategic decision making.
• Help develop and mature EWR’s enterprise data lake, ensuring data is governed, accessible and AI-ready.
• Support the development of Fabric Data Agents, Microsoft Foundry solutions and AI-enabled analytics products.
• Work directly with stakeholders to translate business challenges into practical data solutions.

• Contribute to data governance, security, documentation and continuous improvement across our analytics estate., This is much more than a reporting role. You’ll be helping shape the future of EWR’s data and AI capability, working with modern Microsoft technologies in a collaborative, ambitious and forward-thinking environment. You’ll have the opportunity to:

• Influence the development of our enterprise data platform.
• Work with cutting-edge Microsoft Fabric and AI technologies.
• Collaborate with talented technical specialists across data, automation and digital delivery.
• See your work directly impact business decisions and organisational performance.
• Grow your expertise in one of the UK’s most exciting infrastructure programmes.

• Experience with Microsoft Fabric including lakehouses, warehouses, pipelines, notebooks and semantic models.
• Advanced Power BI skills, including dashboard development, data modelling, DAX measures and reporting best practices.
• Strong data modelling and data engineering experience, including SQL, data ingestion, transformation and pipeline development.
• Experience working with modern data platforms and collaborating with data engineering teams.
• Excellent stakeholder engagement skills and the ability to turn complex requirements into meaningful insights.
• Knowledge of data governance, security, permissions, lineage and enterprise reporting standards.

Ideally, you’ll also have exposure to:

• Microsoft Foundry
• Fabric Data Agents and AI-enabled analytics
• Service Principals and Azure App registrations
• API integrations and token-based authentication
• Agile delivery environments.

• Competitive salary that reflects your skills and experience
• Up to 12% employer pension contribution to support your future
• 36 days annual leave (including bank holidays) plus the option to buy up to 2 extra days
• 2 volunteering days, a chance for you to give back to the community
• Enhanced family-friendly policies to support you and your loved ones
• Life assurance (4x your annual salary) for peace of mind
• Employee Assistance Programme for confidential support when you need it
• Access to Perkbox for a wide range of discounts and wellbeing benefits
• Recognition programme, including on-the-spot and annual awards
• Advanced learning and development opportunities to help you grow.

East West Rail is a nationally significant railway project which aims to deliver much-needed transport connections for the vibrant communities between Oxford, Milton Keynes, Bedford and Cambridge. Together these communities contribute around £111 billion to the national economy each year.

EWR is one of the UK’s largest infrastructure projects, which the government committed to delivering in full in the Autumn 2024 Budget, and again in the 2025 Spending Review as part of its ambition to unlock the potential of the Oxford to Cambridge Growth Corridor.

Role Summary:

As we continue to build a modern, data-driven organisation, we’re looking for a talented Data Analytics Developer to join our growing Data Centre of Excellence (DCoE). This is an opportunity to work at the forefront of Microsoft’s data and AI ecosystem, helping to develop innovative analytics solutions that drive real business value. You’ll play a key role in expanding our Microsoft Fabric capability, supporting the evolution of our enterprise data lake, and helping prepare EWR for the next generation of AI-powered decision making., East West Railway Company is a new and exciting venture at the forefront of the changing landscape of the rail industry, delivering substantial fast-paced improvement to modernise the railway.