Commercial Business Analyst

Aerogen; Chicago (IL); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Competitive bonus plan

Above market life insurance

Opportunities for development and专业成长

Aerogen Connect program

Job summary

Aerogen is seeking a Commercial Business Analyst to deliver data analytics, visualization and insights for the global commercial teams. You will streamline data sources, develop dashboards and provide actionable intelligence to leadership and sellers.

The role emphasizes cross-functional collaboration, data quality, and scalable reporting to support strategic decision making and commercial performance improvement.

Qualifications

• Demonstrated track record with data analysis with SQL required (2 to 3 years) with data analytics (CRUD operations; queries, basic database structure experience).
• Excellent Microsoft Excel skills – complex formula required, VBA desirable.
• CRM Experience desirable (Salesforce).
• Experience with Business Intelligence tools (Tableau a plus).

Responsibilities

• Contributes to bring clear visibility of country/region/global overall business performance.
• Identify, extract and compile relevant data to build and communicate insight on the overall health of the business, to include Strat Plan support, QBR support, Monthly Business Updates, commercial modeling, and other projects assigned.
• Ensure reports are delivered promptly and on time to support decision making.
• Develop strong cross functional alignment to ensure high level of data quality.
• Ownership of performance reporting delivery, timing, and accuracy.
• Provide the required content for regular commercial management meetings, quarterly business review and board meetings.

Skills

SQL

Excel

PowerPoint

Communication

Attention to detail

Education

Degree in IT or Business Management

Tools

Salesforce

Tableau

Job description

About Aerogen

Headquartered in the vibrant city of Galway, Ireland, with offices around the world, Aerogen is proud to be the world leader in acute care aerosol drug delivery. Recognised through multiple MedTech awards, including being named Galway Chamber Company of the Year 2025, and twelve‑time winner of the Zenith Award for Respiratory Care Excellence in North America, our employees make a difference to patients’ lives every day, having reached over 30 million patients in more than 80 countries.

Today, Aerogen is powered by a global team representing 54 nationalities, working together with a shared commitment to improving patient care. Our talented and skilled team collaborate to innovate, challenge and test not only in relation to our products but every facet of how we work. We lead the way by finding innovative solutions to even the most complex problems, all in the name of delivering better patient outcomes.

Our business continues to grow rapidly across the globe and, as we grow, our core culture of “We Care” universally connects us. We believe that your ambition and integrity fuels ours, and we are committed to supporting our employees to reach their full potential through tangible investment in their careers.

What is the role?

This role is key to the delivery, execution and support the development of a systematic framework of data analytics and strategic storytelling within the commercial teams. This role is responsible for data and analytics, data visualization, and data insights. This individual will continuously look for improvement and drive efficiency in managing a growing number of data sources and requirements for actionable insights. The role of Commercial Business Analyst will continuously evaluate the business to drive actionable insights to help guide decision making for leadership and sellers alike.

Key Responsibilities

• Contributes to bring clear visibility of country/region/global overall business performance.
• Identify, extract and compile relevant data to build and communicate insight on the overall health of the business, to include Strat Plan support, QBR support, Monthly Business Updates, commercial modeling, and other projects assigned.
• Ensure reports are delivered promptly and on time to support decision making.
• Develop strong cross functional alignment to ensure high level of data quality.
• Ownership of performance reporting delivery, timing, and accuracy.
• Provide the required content for regular commercial management meetings, quarterly business review and board meetings.
• Collaborate to develop a system enabling a high level of accuracy and quick response times data requests, providing deeper insight into commercial performance.
• Develop strong alignment with financial team to ensure data accuracy and build a positive relationship.
• Support compensation and quota program build, analysis, rollout and maintenance to ensure accuracy and support needed reporting.
• Continuously review current processes to improve data accuracy and speed of execution ensuring full utilization of tech stack and data sources.
• Create and manage audit processes for ongoing accuracy of all reporting.
• Support the development of a customer‑centric analytics framework providing actionable insight to all stakeholders involved in the customer journey.
• Create new regular reports and ad‑hoc analysis to enable commercial management team to recognize the profile and behaviors that need to be promoted to drive Commercial Excellence.
• Support the data‑driven approach to GTM initiatives (including Spiffs, campaigns, market expansion, etc.).
• Evolve, and develop new reports and dashboards with focus on ease of replication to guarantee scalability, generating insights vs. presenting data.
• Collaborate with internal Commercial Excellence team on evolution of CRM / data visualization tools.
• Proactively look for opportunities to develop analytical capabilities and acquire new Aerogen business knowledge (stay curious).
• Continuously look for potential improvement on how data is extracted, transformed and presented with a strong focus on scalability.
• Develop a strong understanding of the challenges faced by the commercial team to understand requirements and deliver pertinent solutions.
• This role works integrally with the Sr. Systems Analyst and admin working on data and analytics and connectivity of data to PULSE.
• Support other initiatives including but not limited to…
• Monthly forecasting: support region and country managers in cross checking the validity of their forecast input.
• Promote utilization of existing self‑service analytical tools.
• Engage with Demand planner.
• Ad hoc analysis creation as assigned, including but not limited to: support resource planning effort (country archetype, segmentation), assess sales channel effectiveness, board‑level presentations.

Education and Experience

• Demonstrated track record with data analysis with SQL required (2 to 3 years) with data analytics (CRUD operations; queries, basic database structure experience).
• Excellent Microsoft Excel skills – complex formula required, VBA desirable.
• CRM Experience desirable (Salesforce).
• Experience with Business Intelligence tools (Tableau a plus).

Key Skills

• Strong analytical problem solver.
• Ability to present ideas and complex concepts clearly.
• Excellent PowerPoint skills.
• Excellent attention to detail.
• Excellent organizational skills.
• Ability to extract actionable insight from large data sets.
• Flexible approach, enthusiastic and confident.
• Excellent written and oral communication skills.
• Ability to multi‑task and be comfortable with change.
• Ability to work within a team environment to achieve agreed‑upon company goals.
• Level of drive, energy to consistently taking initiative to drive business performance, improve business processes and cross‑functional team performance.
• Level of ambition and drive matched with self‑awareness and desire to learn and develop.
• Educated to degree level standard in IT or Business Management.
• Open to travel as required, both domestic and international up to 25%.

Benefits

• Competitive bonus plan.
• Above market life insurance.
• Opportunities for development and professional growth.
• "Aerogen Connect" – our employee‑led program that helps our global teams unite and have fun.
• We donate 1% of profits and time to charities and organizations.

Aerogen is committed to promoting diversity, inclusion, and equality in the workplace. If you have difficulty using our application process, please contact us via email at [e-mail]. Please provide your name and preferred contact method.