Data Analyst

Rotork; Chennai; On-site; INR 600,000 - 1,000,000; Full time

Benefits offered by this job

MS Access experience

Growth opportunities

Job summary

Rotork, a market-leading flow control and instrumentation company, seeks a data analytics specialist to bridge engineering data and business intelligence during a major MS Dynamics 365 rollout.

You will analyze data, build dashboards, and validate data quality to accelerate the D365 deployment. The role emphasizes cross-functional collaboration with global engineering teams and timely, accurate data delivery.

Qualifications

• Bachelor’s degree in engineering, mathematics, computer science, or related field with 1–2 years of experience.
• Strong SQL and data manipulation skills.
• Proficient in Excel (Pivot Tables, Power Query, XLOOKUP) and Power BI.
• Experience with data profiling, MDM, and complex data migrations.

Responsibilities

• Identify trends in complex data sets to support D365 deployment.
• Develop automated reporting using Power BI and Excel to monitor data quality and project progress.
• ETL management between legacy systems and D365.
• Define data profiling and cleansing routines for a single version of truth.
• Present analysis to senior leaders and influence project timelines.
• Identify opportunities for data collection and process improvements.
• Support production cut-over and resolve data discrepancies in real time.

Skills

SQL

Python

ETL

Power BI

Excel

MDM

Data cleansing

Data migrations

Analytics

Communication

Agility

Education

Bachelor's degree in Engineering/CS/Math

Tools

MS Access

Job description

Rotork is the market-leading global flow control and instrumentation company, helping our customers manage the flow or liquids, gases and powders across many industries worldwide.

Our purpose is Keeping the World Flowing for Future Generations.

Job Description

Join our dynamic and specialised team in a key role that will truly make a difference.As part of this team, you will act as the bridge between raw Engineering data and actionable business intelligence, contributing to one of the largest MS Dynamics 365 rollouts globally.

You will be embedded within the deployment team, focusing on theintegrity, analysis, and visualizationof data to ensure an accelerated and successful rollout of the Microsoft Dynamics 365 solution. You will interpret complex data sets,identifytrends, and provide the Engineering teams with the insights needed tooptimizeproduct structures and configurations. You willbe responsible forensuring that the global transition to D365 is backed by high-quality, validated data.

Main Responsibilities:

• Data Insight & Trends:Identify, analyse, and interpret trends or patterns in complex data sets using statistical techniques to support D365 deployment.
• Reporting & Dashboards:Develop andmaintainautomated reporting capabilities (Power BI/Excel) tomonitordata cleanliness and project progress.
• ETL Management:Extract, transform, and load (ETL) Engineering and CPQ data, ensuring seamless flow between legacy systems and D365.
• Data Quality Assurance:Define and implement data profiling and cleansing routines to ensure "single version of truth" accuracy through all migration test cycles.
• Stakeholder Communication:Present analysis results and data-driven solutions to senior leaders and internal customers to influence project timescales and strategy.
• Process Improvement:Locateand define new process improvement opportunities for data collection and management.
• Migration Support:Support production cut-over and provide early-life support by resolving data-related discrepancies in real-time.

Required Skills and Experience:

• Technical Proficiency:Strong knowledge of and experience withdatabases (SQL, etc.)and programming for data manipulation (Python, R, or ETL frameworks).
• Advanced Analytics:Expertisein Microsoft Excel (Pivot Tables, Power Query, XLOOKUP, SUMPRODUCT), MS accessand data visualization tools likePower BI.
• Data Lifecycle Knowledge:Proven experience in data profiling, Master Data Management (MDM), data cleansing, and complex data migrations.
• Analytical Mindset:Strong ability to collect, organise, anddisseminatesignificant amounts of information with meticulous attention to detail and accuracy.
• Problem Solving:Demonstratedability toidentify, investigate, and resolve data anomalies within large, complex datasets.
• Communication:Ability to effectively communicate technical data findings to a non-technical audience and build relationships across global Engineering teams.
• Agility:Comfortable working to tight deadlines and adept at switching priorities in a fast-paced environment.

Qualifications

This role is perfect for someone -

Who holds a bachelor’s degree in engineering, Mathematics, Computer Science, or a related fieldand with a professional experience of 1-2 years. You should be someone who thrives in a process-driven environment, excels at delivering end-to-end data solutions, and is technically oriented yet capable of influencing project stakeholders. You are disciplined, proactive, and passionate about turning data into a strategic asset.

• Decision-Making:Able to make data-backed decisions quickly during critical project phases.
• Analytical Rigor:A methodical approach to troubleshooting and data validation.
• Adaptability:Able to cope with the unexpected and manage data issues effectively during system transitions.
• Collaborative Spirit:A team player who shares insights butdemonstratesa high levelof individual initiative.