$75,000–$120,000 Per Year
Analysis Skills, Best Practices, Business Analysis, Business Growth, Business Intelligence, Business Model, Business Support, Change Control, Change Management, Change Requests/Orders, Compensation and Benefits, Computer Science, Data Analysis, Data Modeling, Data Quality, Data Sets, Data Visualization, Design Document, Documentation, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Manufacturing, Medical Equipment, Mentoring, Metrics, Microsoft Office, Microsoft Product Family, Microsoft Works, Performance Analysis, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Production Support, Public/Media/Press/Analyst Relations, Quality Management, Query Optimization, Reimbursement, Release Management/Engineering, Reporting Dashboards, Requirements Management, SAP, SQL (Structured Query Language), Software Development Lifecycle (SDLC), Standards of Care, Team Player, Test Plan/Schedule, Training Data Sets, Trend Analysis, Usability Engineering, Writing Skills
Rancho Santa Margarita, CA
_________________________________________________________________________________
Applied Medical is a new generation medical device company with a proven business model and commitment to innovation fueled by rapid business growth and expansion. Our company has been developing and manufacturing advanced surgical technologies for over 35 years and has earned a strong reputation for excellence in the healthcare field. Our unique business model, combined with our dedication to delivering the highest quality products, enables team members to contribute in a larger capacity than is possible in typical positions.
Position Description
The Business Intelligence Analyst supports Applied Medical's analytics environment by building and maintaining reports, dashboards, and data visualizations that drive business decisions. This role partners with teams across the organization to gather reporting requirements, develop BI solutions, and deliver actionable insights from governed data sources. The Business Intelligence Analyst, also known as a BI Analyst, works within Microsoft Power BI, Microsoft Fabric, SAP HANA, and SQL to support reporting needs across the business.
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.
- Develop and support BI solutions using Microsoft Power BI, Microsoft Fabric, SAP HANA, SQL, and other approved reporting tools.
- 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.
Success in This Role Looks Like
- Delivering BI reports and dashboards that give stakeholders clear, accurate visibility into business performance.
- Translating business requirements into reporting solutions that solve real problems and enable data driven decision making.
- Maintaining data accuracy and governance standards across every report and dashboard you build.
- Building strong working relationships with BI analysts and business users across the organization.
- Staying current on BI and analytics tools, then applying that knowledge to improve reporting quality.
Position Requirements
This Position Requires the Following Skills and Attributes
- 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
The Following Skills and Attributes Are Preferred
- 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
Benefits:
- Competitive compensation range: $75000 - 120000 / 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.
Please note that the compensation range may be adjusted in the future, and bonus and incentive compensation plans may apply.
Our total reward package reflects our commitment to employee growth and well-being, as we invest in your development and offer a range of benefits designed to enhance your career and life.
All compensation and benefits are subject to plan documents and written agreements.
Equal Opportunity Employer
Applied Medical is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (including pregnancy, childbirth, breastfeeding and related medical conditions), or sexual orientation, or any other status protected by federal, state or local laws in the locations where Applied Medical operates.