Data Analyst Information Technology - Smiths Group - Pune

Smiths Group plc; Pune District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Smiths Group plc in Pune seeks a Power BI Developer / Data Analyst with 5–8 years of experience to design, develop, and maintain scalable data models and dashboards. You will work with business stakeholders to translate requirements into analytics that support decision-making.

Key duties include building dashboards, star-schema data models, DAX optimization, and ETL from SAP and other sources. Strong Excel, Python, and data governance skills are required.

Qualifications

• 5–8 years of experience in Data Analytics / BI development.
• Strong expertise in Power BI (Desktop & Service) and DAX.
• Proficiency in SQL and data modeling (Kimball / Star Schema).
• Experience with SAP data sources (ECC, BW) and ETL concepts.
• Excellent communication of insights to non-technical stakeholders.

Responsibilities

• Design, develop, and deploy interactive dashboards and reports using Power BI.
• Build robust data models using star schema / dimensional modeling.
• Develop and optimize DAX calculations and measures for performance.
• ETL data from SAP, databases, and other sources; ensure data quality and governance.
• Collaborate with business users to translate requirements into analytical solutions.
• Maintain and optimize Power BI assets, dashboards, and datasets.

Skills

Power BI

DAX

SQL

Excel

Python

ETL

Tools

SAP

SAP ECC

BW extracts

Job description

At Smiths we apply leading-edge technology to design, manufacture and deliver smarter engineering solutions for mission-critical applications, solving some of the world's toughest problems for our customers, our communities and our world. We are a FTSE100, global business of around 15,000 colleagues, based in 50 countries.

Our solutions have a real impact on lives across the planet, enabling industry, improving healthcare, enhancing security, advancing connectivity, and supporting new homes. Our products and services are often critical to our customers’ operations, while our proprietary technology and high service levels help create competitive advantage. We welcome colleagues with a curious mind, who are happy with responsibility, enjoy a challenge and are attracted by the idea of working at a business with an almost 170-year history of innovation, and four global divisions, all experts in their field.

Job Description

We are looking for a skilled Power BI Developer / Data Analyst with 5–8 years of experience to design, develop, and maintain scalable data models and dashboards. The role involves working closely with business stakeholders to translate requirements into insightful analytics solutions that support decision-making.

Key Responsibilities:

• Design, develop, and deploy interactive dashboards and reports using Power BI
• Build robust data models using star schema / dimensional modeling principles
• Develop and optimize DAX calculations and measures for performance and scalability
• Extract, transform, and load (ETL) data from multiple sources including SAP, databases, and other data sources
• Collaborate with business users to gather requirements and translate them into analytical solutions
• Ensure data accuracy, consistency, and governance across reporting layers
• Optimize report performance, including query tuning and dataset management
• Work with large datasets using SQL and Python (preferred)
• Support deployment pipelines and version control practices
• Troubleshoot data and reporting issues, ensuring timely resolution
• Ensure data accuracy and consistency by implementing robust data validation, cleansing, and reconciliation processes across multiple data sources
• Maintain and enhance existing Power BI assets by optimizing performance, updating data models, and ensuring alignment with evolving business requirements
• Establish data quality checks and monitoring mechanisms to proactively identify anomalies and ensure reliability of reporting outputs
• Advanced Excel expertise including complex formulas, Power Query, and data modeling, enabling efficient data transformation and analysis.
• Proven experience in building scalable Excel-based solutions for reporting, automation, and data validation.

Qualifications

Required Skills & Qualifications:

• 5–8 years of experience in Data Analytics / BI development
• Strong expertise in Power BI (Desktop & Service)
• Proficiency in DAX and Power Query (M language)
• Strong SQL skills and experience with relational databases
• Experience with data modeling techniques (Kimball / Star Schema)Hands-on experience working with SAP data (e.g., SAP ECC, BW extracts)
• Understanding of ETL processes and data pipelines
• Strong analytical thinking and problem-solving skills
• Ability to communicate insights effectively to non-technical stakeholders

Preferred Skills:

• -Knowledge of data governance, lineage, and metadata management
• Familiarity with version control tools
• Basic understanding of AI/ML use cases in analytics

Soft Skills:

• Strong stakeholder management and communication skills
• Ability to work independently and in cross-functional teams
• Detail-oriented with a focus on data quality and accuracy

Nice to Have (Domain Experience):

• Experience in Energy, Manufacturing, or Supply Chain domains
• Strong understanding of SAP functional areas (Finance, Procurement, Supply Chain)

What Success Looks Like:

• High-quality, scalable dashboards adopted by business users
• Improved decision-making through actionable insights
• Reduced data inconsistencies and improved reporting performance

Additional Information

With colleagues stretching across the globe, we are proud of our diversity. To foster inclusivity, we run employee resource groups (ERGs) to provide a safe space for employees to connect and support each other. Our cross-business ERGs include Veterans, Pride Network, Black Employee Network, Women@Work Network, and Neurodiversity.

Across our company, we recognize excellence, culminating in the Smiths Excellence Awards, our annual celebration of the most extraordinary activities, people, and projects that best showcase our strengths and help drive our business forward. We announce these on our annual Smiths Day, a global celebration of Smiths around our network.

Join us for a great career with competitive compensation and benefits, while helping engineer a better future.

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 career’s website (Careers - Smiths Group plc )