BI Developer

Your future, as a BI Developer at mydentist

You’ll be joining our Tech and Transformation Team within our Support Centre

- The role is permanent and full time

- Working within a high performing team.

- Close to public transport links

Your future, with us

Working at mydentist means you’ll be part of the UK’s leading dental network. Here, you’ll be trusted to do your best work, balancing your career around your life. We’re ambitious, focusing on the big picture and transforming how we deliver dentistry. Supported by a talented and driven team everyone is free to be themselves, where respect is a given and we’re always there for one another.

Data model and report development

• Design, build and maintain dimensional data models and Power BI semantic models on Microsoft Fabric (conceptual, logical and physical)
• Develop reports, dashboards and data visualisations that help stakeholders understand key business metrics·
• Develop data products in MS Fabric and MS Power BI, using Python / PySpark notebooks and Fabric pipelines where needed
• Design models to be fit for purpose beyond reporting, so they can be reused by other products such as AI solutions and web services

Data integration and transformation

• Work with wider engineering colleagues to ingest and transform data from multiple source systems, including practice management systems (R4, Dentally)
• Translate raw data into model-ready structures and define source-to-target mapping and transformation logic
• Use Python, PySpark and Fabric services (Data Factory pipelines, notebooks, Dataflows Gen2, Lakehouse) to automate and transform data

Data quality and validation

• Profile and validate data for accuracy, completeness and consistency; set up proactive checks and report issues to data owners to drive remediation
• Identify and fix data inconsistencies, report errors and performance issues, optimising models and reports

Stakeholder collaboration

• Engage with business users to understand reporting and analytical needs and deliver tailored BI solutions
• Support formulation of project artefacts such as plans and design documents

Support and troubleshooting

• Work with the wider support team and end users to troubleshoot issues and incidents, resolving BI-related issues in a timely manner
• Hand over supportable, documented products to the support team

Agile delivery, documentation and standards

• Work as part of an agile delivery team (stand-ups, sprint planning, retrospectives), tracking work in Jira and Confluence
• Document models, definitions, data dictionaries, data flows and metadata; create conceptual, logical and physical design documents·
• Follow and help enforce data modelling standards, governance and peer review practices

• Experience in BI development, data modelling or a related field
• Proven track record of building dimensional models and Power BI semantic models on MS SQL across multiple source systems
• Experience building data transformations and pipelines, ideally using Python / PySpark on Microsoft Fabric
• Proficiency in SQL for querying and transforming data, with strong data modelling techniques (conceptual, logical, physical)
• Working knowledge of Python and PySpark for data transformation and automation
• Familiarity with Fabric services for pipelines, automation and transformation (Data Factory, notebooks, Dataflows Gen2, Lakehouse)
• Exposure to Microsoft Fabric apps, a newer service, is desirable
• Understanding of DAX and Power BI optimisation, and of data warehouse and lakehouse concepts
• Familiarity with making data models fit for purpose for use by other products such as AI and web services
• Experience with source-to-target mapping, model documentation and agile delivery (Jira, Confluence)
• Effective communication skills; able to bridge technical concepts and business needs
• Enjoy being part of a team that’s passionate about supporting our practices and ultimately heling the nation smile.

Your future starts here

Build a fulfilling career with us, where you'll find the opportunity to develop your skills and shape your work life with the support of a caring and inclusive team who support one another.

Click to apply now!

MYDSC

• Competitive salary
• Holidays rising to 30 days per year with service (plus bank holidays)
• Annual Support Centre bonus scheme
• Health and wellbeing benefits; including a virtual GP service and Employee Assistance Programme helpline which includes free counselling sessions
• Access to fantastic discounts at cinemas, major retail brands, restaurants and coffee chains - simple and easy to access making it possible to save hundreds of pounds a year
• Recognition schemes including Support Centre Heroes and service awards