Business Intelligence Analyst

About this role:

As a BI Analyst within Gartner's Operations & Strategy team, you'll work closely with business partners to answer questions, solve problems, and deliver reporting and analytics solutions. You'll help transform complex data into clear insights that support operational and strategic decision‑making across the organization.

You thrive in ambiguity: asking clarifying questions, structuring unclear problems, and adapting as business needs evolve. You're comfortable when definitions shift and requirements are incomplete, and you can translate the gray into actionable insights.

• Frame ambiguous business problems into clear analytical questions. Collaborate with stakeholders to clarify objectives, define success measures, identify decision points, and translate evolving requests into practical requirements.
• Develop and refine KPIs that reflect business process reality. Partner with business teams and SMEs to define metric logic, document assumptions, reconcile competing definitions, and ensure reporting outputs support meaningful operational decisions.
• Analyze large and complex datasets to identify patterns, root causes, risks, and opportunities. Use structured analysis to improve processes, uncover inefficiencies, and support recommendations that address business challenges.
• Build decision‑ready reporting and analytical outputs. Develop reports, dashboards, datasets, and supporting analyses using tools such as Power BI, Salesforce Native reporting, Salesforce CRM Analytics, Databricks, Excel, Tableau, or comparable platforms.
• Validate data before insights are shared. Review source data, transformation logic, joins, calculations, business rules, and edge cases to ensure outputs are accurate, explainable, and trusted.
• Translate data findings into practical business recommendations. Communicate insights clearly, including what the data shows, what remains uncertain, what tradeoffs exist, and what actions should be considered.
• Clarify stakeholder needs and align expectations. Use thoughtful questioning, active listening, and clear communication to confirm requirements, surface assumptions, explain analytical choices, and keep stakeholders aligned as priorities evolve.
• Manage competing priorities across cross‑functional projects. Balance urgent requests with longer‑term improvements, clarify tradeoffs, communicate progress, and keep work aligned to business impact.
• Improve analytical processes and reporting scalability. Identify opportunities to automate, standardize, simplify, or redesign recurring analysis, data preparation, validation, and reporting workflows.
• Use emerging tools responsibly to improve productivity and quality. Apply automation, AI‑assisted analytics, and modern data tools where appropriate, maintaining strong validation practices and human review of outputs.

• 1-3 years of business, analytics, operations, finance, or related analysis experience (internships and academic projects considered).
• Experience working with stakeholders to clarify requirements, define metrics, analyze data, and communicate findings.
• Experience managing multiple priorities or projects where requirements, timelines, data availability, or stakeholder needs may shift.

• Hands‑on experience in Power BI: building/maintaining reports, dashboards, datasets or analytical views.
• Proficiency with modern analytics and reporting tools (e.g., Excel, Power BI, Salesforce Native reporting, Salesforce CRM Analytics, Databricks, Tableau, Microsoft Fabric).
• Strong Excel skills:
  Power Query, pivot tables, formulas, data preparation, and quality checks.
• Ability to work across CRM, data platform, and BI/reporting environments, understanding how source systems, business processes, data definitions, and transformation logic affect analytical outputs.
• SQL experience for data extraction, transformation, reconciliation, validation, and repeatable analysis.

• Python for data preparation, automation, exploratory analysis, or scalable analytical workflows.
• Exposure to automation and low‑code tools (e.g., Power Automate, Power Apps, Copilot Studio).
• Familiarity with AI‑assisted analytics tools, with an emphasis on responsible use, output review, data validation, and business context.
• Experience with OPI/GSP applications.
• Ability to create executive‑ready outputs, including PowerPoint presentations, data visualizations, and concise written summaries.

Critical thinking and creative problem‑solving skills, including the ability to challenge assumptions, structure uncl