Associate Consultant/Consultant- Power BI, Alteryx

Summary:

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: