Data Analyst in Birmingham

Smiths Group designs, manufactures and delivers smarter engineering solutions for mission‑critical applications, solving some of the world's toughest problems for our customers, our communities and our world. For over 170 years, Smiths Group has been pioneering progress by improving the world through smarter engineering. We serve millions of people every year, to help create a safer, more efficient and better‑connected world, across four major global markets: Energy, General Industry, Security & Defence, and Aerospace. Listed on the London Stock Exchange, Smiths employs 14,600 colleagues in over 50+ countries. This pioneering spirit continues to drive us today, underpinned by our powerful culture.

Improving our world is what we do, how we think, and how we will continue to use our passion for technology and engineering to tackle our customers' biggest challenges today and in the future. We’re looking for people with curious minds who want responsibility and relish a challenge. Whether you’re an experienced professional or just starting out, our global scale and focus on growth means we have some great career opportunities for you. There’s never been a better time to join Smiths.

Responsibilities:

• Design, build and deploy interactive Power BI dashboards and reports.
• Develop robust data models using star schema and dimensional modelling principles.
• Create and optimise DAX measures for performance and scalability.
• Deliver ETL processes across SAP, databases and other data sources.
• Gather and translate business requirements into analytical solutions.
• Ensure data accuracy, consistency and governance across reporting layers.
• Optimise report performance, including query tuning and dataset management.
• Work with large datasets using SQL and, ideally, Python.
• Support deployment pipelines and version control practices.
• Troubleshoot data and reporting issues to ensure timely resolution.
• Implement data validation, cleansing and reconciliation processes.
• Maintain and enhance existing Power BI assets in line with evolving business needs.
• Establish data quality checks and monitoring mechanisms.
• Use advanced Excel (Power Query, complex formulas, data modelling) to support reporting and automation.

Qualifications Required Skills & Experience:

• Significant experience in Data Analytics or BI development.
• Strong expertise in Power BI (Desktop & Service) and proficiency in DAX and Power Query (M).
• Strong SQL skills and experience with relational databases.
• Solid understanding of data modelling (Kimball / Star Schema).
• Hands‑on experience with SAP data (ECC, BW extracts).
• Knowledge of ETL processes and data pipelines.
• Strong analytical and problem‑solving skills.
• Ability to communicate insights clearly to non‑technical audiences.

Preferred Skills:

• Experience working in large enterprise data environments.
• Understanding of data governance, lineage and metadata management.
• Familiarity with version control tools.
• Awareness of AI/ML use cases in analytics.
• Strong stakeholder management and communication skills.
• Experience in Energy, Manufacturing or Supply Chain sectors.
• Understanding of SAP functional areas (Finance, Procurement, Supply Chain).

Diversity & Inclusion:

We believe that different perspectives and backgrounds are what make a company flourish. All qualified applicants will receive equal consideration for employment regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, economic status, disability, age, or any other legally protected characteristics. We are proud to be an inclusive company with values grounded in equality and ethics, where we celebrate, support, and embrace diversity.