Data Analyst

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

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Smithsgroup2? Share your experience