Senior BI Analyst - Power BI & Analytics Leader (Hybrid)

Olympus Corporation; Center Valley (Lehigh County); Hybrid; USD 95,000 - 132,000; Full time

Benefits offered by this job

Competitive salary

Annual bonus

401(k) with company match

Medical coverage

Dental coverage

Vision coverage

Paid vacation and sick leave

Parental leave

Job summary

Olympus Corporation is seeking a Senior BI Analyst II to lead the design, development, governance, and deployment of complex BI and reporting solutions within the OAI Commercial Operations team. You will specialize in Power BI, SQL, DAX, and semantic modeling to transform enterprise data into governed analytics products for sales and marketing.

Collaboration with Data Engineering, IT, and global analytics teams is essential.

Qualifications

• Bachelor’s or Master’s degree with extensive BI experience.
• “Power BI” and “SQL” expertise with governance
• Experience designing, developing, deploying, governing BI solutions
• Senior technical resource for cross-functional initiatives
• Translate complex reporting needs into scalable analytics solutions
• Strong knowledge of dimensional modeling and data quality
• Capable of guiding analysts and delivering governance standards
• Willingness to travel domestically if required.

Responsibilities

• Own the development and delivery of BI and reporting solutions, including requirements gathering, design, development, validation, UAT, deployment, documentation, enablement, monitoring, and support.
• Act as primary technical owner for Corporate Accounts, supporting cross-business, regional, and global initiatives.
• Partner with leaders to define requirements and design scalable, accurate reporting solutions for sales, marketing, and commercial decision-making.
• Design, develop, optimize, and maintain Power BI reports, dashboards, semantic models, DAX, Power Query, and SQL queries.
• Define governance for deployment, environment promotion, release coordination, and documentation; mentor analysts.
• Establish and maintain consistent metric definitions, data relationships, and business rules; validate outputs against sources.
• Provide technical reviews and mentoring to BI Analysts and ensure governance practices.

Skills

Power BI

SQL

DAX

Semantic modelling

Data visualization

Power Query

Governance

Automation

Azure DevOps

Mentoring

Education

Bachelor's degree

Master's degree

Tools

Azure DevOps

Job description

Olympus Corporation is seeking a Senior BI Analyst II to lead the design, development, governance, and deployment of complex BI and reporting solutions within the OAI Commercial Operations team. You will specialize in Power BI, SQL, DAX, and semantic modeling to transform enterprise data into governed analytics products for sales and marketing.

Collaboration with Data Engineering, IT, and global analytics teams is essential.