Develops and administers Power BI semantic models, reports, dashboards, and paginated reports. Builds performant DAX and Power Query solutions, manages Power BI Service workspaces, refreshes, gateways, security, governance, and deployment pipelines. Supports SQL, Python, Spark, and C# data pipelines, ETL/ELT processes, production incidents, data quality monitoring, troubleshooting, and root-cause analysis. Partners with stakeholders on reporting requirements, user acceptance testing, documentation, training, and certified content management.
BI Analytics Analyst
The BI Analytics Analyst is responsible for designing, building, and maintaining the semantic models and Power BI content that make enterprise data usable by the business, and for supporting the data pipelines and ETL/ELT processes those models depend on. The role pairs report and semantic model development with day-to-day production support of the data platform; trusted, certified and performant data is the ultimate goal, which enables our organization to utilize data for performance evaluation and optimization.
Responsibilities:
- Power BI & Semantic Model Development
- Design, build, and maintain enterprise semantic models — star schema design, grain, relationships, hierarchies, and conformed dimensions — over the Data Warehouse and Data Lakehouse layers.
- Select and implement the appropriate storage mode (Import, DirectQuery, Direct Lake, or composite) and configure incremental refresh and aggregations to meet performance and data latency requirements.
- Author and maintain DAX measures, calculation groups, and time intelligence logic, applying row and filter context correctly and documenting measure definitions.
- Develop Power Query (M) transformations that preserve query folding and align with established modeling standards.
- Design, develop, and publish Power BI reports, dashboards, and paginated reports that meet enterprise visualization, usability, and accessibility standards.
- Tune model and report performance using Performance Analyzer, DAX Studio, Tabular Editor, and VertiPaq Analyzer; remediate slow refreshes, oversized models, and inefficient measures.
- Implement row-level and object-level security in line with data governance and access standards.
- Power BI Service & Platform Administration
- Administer workspaces, apps, and content distribution; manage dataset endorsement and certification so the business consumes governed, reusable models.
- Manage scheduled refreshes, dataflows, and on-premises data gateway connections and credentials; monitor and remediate refresh failures.
- Monitor capacity utilization, refresh windows, and model size against licensed capacity, escalating and remediating constraints.
- Manage the BI release process — model and report artifacts in source control (PBIP/TMDL via Git) promoted through development, test, and production deployment pipelines.
- Apply sensitivity labels and maintain lineage, certification, and documentation in line with enterprise data governance standards.
- Data Engineering & Production Support
- Implement and maintain pipelines that move raw data into the data platform using spark, python, SQL and C# in line with well-established architectural standards related to Data Warehouse and Data Lakehouse modeling standards.
- Build and support ETL/ELT processes that produce curated, analytics-ready datasets.
- Serve on the Data Engineering support rotation: work the intake queue, resolve incidents within established service levels, and escalate along the defined path.
- Troubleshoot pipeline, orchestration, and refresh failures — dependency and scheduling errors, source system changes, re-runs and backfills — to restore service.
- Triage and troubleshoot perceived data aberrations submitted by the user community, performing root cause analysis and documenting findings.
- Implement and maintain data quality, validation, monitoring, and alerting capabilities to ensure data integrity and reliability.
- Contribute to runbooks, data flow and schema documentation, and change management records.
- Employ Azure Devops and Git in line with the Software Development Life Cycle best practices.
- Collaboration & Business Enablement
- Partner with business stakeholders, Business Analysts, and Data Analysts to elicit, clarify, and prioritize reporting requirements.
- Act as a liaison with Business Analysts and Testing teams to promote smooth development execution, and support user acceptance testing of reports and models.
- Maintain the reporting backlog, enable and train users on certified content, and retire or consolidate redundant reports.
- Partner with Data Engineering, Data Modeling, Governance, and Architecture teams to keep semantic models aligned to the enterprise data model and governance standards.
- Other duties as assigned.
Basic Qualifications:
- 2+ years of practical or collegiate experience (or equivalent) developing Power BI reports and semantic models, including DAX measures and Power Query (M) transformations.
- Demonstrated ability to design a dimensional (star schema) model and author performant DAX, including time intelligence and correct use of row and filter context.
- 2+ years of practical or collegiate experience (or equivalent) in SQL related to data engineering (or equivalent collegiate experience / certifications).
- 2+ years of practical or collegiate experience (or equivalent) in Python related to data engineering (spark, pandas, etc).
- Working knowledge of ETL/ELT concepts, dimensional and relational data modeling, and relational databases.
- Experience supporting production pipelines or reporting in a ticket-driven support environment, including incident triage and root cause analysis.
- Solid understanding of the Software Development Life Cycle.
- Motivated individual looking to expand their knowledge in all areas of Business Intelligence, Data Engineering, Analytics and AI.
- Bachelor’s Degree or Relevant Certifications & equivalent years of experience
Preferred Qualifications:
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Microsoft Cloud Certification (Azure or Microsoft Fabric)
- Experience with Microsoft Fabric — OneLake, Lakehouse/Warehouse, and Direct Lake semantic models.
- Experience with Power BI application lifecycle management: PBIP/TMDL in source control, deployment pipelines, and Tabular Editor.
- Experience administering the Power BI Service: capacity monitoring, gateways, and workspace and app lifecycle.
- Experience with data governance tooling (Microsoft Purview): lineage, sensitivity labels, and asset certification.
- Experience with orchestration tooling (Azure Data Factory, Synapse Pipelines, or Fabric Data Factory).
- Familiarity with Machine Learning and AI, including surfacing model output in BI content.
Travel:
- <10%
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Similar Jobs
Artificial Intelligence • HR Tech • Information Technology • Software • Business Intelligence
Owns strategic enterprise SaaS sales for major travel and hospitality brands. Responsibilities include developing C-level relationships, managing complex multi-stakeholder deals, exceeding revenue quotas, building ROI cases, negotiating contracts, tracking competitive landscapes, and partnering with solutions engineering, professional services, and customer success teams. Requires deep travel and hospitality industry knowledge and experience selling enterprise platforms.
Top Skills:
MeddicMeddpiccQualtrics Experience ManagementSaaSSalesforce
Artificial Intelligence • HR Tech • Information Technology • Software • Business Intelligence
Manages ongoing experience-management partnerships with financial services customers, using Qualtrics data, dashboards, and AI analytics to connect customer feedback to business KPIs. Designs and improves XM programs, facilitates executive and operational workshops, recommends compliant service and journey improvements, coaches change adoption, proves ROI, and identifies retention and account-growth opportunities while coordinating with account, technical, and consulting teams.
Top Skills:
Ai ToolsAi-Driven AnalyticsDashboardsQualtricsQualtrics Insights Engine
Artificial Intelligence • HR Tech • Information Technology • Software • Business Intelligence
Leads healthcare safety and reliability consulting engagements by applying High Reliability Organization principles, safety culture practices, Root Cause Analysis, and Communication and Resolution Programs. Analyzes payer, authorization, denial, and behavioral data to identify risks and recommend improvements. Manages project workstreams, timelines, budgets, deliverables, and client relationships while training and coaching patient-facing teams. Supports performance improvement initiatives that reduce clinical errors and strengthen healthcare safety cultures.
Top Skills:
ExcelMicrosoft AccessMS OfficeSASSQL
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

