Sr Analyst

Grade Level (for internal use): 09 Overview: We are looking for a hands-on Senior Analyst with strong BI engineering and data analytics expertise to join our Customer Analytics & Insights team within S&P Global Market Intelligence. The role is central to building, maintaining, and evolving the analytics infrastructure that powers sales performance reporting, renewals analytics, pipeline visibility, and executive decision-making. The successful candidate will own business-critical reporting solutions, drive automation through modern data platforms, and partner with Sales, Finance, Commercial, Business Development, and senior leadership to translate data into actionable insight.

Own and enhance business-critical BI solutions — including Actuals vs Forecast vs Plan reporting, hierarchy mapping, and drill-through analytics for leadership consumption. Build and operate end-to-end data automation using modern lakehouse and pipeline platforms (e.g., Microsoft Fabric) — designing notebooks, dataflows, and pipelines that power daily KPI validation, reconciliation, and refresh workflows across multiple reporting solutions. Write and optimize advanced Snowflake SQL to extract data; integrate Salesforce, data warehouses, SaaS APIs, and Excel sources into unified analytical models. Develop AI- and Copilot-powered solutions — including AI agents grounded in semantic models, AI Narratives for executive reporting, and Copilot-enabled experiences that improve discoverability and insight generation across analytics products. Partner with senior stakeholders — including Sales, Finance, Commercial and Product leadership — to deliver decision-ready analytics, deep dives, metric reconciliation, and executive narratives for QBRs, operating reviews, and leadership decks. Manage BI operations end-to-end — including user access, version control across Dev/Test/Prod environments, publishing, refresh monitoring, and first-line technical support for critical analytics products. Drive process automation and standardization for recurring deliverables (e.g., SaaS API integrations, partner data refreshes, monthly data mappings) — eliminating manual effort and improving turnaround. Maintain comprehensive documentation and ensure knowledge continuity across dataflows, notebooks, refresh schedules, backend logic, dependencies, and troubleshooting playbooks to enable seamless team operations.

Bachelor's degree in Engineering (B.E./B.Tech), Science (B.Sc. in Statistics or Mathematics), Commerce (B.Com). 2-3 years of hands-on BI engineering or data analytics experience, preferably in sales, commercial, or financial services analytics. Advanced Power BI skills — data modeling, DAX, semantic models, dataflows, Power BI Service, and performance optimization. Strong Snowflake SQL proficiency — complex joins, window functions, transformation scripts, and history tables. Hands-on experience with Microsoft Fabric — Notebooks, Pipelines, Lakehouse, Dataflows Gen2, and scheduled refresh management. Proficiency in Power Automate, Power Query, and advanced Excel for workflow automation. Working knowledge of Salesforce data structures, opportunity/pipeline data, and CRM-driven analytics. Strong written and verbal communication skills, with the ability to translate technical work into business outcomes for senior stakeholders. Proficient in MS Excel; Power query, MS Word and MS PowerPoint. Exposure to Copilot for Power BI, AI Narratives, and semantic-model-grounded AI agents.

Microsoft Certified: Fabric Data Engineer Associate (DP-700) or equivalent certification. Hands-on experience with PySpark and Spark SQL for data transformation within lakehouse/Fabric notebooks. Experience integrating SaaS APIs (e.g., Pendo, CRM platforms) into BI workflows. Demonstrated track record of building automation or AI-driven solutions that reduce manual effort and improve analytical turnaround.