Associate Consultant/Consultant- Power BI, Alteryx
- KPMG India
- 2 - 5 years
- Pune
- 2 days ago
- Email to a friend
- Report this job
Job Description
Summary: The Data Analytics Consultant is a high-impact role requiring a convergence of deep analytical expertise, advanced technological adeptness, and exceptional collaborative capabilities. This professional will define and drive data strategies that optimize business outcomes through innovative analytics and predictive modeling. Proficient in SQL, Power BI, Alteryx, the candidate will also be familiar with data modelling, cloud data solutions and data quality management practices. Leadership and stakeholder management skills are pivotal, ensuring that data insights translate into actionable business strategies across the organization. The ideal candidate will possess refined problem-solving skills, advanced technical capabilities, and a track record of strategic impact in data analytics.
Work Experience:
- 3+ years of total experience in data analytics, with at least 2 years of extensive hands-on experience in SQL, Alteryx, PowerBI and relational database concepts
- Expertise in Power BI, including Power Query, Data Modeling, and Visualization.
- In-depth knowledge of DAX for creating complex calculations, measures, and custom columns.
- Proven experience with Row Level Security (RLS) in Power BI to control data access based on user roles.
- Utilize Alteryx to design, develop, and maintain robust data workflows that automate data extraction, transformation, and loading (ETL) processes. Ensure data quality and integrity by implementing data validation and cleansing techniques
- Must have proficiency in the core concepts of data modeling, including understanding entities, relationships, keys, normalization, and various modeling techniques (e.g., ER diagrams, Star Schema, Snowflake Schema).
- Basic understanding of cloud technologies
- Power platform knowledge is an added advantage
- Programming background is an added advantage
.Responsibilities:
- Spearhead data analytics initiatives, utilizing advanced data visualization and statistical techniques to unearth insights and streamline opportunities for growth.
- Architect and ensure precision in data design, metrics, and analytics distributed to interdisciplinary stakeholders. Implementing normalization techniques to streamline data into efficient, non-redundant structures that reduce anomalies.
- Maintain and customize dashboards and workflows using Power BI, Alteryx
- Integrate closely with Business Development, Operations, and other teams to have a robust understanding of processes, challenges, and customer needs.
- Define and visualize key performance indicators (KPIs) to measure and articulate project success and stakeholder engagement.
- Demonstrated ability to lead projects, influence teams, and mentor junior analysts.
Qualifications:
Education: Bachelor's degree (BE/BTECH) in Computer Science, Engineering, Data Science, or related fields. Highly Preferable: Masters degree in data Analytics, Data Science, Statistics, or any relevant certification(s) such as CAP, DASCA, Microsoft Certified: Data Analyst Associate, or equivalent.
Job Classification
Industry: Management ConsultingFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: Data AnalystEmployement Type: Full timeContact Details:
Company: KPMG IndiaLocation(s): Pune
Keyskills: Power Bi Alteryx Data Analysis Data Visualization Data Modeling Dashboarding Dashboards Data Analytics Power Query SQL
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in