Data Analyst

Smiths Group plc
Birmingham, United Kingdom
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Birmingham, United Kingdom

Tech stack

Microsoft Excel
Artificial Intelligence
Business Intelligence
Big Data
Databases
Data Validation
Data Governance
ETL
Relational Databases
Database Queries
Excel Formulas
Revision Control Systems
Python
Meta-Data Management
Query Optimization
Power BI
SAP Applications
SAP NetWeaver Business Warehouse
SAP NetWeaver Data Management
SQL Databases
Delivery Pipeline
Powerquery
Data Analytics
Star Schema
Software Version Control
Data Pipelines

Job description

  • 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.

Requirements

  • 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).

About the company

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.

Apply for this position