Business Analytics Specialist

Microsoft•Redmond, WA

1d•$106,400 - $203,600

About The Position

The Business Analytics Specialist will support Microsoft’s SME&C Corporate Accounts business, with a primary focus on the Corporate Accounts Intelligence Platform (CAIP) and Azure business intelligence and analytics. The role translates business priorities into scalable reporting, semantic models, and analytical products that help leaders and field organizations understand performance and take action. It spans the analytics lifecycle, including clarifying business questions and metrics, designing models, developing BI solutions, validating data, and driving adoption. Approximately 60% of the role focuses on Corporate Accounts BI, including CAIP and Azure analytics; approximately 40% focuses on semantic models, data architecture, AI readiness, and self-service analytics. The specialist will build trusted and reusable analytical foundations, improve data quality and performance, reduce fragmented reporting, and prepare assets for self-service and AI-enabled experiences such as Copilot and natural-language analytics. The role also involves analyzing business performance, communicating findings and recommendations, partnering across business and technical teams, and improving analytics standards and practices.

Requirements

Master’s degree in Mathematics, Analytics, Engineering, Computer Science, Marketing, Business, Economics, or a related field and 3+ years of experience in data analysis and reporting, business intelligence, or business and financial analysis; or bachelor’s degree in Statistics, Finance, Mathematics, Analytics, Engineering, Computer Science, Marketing, Business, Economics, or a related field and 4+ years of such experience; or equivalent experience.
Experience building business intelligence solutions using Power BI, including dashboards, scorecards, executive reporting, and interactive analytical experiences.
Analytical and problem-solving skills, including the ability to translate complex business questions into analytical solutions.
Experience working with sales, commercial, finance, operations, or customer performance data.
Ability to explain why performance is changing and what actions should be considered, not merely report results.
Experience translating business requirements into scalable analytical products rather than standalone reports.
Ability to independently own BI solutions from requirements through development, validation, deployment, and ongoing improvement.
Experience supporting sales operations, business operations, finance, strategy, performance management, or commercial organizations.
Understanding of business performance measurement, KPI design, pipeline and execution metrics, and executive reporting frameworks.
Experience analyzing customer, product, revenue, consumption, pipeline, or sales performance.
Ability to connect operational and sales indicators to broader business outcomes.
Hands-on experience designing and maintaining Power BI semantic models and enterprise analytical solutions.
Understanding of dimensional modeling, star schemas, relationships, measures, hierarchies, and semantic layer design.
Experience with DAX and SQL and ability to independently investigate and validate data.
Experience building or optimizing solutions using Power BI and Microsoft Fabric.
Experience with large or complex datasets and optimizing models for performance, usability, and scalability.
Understanding of data pipelines, data transformation, data quality, lineage, governance, and certification.
Experience consolidating fragmented semantic models or reporting solutions into reusable analytical foundations.
Understanding of how semantic models, metadata, business definitions, and data quality enable Copilot, natural-language analytics, and AI-agent scenarios.
Ability to explain complex analytical findings in simple business terms and create executive-ready scorecards, presentations, and analytical narratives.
Ability to distinguish reporting a metric from explaining the business drivers behind it.
Ability to communicate effectively with technical teams and business stakeholders.
Proven ability to work across business, analytics, engineering, and operations organizations.
Ability to independently manage BI products and analytical workstreams from definition through delivery.
Prioritization and execution skills, including balancing business urgency with long-term architectural quality.
Comfort working in an environment where business priorities and analytical requirements evolve rapidly.
Demonstrated focus on quality, accuracy, scalability, and user experience.

Nice To Haves

Experience with cloud, Azure, enterprise software, or technology-industry business models.
Master’s degree in Mathematics, Analytics, Engineering, Computer Science, Marketing, Business, Economics, or a related field and 6+ years of experience in data analysis and reporting, business intelligence, or business and financial analysis; or bachelor’s degree in Statistics, Finance, Mathematics, Analytics, Engineering, Computer Science, Marketing, Business, Economics, or a related field and 8+ years of such experience; or equivalent experience.

Responsibilities

Serve as a primary analytics partner for the Corporate Accounts CAIP business, developing an understanding of business priorities, performance drivers, customer segments, sales motions, and execution.
Own and evolve BI experiences for Corporate Accounts CAIP and Azure analytics, providing trusted and actionable views of business performance.
Develop and maintain executive scorecards, dashboards, KPIs, business review views, and other analytical products.
Build analytical experiences that clarify Azure performance, growth trends, customer performance, pipeline and execution signals, and business opportunities or risks.
Partner with Corporate Accounts business leaders, Sales Excellence, Finance, Strategy, and Operations to define reporting requirements, metrics, analytical priorities, and success measures.
Translate business requirements into scalable BI solutions rather than one-off reports or analyses.
Identify trends, performance drivers, risks, and opportunities, and communicate them through clear analytical narratives.
Ensure CAIP and related reporting experiences use consistent definitions and reconcile across executive, field, and operational views.
Improve the usability, performance, and relevance of Corporate Accounts BI in response to stakeholder needs and changing priorities.
Design, develop, and maintain semantic models and analytical data products for Corporate Accounts, CAIP, and Azure reporting.
Build and optimize Power BI and Microsoft Fabric semantic models for Corporate Accounts BI, self-service analytics, and AI-enabled experiences.
Translate business concepts into dimensions, measures, hierarchies, relationships, and reusable analytical logic.
Establish consistent definitions for key Corporate Accounts metrics and implement business logic consistently across reporting experiences.
Partner with data engineering teams to improve source data quality, model scalability, refresh reliability, governance, and platform performance.
Consolidate semantic models, rationalize overlapping reporting assets, reduce technical debt, and simplify the Corporate Accounts BI architecture.
Prepare analytical assets for natural-language querying, Copilot-enabled experiences, agentic analytics, and other AI-driven scenarios by ensuring appropriate definitions, metadata, relationships, descriptions, and business context.
Support certification of data assets and semantic models for enterprise use, ensuring they are trusted, governed, documented, and discoverable.
Monitor and improve model performance, scalability, usability, and reliability.
Analyze Corporate Accounts performance across data sources to identify customer, product, sales, and execution trends.
Investigate performance changes and determine underlying drivers behind business results.
Conduct deeper analysis of potential risks, opportunities, or issues surfaced by BI views.
Evaluate the impact of business initiatives, investments, programs, and execution changes.
Develop repeatable analytical approaches, convert analysis into actionable recommendations, and connect detailed findings to broader Corporate Accounts and Azure business outcomes.
Build trusted relationships across Corporate Accounts leadership, Finance, Strategy, Sales Excellence, Operations, Engineering, and Analytics organizations.
Work with stakeholders to understand decisions they need to make and determine the analytical capabilities needed to support those decisions.
Challenge unclear or inconsistent metric definitions and help establish common analytical standards.
Translate complex business questions into data requirements, semantic model requirements, KPIs, and analytical experiences.
Communicate analytical findings and technical concepts to business and technical audiences, and influence decisions through business understanding, analytical rigor, and fact-based recommendations.
Promote consistent analytics practices, including metric governance, reporting standards, documentation, testing, and quality assurance.
Eliminate duplicated or low-value reporting, increase reuse of trusted semantic models and common analytical components, and automate recurring analytical processes where practical.
Evaluate Microsoft Fabric, Power BI, Copilot, and AI capabilities and apply them where they materially improve the Corporate Accounts analytics experience.
Support SME&C’s AI-first analytics strategy by preparing Corporate Accounts data and semantic models for safe consumption by traditional BI and emerging AI experiences.