Senior Business Intelligence Analyst

Job Description

This role is a highly experienced individual contributor within the OAI Commercial Operations team responsible for the design, development, governance, deployment, and support of complex business intelligence and reporting solutions. The role provides primary technical reporting support for Corporate Accounts and serves as a senior technical resource for cross-business, regional, and global reporting initiatives supporting sales and marketing priorities.

Using Power BI, SQL, DAX, semantic modelling, data visualization, and automation, the Senior Business Intelligence Analyst II transforms available enterprise data into governed analytics products that enable informed decision-making. The role consults with business leaders and cross-functional teams to define sustainable reporting approaches, develops reporting-layer logic and semantic models, validates results against authoritative sources, and provides guidance on the appropriate interpretation of metrics and visualizations.

In addition to owning assigned reporting solutions, this position has team-wide responsibility for Power BI deployment governance, provides technical review and guidance to other analysts, mentors team members, and partners with Data Engineering, IT, and global Data and Analytics teams to improve the scalability, quality, and consistency of the reporting environment.

Job Duties

• Own the development and delivery of assigned business intelligence and reporting solutions, including requirements gathering, technical design, development, validation, coordination of user acceptance testing, deployment, documentation, user enablement, post-launch monitoring, and production support.
• Serve as the primary technical reporting owner for Corporate Accounts while supporting complex cross-business, regional, and global initiatives based on organizational priorities. Develop deep knowledge of supported business processes, metrics, and data to provide effective technical consultation and sustainable reporting solutions.
• Partner with business leaders and cross-functional teams to understand prioritized reporting and analytical needs, evaluate available data, define technical requirements, and recommend scalable, accurate, user-friendly, and maintainable solutions that support sales, marketing, and commercial decision-making.
• Design, develop, optimize, and maintain advanced Power BI reports, dashboards, semantic models, DAX measures, Power Query transformations, SQL queries, reporting-layer logic, and visualizations using available enterprise data.
• Partner with Data Engineering, IT, and Data and Analytics teams to define reporting requirements, develop reusable reporting views, address data gaps, and resolve upstream dependencies. Escalate requests involving new data ingestion, enterprise pipelines, platform architecture, or source-system changes to the appropriate technical owner.
• Own the governance and administration of the Analytics and Reporting team's Power BI deployment process, including Azure DevOps controls, environment promotion practices, release coordination, troubleshooting, documentation, and adherence to established deployment requirements. Recommend improvements to deployment standards while the manager retains final architecture and production approval.
• Establish and maintain consistent metric definitions, calculation logic, data relationships, and business rules. Validate reporting outputs against authoritative sources and ensure that assumptions, methodologies, lineage, limitations, and validation evidence are documented.
• Provide technical review, guidance, and mentoring to Business Intelligence Analysts. Review solution designs and technical deliverables, promote consistent development and governance practices, and coordinate analyst contributions to complex initiatives without direct responsibility for performance management or workload allocation.
• Analyze data during solution development to identify trends, anomalies, relationships, and limitations that may affect the usefulness or interpretation of the reporting. Recommend improvements to metrics, visualizations, navigation, and functionality, and guide users on the appropriate interpretation of the analytics product.
• Identify and implement opportunities to improve reporting efficiency, consistency, reliability, and scalability through automation, reusable components, shared semantic models, standardized development practices, and the rationalization of duplicative or obsolete reporting solutions. 

Job Qualifications

Required:

• Bachelor’s degree in Data Analytics, Business Intelligence, Information Systems, Computer Science, Statistics, Mathematics, Business, Finance, or a related field with at least 10 years of relevant experience or Master’s degree in a related field with at least 8 years of relevant experience.
• Extensive experience independently designing, developing, deploying, governing, and supporting complex business intelligence and reporting solutions in a production environment.
• Advanced experience with Power BI and SQL, including semantic modeling, DAX, Power Query, visualization design, complex querying, reporting-layer transformations, row-level security, data validation, performance optimization, and governed deployment practices.
• Experience serving as a senior technical resource for complex initiatives involving multiple business functions, technical teams, regions, or global stakeholders, including providing technical review, guidance, and mentoring to analysts or developers.
• Experience translating complex or ambiguous reporting needs into sustainable analytics solutions and communicating technical concepts, findings, risks, dependencies, and data limitations to leadership and technical and non-technical audiences.
• Strong knowledge of dimensional modeling, relational data structures, reporting-ready data design, data quality, reconciliation, lineage, access controls, validation, documentation, and production support.
• Ability to assess reporting needs, identify data and feasibility constraints, and recommend sustainable solutions that balance business value, scalability, risk, and effort.
• Ability to govern shared deployment processes, resolve complex release issues, and guide analysts in applying established technical, validation, security, and documentation standards.
• Strong analytical and problem-solving skills, including the ability to identify trends, anomalies, relationships, and limitations and translate them into improved analytics products and clear guidance for users.
• Strong project ownership, organization, and prioritization skills, with the ability to coordinate contributors and drive complex initiatives to completion in a matrixed organization.
• Excellent written, verbal, facilitation, and presentation skills, including the ability to explain complex technical and analytical concepts clearly to varied audiences.
• Commitment to continued technical development and the practical application of emerging tools, automation, and best practices. 
• Ability to travel domestically if projects require.

Preferred:

• Experience in healthcare, medical devices, life sciences, sales operations, commercial analytics, or another regulated and data-intensive environment is preferred.
• Snowflake or a comparable cloud data platform.
• Microsoft Azure DevOps or comparable release-management and work-tracking tools.
• Microsoft Power Automate or comparable workflow automation technologies.
• SAP, SAP Commissions, Salesforce, or other enterprise commercial data sources.
• Development of reusable reporting views, shared semantic models, or analytics assets used across multiple reports, portfolios, or regions.