Senior Business Intelligence Analyst

AtriCure • Mason, OH

7h

About The Position

The Senior Business Intelligence Analyst delivers scalable analytics, reporting solutions, and business intelligence capabilities to support data-informed decision-making. The role designs, develops, and optimizes sales reporting, data models, automation solutions, and analytical frameworks across SQL Server, Oracle, Power BI, Microsoft Excel, and other business intelligence platforms. The analyst translates complex business requirements into actionable insights and serves as a subject matter expert in reporting architecture, data governance, automation, and commercial analytics. The position also drives continuous improvement across systems, processes, and reporting capabilities.

Requirements

• Bachelor’s degree in Business Analytics, Data Science, Information Systems, Finance, Statistics, Mathematics, or a related field, or an equivalent combination of education and experience.
• At least 5 years of experience in business intelligence, data analytics, or a related field.
• At least 3 years of advanced Power BI development experience, including complex data modeling and DAX.
• Expert-level SQL skills, including developing complex queries, views, stored procedures, and data transformation logic.
• Experience working with Oracle ERP or other Oracle reporting environments.
• Advanced experience designing and maintaining reporting and dashboard solutions.
• Proficiency with Microsoft Excel, including advanced formulas, Power Query, and VBA/macros development.
• Strong experience integrating and analyzing data from multiple systems and sources.
• Ability to gather business requirements and translate them into scalable technical solutions.
• Strong analytical, problem-solving, and critical thinking abilities.
• Highly effective verbal and written communication skills.
• Ability to travel 10%.
• Ability to regularly walk, sit, or stand as needed, and occasionally bend and push/pull as needed.
• Ability to pass a pre-employment drug screen and background check.

Nice To Haves

• Advanced degree in Business Analytics, Data Science, Information Systems, or a related discipline.
• At least 7 years of experience in business intelligence, data analytics, or a related field.
• At least 5 years of Power BI development experience.
• At least 3 years of Oracle ERP or other Oracle reporting experience.
• At least 3 years of Sales Operations experience in the pharmaceutical, biotechnology, or medical device industry.
• Experience with Microsoft Fabric, Azure Data Services, and cloud-based analytics platforms.

Responsibilities

• Develop and manage scalable data models, pipelines, and reporting frameworks for Sales Operations, commercial analytics, and executive reporting.
• Lead reporting initiatives related to Oracle ERP and associated business systems, including implementations, upgrades, data migrations, and SQL-based reporting for Sales Operations.
• Design, optimize, and maintain complex SQL queries, stored procedures, and scripts across multiple data environments and sources.
• Design, develop, and maintain dashboards, reports, and analytical solutions using Power BI, Oracle reporting tools, Microsoft Excel, and other business intelligence platforms.
• Deliver reporting and actionable insights on sales performance, forecasting, and key business metrics to support strategic decision-making.
• Collect, cleanse, transform, and integrate data from multiple sources for business intelligence initiatives.
• Ensure data accuracy, integrity, consistency, and performance across reporting and analytics environments.
• Partner with IT and cross-functional stakeholders to improve data accessibility, reporting capabilities, and decision-support tools.
• Establish and champion best practices for reporting development, documentation, testing, deployment, and data governance.
• Lead and support strategic initiatives focused on process improvement, operational excellence, and reporting modernization.
• Identify and implement automation opportunities to streamline reporting and data management activities.
• Perform root-cause analysis and resolve data, reporting, visualization, and system integration issues.
• Develop and maintain advanced VBA solutions, macros, and automated workflows to improve efficiency.
• Mentor analysts and business users on reporting tools, data interpretation, and analytics best practices.
• Demonstrate consistent, reliable, and professional work performance.
• Manage multiple priorities in a fast-paced, dynamic environment and exercise sound judgment and independent decision-making.
• Collaborate effectively with cross-functional teams and business stakeholders while balancing attention to detail with strategic priorities.
• Perform additional duties and special projects as assigned.

Benefits

• Medical and dental coverage beginning on the first day of employment.
• 401(k) with matching.
• 30 days of paid parental leave for new mothers and fathers, in addition to maternity leave.
• Volunteer time off.
• Pet insurance.
• Corporate-based employees have access to an on-site fitness center and cafeteria.
• Additional benefits are available; the complete list is on the company careers website.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior