Microsoft

Senior Business Analytics Specialist

Microsoft • $106K — $203K *
Redmond, WA 98052In-Person
Enterprise Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Master's Degree in a related field with 3+ years experience in data analysis or a Bachelor's Degree with 4+ years experience.
  • Experience with AI-native engineering tools such as GitHub Copilot or Azure OpenAI.
  • Proficiency in building AI-ready data architectures and implementing trusted data assets for AI.
  • Familiarity with Responsible AI principles and AI governance.
  • Hands-on experience with Microsoft Fabric and Power BI solutions.

Responsibilities

  • Operate one of Microsoft's largest enterprise platforms for Microsoft Fabric.
  • Enable trusted data products for analytics, automation, and AI experiences.
  • Enhance platform scalability, reliability, governance, and performance for extensive user bases.
  • Partner with product teams to refine platform capabilities through collaborative adoption.
  • Build AI solutions to automate data engineering tasks, freeing up engineering capacity.
  • Monitor and optimize production workloads for significant user engagements.
  • Establish secure downstream consumption of data products with compliance and governance.

Benefits

  • Comprehensive health, dental, and vision insurance plans.
  • 401(k) plan with company match.
  • Generous paid time off and holiday schedule.
  • Employee assistance programs and wellness initiatives.
  • Opportunities for professional development and training.
Full Job Description
Responsibilities

What Success Looks Like

In this role, you will:
  • Help operate one of Microsoft's largest Microsoft Fabric enterprise platforms.
  • Enable trusted data products that power analytics, automation, and AI experiences across MCAPS and Finance.
  • Accelerate Microsoft's transition toward AI-native engineering through practical adoption of AI-native development practices.
  • Improve platform scalability, reliability, governance, and performance for over 50,000 monthly users.
  • Partner with Microsoft Fabric Product Group teams to influence and validate next-generation platform capabilities through Customer Zero adoption.
  • Enable secure downstream consumption of data products and self-serve analytics - delivering governed, performant semantic models that let business users build their own analytical and AI solutions while preserving performance, security, and compliance.
  • Build AI agents and AI solutions that automate repetitive, tedious data engineering and analytical tasks - freeing engineers to lead with intent-first design and accelerating the journey to AI-native data engineering.

Our Technology Environment

You will work hands-on across a modern, Fabric-native stack:
  • Lakehouse & storage: Microsoft Fabric, OneLake, Delta Lake / Parquet, Lakehouse & Warehouse, shortcuts, and medallion (bronze / silver / gold) architecture.
  • Processing & compute: Apache Spark (PySpark, Spark SQL), Fabric Notebooks, Dataflows Gen2, Data Factory pipelines, and T-SQL.
  • Semantic & BI: Power BI, Direct Lake, Direct Query and Import mode semantic models, DAX, the VertiPaq engine, and incremental refresh.
  • Real-time: Real-Time Intelligence, Eventstreams, and Eventhouse / KQL databases.
  • AI & agents: GitHub Copilot, Copilot for Fabric, Microsoft Agency, Azure OpenAI / Azure AI Foundry, RAG, vector search, and agent frameworks.
  • Governance & security: Microsoft Purview, sensitivity labels, data lineage, RBAC, and Microsoft Entra ID.
  • Engineering & DataOps: Git, Fabric deployment pipelines, CI/CD (Azure DevOps / GitHub), automated data-quality testing, and observability.
  • Languages: Python, SQL / T-SQL, PySpark, DAX, and KQL.

AI-Native Data Platform Engineering
  • Design, develop, and optimize enterprise-scale data pipelines, data products, and platform services on Microsoft Fabric.
  • Build and maintain scalable Lakehouse, Warehouse, and Direct Lake semantic model solutions that serve analytics and AI consumption at scale.
  • Use AI-native development tools and agentic workflows to accelerate delivery, testing, documentation, and operational excellence - working in an intent-first, spec-driven model where engineers define intent and approved agents help execute and validate.
  • Contribute to the adoption of intelligent automation and AI-powered engineering across the platform, treating AI as a first-class engineering actor rather than an occasional tool.
Data Engineering & Analytics Enablement
  • Engineer robust, idempotent ELT/ETL pipelines in PySpark, Spark SQL, and T-SQL across Fabric Notebooks, Dataflows Gen2, and Data Factory pipelines, applying medallion (bronze / silver / gold) patterns over Delta Lake.
  • Tune Spark and Delta workloads for scale: partitioning, shuffle and data-skew management, broadcast joins, caching, Adaptive Query Execution, and file optimization (OPTIMIZE / V-Order, compaction).
  • Build and optimize data models that power enterprise reporting, analytics, and self-service BI experiences.
  • Partner with BI Leads and business stakeholders to translate complex business requirements into scalable technical solutions.
  • Enable trusted, high-quality datasets that support analytics, automation, and AI workloads.
  • Onboard and modernize new analytics workloads and data products directly onto the Fabric-native platform.
  • Enable secure downstream consumption of data products: exposing curated, governed datasets to reports, automation, and AI solutions through well-defined contracts, access controls, and sensitivity labeling, so consumers get trusted data without compromising security or compliance.
Semantic Modeling & Enterprise BI
  • Collaborate with BI Leads to design scalable semantic models that support enterprise-grade reporting and self-service analytics.
  • Implement data modeling best practices that improve performance, discoverability, usability, and AI readiness.
  • Contribute to the definition and enforcement of modeling standards, reusable design patterns, and semantic-layer governance.
  • Optimize DAX, Direct Lake / import model performance, VertiPaq compression, aggregations, and incremental refresh for high-concurrency reporting workloads.
  • Enable semantic models that power self-serve analytical scenarios and self-serve AI solutions for business users - delivering governed, performant, and AI-ready models that let users explore data and build their own insights while preserving query performance, security, and compliance.
Platform Reliability & Operations
  • Monitor, troubleshoot, and optimize production workloads supporting 50,000+ users and mission-critical business processes.
  • Investigate and resolve data quality, performance, refresh, pipeline, and platform-related issues.
  • Manage Fabric capacity and Compute Unit (CU) utilization - diagnosing throttling, analyzing query plans, and right-sizing workloads for predictable cost and performance.
  • Drive continuous improvements in observability, monitoring, DataOps, DevOps, CI/CD, and platform automation.
  • Partner with the Microsoft Fabric Product Group to evaluate new capabilities and enterprise-scale deployment patterns through Customer Zero adoption.
Security, Compliance & Governance
  • Implement secure-by-design engineering practices throughout the data platform lifecycle.
  • Support enterprise governance - data classification, lineage, access control, auditing, and compliance using Microsoft Purview, One lake Catalog or similar products.
  • Ensure solutions meet organizational standards for privacy, security, Responsible AI, and regulatory compliance.
  • Contribute reusable governance patterns that enable scalable self-service analytics while protecting sensitive data assets.


Qualifications

Required/minimum qualifications

Master's Degree in Mathematics, Analytics, Engineering, Computer Science, Marketing, Business, Economics or related field AND 3+ years 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 related field AND 4+ years experience in data analysis and reporting, business intelligence, or business and financial analysis OR equivalent experience.

Preferred Qualifications
  • Experience using AI-native engineering tools such as GitHub Copilot, Copilot for Fabric, Azure OpenAI, or similar technologies.
  • Experience building AI-ready data architectures and preparing trusted data assets for AI consumption.
  • Understanding of AI agents, vector search, and semantic search, and modern AI application patterns, including prompt engineering, evaluation, and guardrails.
  • Experience leveraging AI to accelerate software development, testing, documentation, code review, performance optimization, and operational efficiency.
  • Familiarity with Responsible AI principles, AI governance, and the secure use of generative AI technologies.
  • Experience integrating AI capabilities into analytics, reporting, automation, or business-process solutions.
  • Experience across Microsoft Fabric workloads - Lakehouse, Warehouse, Semantic Models, OneLake, Data Factory, and Real-Time Intelligence.
  • Experience supporting enterprise Power BI solutions, DAX optimization, and semantic modeling best practices.
  • Experience implementing data governance and metadata management solutions.
  • Hands-on experience with Microsoft Purview - cataloging, lineage, classification, and information protection.
  • Experience working on customer-facing platforms or large-scale enterprise analytics ecosystems.
  • Knowledge of streaming, real-time analytics, event-driven architectures, and operational intelligence scenarios.
  • Experience supporting mission-critical platforms with high availability, reliability, and performance requirements.
  • Microsoft Certified: Fabric Data / Analytics Engineer Associate (DP-600 / DP-700)
  • Microsoft Certified: Azure AI Engineer Associate (AI-102)
  • GitHub Certified: GitHub Copilot (GH-300)
  • Microsoft Certified: Azure Data Engineer / Azure ML Associate (DP-100)
  • Microsoft Certified: Security, Compliance, and Identity Fundamentals (SC-900) or Information Protection & Compliance (SC-400)

#CEAIJobs

Business Analytics IC4 - The typical base pay range for this role across the U.S. is USD $106,400 - $203,600 per year. There is a different range applicable to specific work locations, within the San Francisco Bay area and New York City metropolitan area, and the base pay range for this role in those locations is USD $137,600 - $222,600 per year.

