Senior Consulting Analyst

Responsibilities

• Work with business clients and advisory teams to understand analytical objectives and secure required data.
• Deliver spend analytics and procurement data solutions as part of advisory engagements:
• Act as procurement data SME in client conversations.
• Gather client requirements.
• Support data collection with clients and advisory teams.
• Assess data scope and validity for spend analytics / PureSpend.
• Manage analytics project activities (timeline, risks, resources).
• Perform data cleansing and enrichment (transformation, loading, normalization, categorization).
• Identify and implement process improvements/automation opportunities.
• Support development & maintenance of dashboards for PureSpend and other digital modules.
• Conduct user training.
• Work closely with stakeholders to translate reporting needs into high-quality dashboards and insights.
• Design, develop, and maintain Power BI dashboards for business and performance reporting.
• Develop and optimize SQL queries, views, and data models.
• Collaborate with engineering and source system teams to ensure accurate and timely data availability.
• Perform data validation and reconciliation checks.
• Design and maintain semantic models and datasets for self‑service analytics.
• Create standardized reporting templates, KPI definitions, and visualization best practices.
• Support ad‑hoc analyses and data exploration.
• Identify opportunities to automate and optimize reporting processes.
• Document data definitions, logic, and visualization standards.
• Support user training on dashboards and self‑service reporting.
• Collaborate with product, analytics, and digital teams on enhancements.
• Support client/internal presentations and storytelling with data.

Requirements / Skills

12+ years of experience) – Expertise in Product Management, Procurement Analytics, Power BI, and SQL

• Strong experience in data visualization and BI, especially dashboards and reporting.
• Hands‑on expertise in Power BI (data modeling, DAX, performance optimization).
• Strong SQL skills (complex queries, joins, window functions, optimization).
• Understanding of star schema, fact/dimension tables, semantic layers.
• Experience with large multi-source datasets and enterprise data platforms.
• Ability to translate business needs into visualizations and KPIs.
• Strong understanding of data quality and validation practices.
• Experience gathering and refining reporting requirements with business & technical stakeholders.
• High attention to detail and strong commitment to accuracy.
• Excellent communication and presentation skills.
• Strong organizational skills; able to handle multiple reporting requests simultaneously.
• Experience in procurement, supply chain, finance, or operations analytics (plus).
• Exposure to cloud platforms (Azure, Snowflake, BigQuery) and ETL/data pipelines (plus).
• Knowledge of Python or advanced analytics tools (plus).