Jobs · Analyst · California

Business Intelligence Analyst

Applied Medical · Rancho Santa Margarita, CA · Today
Analyst$75k–$120k/yrFull-time

Key Responsibilities

  • Gather and document business reporting requirements for projects, enhancements, and software change requests.
  • Design, develop, test, publish, and support analytical reports, dashboards, and data visualizations.
  • Extract, validate, and analyze data from approved sources and semantic models to support business insights.
  • Create and optimize reports, measures, calculations, and visuals for performance, accuracy, and usability.
  • Review system design and specification documents with peers to confirm accuracy and consistency.
  • Provide metrics, analysis, and reporting solutions that identify trends and business performance indicators.
  • Follow data governance, security, access, and change management best practices across all reporting work.
  • Share knowledge with BI analysts and business users to strengthen reporting capability across the organization.

Position Requirements

  • Bachelor's degree in computer science, information systems, data analytics, business analytics, or equivalent experience.
  • Three to five years of experience developing, supporting, and optimizing BI reports and dashboards using Microsoft Power BI.
  • Proficient understanding of data validation, transformation, analysis, and report provisioning within a BI reporting environment.
  • Experience developing, publishing, and supporting Power BI reports, dashboards, and related reporting assets.
  • Experience working with Power BI and Microsoft Fabric semantic models, including measures, relationships, fields, calculations, and report level optimization.
  • Experience with Power BI features such as Data Analysis Expressions (DAX), Power Query, refresh processes, security, and performance optimization.
  • Functional knowledge of governed reporting datasets, semantic models, and approved enterprise data sources.
  • Ability to write, troubleshoot, and optimize Structured Query Language (SQL) queries for reporting and analysis.
  • Understanding of dashboard design, data visualization, usability, and data governance best practices.
  • Experience with Software Development Life Cycle (SDLC), testing, documentation, change control, and production support processes.
  • Strong analytical, problem solving, communication, and collaboration skills.
  • Proficient with Microsoft Office and related productivity tools.

Preferred Skills and Attributes

  • Experience with Microsoft Fabric from a BI and reporting perspective, including Power BI integration, workspaces, semantic models, and governed reporting data sources.
  • Experience with SAP HANA, enterprise reporting datasets, or governed reporting environments.
  • Experience with data modeling within Power BI and Microsoft Fabric semantic models.
  • Experience with data quality validation, report performance tuning, and DAX optimization.
  • Proficient in SQL and DAX.
  • Familiarity with change control, deployment, and release management processes for BI reports and reporting assets.

Benefits

  • Competitive compensation range: $75,000 - $120,000 / year (California)
  • Comprehensive benefits package.
  • Training and mentorship opportunities.
  • On-campus wellness activities.
  • Education reimbursement program.
  • 401(k) program with discretionary employer match.
  • Generous vacation accrual and paid holiday schedule.

Similar jobs