AM - Data Analyst, Purchasing

About the role

### **About Us**

At Kohler, our mission is to help people live gracious, healthy, and sustainable lives. We believe that empowering our associates is essential to making this vision a reality. That’s why we invest in personal and professional growth, encourage collaboration across teams and functions, and offer a comprehensive wellness package that supports the well\-being of every team member.

Kohler is an equal opportunity employer. Along with competitive compensation and benefits, we offer something more enduring—a legacy built on bold innovation, creative excellence, and a deep commitment to our people and communities. Learn more about our culture and career opportunities at www.kohler.co.in/careers.

Our approach to hiring reflects our commitment to **Global Inclusion**. We recruit, hire, and promote qualified individuals in all roles without regard to race, religion, age, sex, sexual orientation, gender identity or expression, marital status, national origin, or disability. If you are an individual with a disability and require reasonable accommodation during the recruitment process, please let your recruiter know so we can support you appropriately.

**AM \- Data Analyst, Purchasing**

----------------------------------

**Job Description****Experience requirement:**

* Must\-Have’s 8\-10 Years of experience in the technologies below + **Power BI Development:** - Design, develop, and maintain Power BI dashboards and reports with a strong emphasis on performance and usability. - Build robust data models using Power BI Desktop, ensuring optimal relationships and calculated columns/measures using DAX. - Perform data transformation using Power Query (M) and integrate data from multiple sources including SQL Server, Excel, SharePoint, and Microsoft Fabric. - Collaborate with business stakeholders to gather requirements and deliver actionable insights. - Implement row\-level security, data refresh schedules, and manage Power BI workspaces effectively. - Leverage Microsoft Fabric components like Lakehouse, Dataflows Gen2, and Notebooks for scalable data engineering. - Ensure adherence to data governance, performance optimization, and visualization best practices. - Ability to guide junior analysts and coordinate with procurement teams - Ability to ensure data quality, execute data strategies, and maintain accurate procurement records. + **Power Automate (Flow) Development:** - Automate repetitive tasks and workflows - Configure connectors and triggers for ERP and SharePoint integration. - Monitor and troubleshoot automation failures. + **Documentation \& Governance:** - Prepare runbooks, SOPs, and technical documentation for all solutions. - Ensure compliance with naming conventions and version control. + **Power App Developments :** - Design, develop, and maintain Canvas Apps and Model\-Driven Apps using Microsoft Power Apps. - Gather business requirements from stakeholders and translate them into technical solutions. - Build and automate business processes using Power Automate workflows. - Integrate Power Apps with SharePoint, Dataverse, SQL Server, SAP APIs, Microsoft 365, and other enterprise systems. - Create user\-friendly forms, dashboards, and request portals to improve business efficiency.

**Required Skills \& Qualifications:**

* Bachelor’s degree in Computer Science, Information Systems, or related field. * 8\-10 years of hands\-on experience in **Power BI development**. * Strong proficiency in **DAX**, **Power Query**, and **data modeling**, Power Automate * Experience with **Microsoft Fabric** and its components. * Familiarity with **SQL**, **Azure Synapse**, and **cloud data architecture**. * Excellent analytical, communication, and stakeholder management skills. * Developing structured plans for procurement automation projects * Ability to ensure data quality, execute data strategies, and maintain accurate procurement records. * Experience in managing small teams or projects \& lead them end to end. * Ability to guide junior analysts and coordinate with procurement teams * Skill in analyzing market trends to identify cost\-saving opportunities * Identifying inefficiencies and proposing structured solutions and drive projects. * Ability to adapt quickly to new tools, processes, and business needs. * Strong business acumen with a proactive, results oriented mindset.

**Added Advantage:**

* Understanding of **Power Apps** and **Power Automate** capabilities and use cases. * Awareness of **operations and manufacturing processes** and KPIs.

Ability to translate domain\-specific requirements into effective BI solutions.

**Mandatory Skills** Power Apps Development, Power Automate, Power BI, Dax, Power Query, SQL, Data Modeling, Data Analytics

**Location** Pune

**Experience** 8 to 12 years