Certain roles may be eligible for benefits and other compensation. Find additional benefits and pay information here:
https://careers.microsoft.com/us/en/us-corporate-pay

This position will be open for a minimum of 5 days, with applications accepted on an ongoing basis until the position is filled.

About Microsoft

Microsoft is an American multinational corporation that develops, manufactures, licenses, supports, and sells a range of software products and services. Microsoft’s devices and consumer (D&C) licensing segment licenses the Windows operating system and related software, Microsoft Office for consumers, and the Windows Phone operating system. The company’s computing and gaming hardware segment provides Xbox gaming and entertainment consoles and accessories, second-party and third-party video games, and Xbox Live subscriptions; surface devices and accessories; and Microsoft PC accessories. Its phone hardware segment offers Lumia smartphones and other non-Lumia phones. Its D&C segment provides Windows Store, Xbox Live transactions, and Windows phone store; search advertising; display advertising; Office 365 Home and Office 365 Personal; first-party video games; and other consumer products and services as well as operating retail stores. Microsoft’s commercial licensing segments license server products, including Windows Server, Microsoft SQL Server, Visual Studio, System Center, and related Client Access Licenses (CALs); Windows Embedded; Windows operating system; Microsoft Office for business, including Office, Exchange, SharePoint, Lync, and related CALs; Microsoft Dynamics business solutions; and Skype. Its commercial segment offers enterprise services, including premier support services and Microsoft consulting services; commercial cloud comprising Office 365 Commercial, other Microsoft Office online offerings, Dynamics CRM Online, and Microsoft Azure; and other commercial products and online services. The company markets and distributes its products through original equipment manufacturers, distributors, and resellers, as well as online.

Microsoft Careers

Join Microsoft today and be part of a company that values innovation, leadership, and diversity in its workforce. As a global leader in technology and digital transformation, Microsoft offers unparalleled job opportunities that propel your career to new heights.

Explore Career Opportunities at Microsoft

Whether you're a seasoned professional looking for your next challenge or a recent graduate eager to start your career, Microsoft has a position that suits your skills and ambitions. We are committed to fostering a culture of growth and learning, where every team member is supported in expanding their horizons.

Internship Programs

Kickstart your career with a Microsoft internship. Our internships provide invaluable workplace experience and networking opportunities in a supportive and dynamic environment. You'll work on real projects, learn from industry leaders, and gain the skills necessary for a successful career in technology.

Employment Benefits

Choosing a career at Microsoft means more than just a job. Our employees enjoy a range of benefits designed to empower them both professionally and personally. These include comprehensive health benefits, flexible working conditions, and opportunities for career advancement through professional development and diversity training.

Inclusive Culture and Diversity

At Microsoft, we believe that innovation comes from diversity of thought and inclusion. We are committed to a workplace where everyone feels valued and inspired. Our leadership is dedicated to fostering an environment where diverse perspectives lead to breakthrough innovations and a competitive edge.

Grow with Us

Career growth at Microsoft is about more than climbing the corporate ladder; it's about continuous learning, expanding your skills, and improving your capabilities. With access to various leadership and training programs, you can evolve as a professional and make a significant impact within the company and on the global stage.

Hiring Process

Our hiring process is designed to identify true potential. Starting with a review of your resume, followed by interviews that assess your problem-solving abilities and cultural fit, we ensure that all candidates have a fair chance to demonstrate their strengths and potential to contribute to our team.

Networking and Professional Development

Microsoft is a place where you can build a professional network that spans the globe. Our employees benefit from connections with top-tier professionals and industry leaders, which opens doors to innovative projects and collaborative opportunities that are second to none.

Join Our Team

If you're ready to take on exciting challenges and make a difference in the world of technology, explore the job opportunities at Microsoft. Search for open positions that match your skills and interests, and prepare to embark on a rewarding career path filled with innovation and opportunities for personal and professional growth.

Stay Connected

Keep up to date with the latest at Microsoft Careers by subscribing to our job alert emails. Get tailored content that aligns with your career preferences and discover the exciting and rewarding opportunities that await at Microsoft.

SEARCH MICROSOFT JOBS

At Microsoft, your future is limitless. Join us in our mission to empower every person and every organization on the planet to achieve more. Your journey with Microsoft starts here.
Learn more about Microsoft
Size
181,000 employees
Market Cap
$1,762.4 billion
Industry
Enterprise Technology
Net Income
$51.3 billion
Founded
1975
5 Year Trend
+15.5%
Revenue
$153.2 billion
NASDAQ
MSFT
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Microsoft

More Enterprise Technology Jobs

Find similar Senior Business Analytics Specialist jobs:

NationwideRedmond, WA