BI Developer

We're supporting a client looking for an experienced BI Consultant/Developer with strong Microsoft Dynamics and Power BI expertise to help design and deliver a scalable reporting and analytics platform.

This role requires someone who can bridge the gap between business stakeholders and technical teams, working across the full BI lifecycle from requirements gathering and data modelling through to dashboard delivery and reporting governance.

• Gather reporting requirements through stakeholder workshops
• Design and develop data warehouses, reporting marts and analytical data models
• Build scalable ETL processes and data pipelines
• Create dimensional models, fact tables, dimension tables and star schemas
• Develop Power BI semantic models, dashboards and reports
• Write and optimise DAX measures and Power Query transformations
• Define KPIs, metrics and reporting standards
• Improve reporting governance, data quality and consistency
• Extract, model and report on Microsoft Dynamics CRM/ERP data
• Develop reusable reporting platforms and self-service BI capabilities
• Deliver operational, management and executive reporting

• Strong SQL Server experience
• Microsoft Dynamics 365 (CRM and/or ERP) reporting and data modelling experience
• Data warehousing and analytical data modelling
• Dimensional modelling and star schema design
• ETL design and implementation
• Power BI semantic models
• DAX and Power Query
• KPI and metric definition
• Reporting governance and data quality
• Requirements gathering and stakeholder management
• Operational and management reporting
• Experience building enterprise BI platforms rather than standalone reports

• £400 per day
• Outside IR35
• Initial 3-month contract
• 2-3 days onsite in Rugby for the first 2 weeks
• Predominantly remote thereafter
• Immediate start preferred

This is an excellent opportunity for a hands-on BI professional with a strong Microsoft stack background who can unlock value from Dynamics data and deliver meaningful business reporting.