Data Analyst
Birmingham - UK
Job Summary
Key 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).
Handson experience with SAP data (ECC BW extracts).
Knowledge of ETL processes and data pipelines.
Strong analytical and problemsolving skills.
Ability to communicate insights clearly to nontechnical 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).
Additional Information :
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.
At no time during the hiring process will Smiths Detection Smiths Group nor any of our recruitment partners ever request payment to enable participation including but not limited to interviews or testing. Avoid fraudulent requests by applying jobs directly through our careers website (Careers - Smiths Group plc)
We believe that different perspectives and backgrounds are what make a company flourish. All qualified applicants will receive equal consideration for employment regardless of 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.
At no time during the hiring process will Smiths Group nor any of our recruitment partners ever request payment to enable participation including but not limited to interviews or testing. Avoid fraudulent requests by applying jobs directly through our careers website (Careers - Smiths Group plc)
Remote Work :
No
Employment Type :
Full-time
About Company
Smiths Group is a global technology company that delivers solutions for the worlds evolving challenges. With a history spanning over 170 years, we operate across multiple sectors, including healthcare, energy, defense, and manufacturing. Our five divisionsJohn Crane, Smiths Detectio ... View more