Alteryx & Analytics Developer - Associate Consultant
KPMG India · Bengaluru, Karnataka, India
- On site
- Full-time
- ₹900,000 / year
- Bengaluru, Karnataka, India
Job highlights
- Develop and troubleshoot Alteryx workflows for data.
- Build Power BI dashboards and reports.
- Utilize advanced Excel features for analysis.
- Collaborate with stakeholders on technical solutions.
- Adhere to data governance and security standards.
About the role
Data & Analytics Specialist (Alteryx, Power BI & Excel)
About The Role
We are seeking a skilled Data & Analytics Specialist to join our team. The primary focus of this role is the development and troubleshooting of Alteryx workflows to support our growing volume and complexity of D&A work. The ideal candidate will have at least 3 years of hands-on Alteryx experience and must hold the Alteryx Designer Core Certification; Advanced Certification is a plus. You will also leverage your Power BI and Excel skills to deliver impactful data visualizations and support business intelligence needs. You will work closely with stakeholders to gather requirements, ask clarifying questions, and ensure solutions are aligned with our firm’s data governance standards.
Key Responsibilities
- Design, develop, optimize, and troubleshoot Alteryx workflows for data extraction, transformation, and analysis.
- Serve as a D&A subject matter expert, providing guidance and recommendations for best practices and process improvements.
- Build and maintain Power BI dashboards and reports to support business intelligence needs.
- Develop and utilize advanced Excel features, including pivot tables, charts, lookups, and macros, to analyze and present data.
- Collaborate with business stakeholders to gather requirements, clarify objectives, and translate business needs into technical solutions.
- Ensure all solutions adhere to firm and departmental data governance and security standards.
- Document data flows, processes, and solutions for transparency and knowledge sharing.
- Perform data validation and testing to ensure accuracy and reliability of analytics outputs.
- Stay current with best practices and new features in Alteryx, Power BI, Excel, and related analytics technologies.
Required Skills & Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field.
- 3+ years of hands-on experience developing and troubleshooting Alteryx workflows (Designer), with a strong understanding of ETL concepts.
- Alteryx Designer Core Certification is required; Advanced Certification is a plus.
- 2+ years of experience with Power BI, including data modeling, DAX, and visualization techniques.
- Advanced proficiency in Excel, including pivot tables, charts, lookups (e.g., VLOOKUP, XLOOKUP), and macros.
- Demonstrated experience leveraging AI tools (such as Agent Space, ChatGPT, or similar) to analyze, synthesize, and generate insights and datasets.
- Strong analytical and problem-solving skills; ability to work independently and proactively.
- Experience gathering requirements and communicating effectively with business stakeholders.
- Familiarity with data governance, data quality, and security best practices.
- Excellent written and verbal communication skills.
- Ability to quickly learn and adapt to new business processes and data environments.
Preferred Skills
- Experience with SQL or other data querying languages.
- Exposure to Power Apps, Power Automate, or other Microsoft Power Platform tools.
- Familiarity with Python or R for advanced analytics (a plus).
- Prior experience working in remote teams.
Key skills/competency
- Alteryx
- Power BI
- Excel
- Data Visualization
- ETL
- Data Analysis
- Business Intelligence
- Data Governance
- Requirement Gathering
- Problem-Solving
Skills & topics
- Data Analytics Specialist
- Alteryx
- Power BI
- Excel
- ETL
- Data Visualization
- Business Intelligence
- Data Governance
- Analytics
- KPMG India
How to get hired
- Tailor your resume: Highlight your Alteryx, Power BI, and Excel expertise. Quantify achievements.
- Highlight certifications: Emphasize your Alteryx Designer Core Certification.
- Showcase AI experience: Detail your use of AI tools for data insights.
- Demonstrate collaboration: Provide examples of stakeholder engagement and requirement gathering.
- Prepare for technical and behavioral questions: Be ready to discuss ETL, data governance, and problem-solving.
Technical preparation
Master Alteryx Designer for ETL and workflow automation.,Become proficient in Power BI for dashboard creation.,Practice advanced Excel functions and macros.,Familiarize yourself with AI tools for data analysis.
Behavioral questions
Describe a complex data problem you solved.,How do you gather and clarify requirements?,Explain your approach to data governance.,How do you stay updated on analytics tech?
Frequently asked questions
- What are the essential certifications for the Data & Analytics Specialist role at KPMG India?
- The Alteryx Designer Core Certification is a mandatory requirement for this Data & Analytics Specialist position at KPMG India. While not required, an Alteryx Advanced Certification is considered a plus and can strengthen your application.
- How important is Alteryx experience for this KPMG India role?
- Hands-on experience developing and troubleshooting Alteryx workflows is critical. The role requires at least 3 years of experience with Alteryx Designer, indicating a strong emphasis on this tool for data extraction, transformation, and analysis.
- What level of Excel proficiency is needed for the Data & Analytics Specialist job at KPMG India?
- Advanced proficiency in Excel is required for this role at KPMG India. This includes expertise in pivot tables, charts, lookups (like VLOOKUP and XLOOKUP), and macros for data analysis and presentation.
- Does KPMG India value experience with AI tools for this Data & Analytics Specialist position?
- Yes, KPMG India specifically looks for demonstrated experience leveraging AI tools like Agent Space or ChatGPT to analyze, synthesize, and generate insights and datasets for this Data & Analytics Specialist role.
- What is the expected educational background for a Data & Analytics Specialist at KPMG India?
- KPMG India typically requires a Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field for this Data & Analytics Specialist position.
- Are remote work opportunities available for this Data & Analytics Specialist role at KPMG India?
- While not explicitly stated as a primary work arrangement, prior experience working in remote teams is listed as a preferred skill, suggesting that remote collaboration is familiar and possibly accommodated at KPMG India.
- What is the role of Power BI in this Data & Analytics Specialist position at KPMG India?
- For this Data & Analytics Specialist role at KPMG India, Power BI is used to build and maintain dashboards and reports to support business intelligence needs, requiring at least 2 years of experience in data modeling, DAX, and visualization.
- How does KPMG India ensure data quality and security for its Data & Analytics Specialists?
- KPMG India emphasizes adherence to firm and departmental data governance and security standards. The role requires familiarity with data governance, data quality, and security best practices.