The Opportunity:
We are seeking a skilled Data Analyst to join our team. The ideal candidate will be responsible for analysing, interpreting, and presenting data to support decision-making processes across the organization.
The Data Analyst will work closely with various departments/stakeholders to generate data analysis, reports, dashboards, and insights, and provide actionable recommendations. Especially with the Commercial Excellence (Sales Force Effectiveness, Commercial Operations), Customer Service, Supply Chain functions and other functions like Portfolio/Marketing, ABS (Avantor Business Systems).
As part of the Commercial Excellence Team, reporting to the AMEA Sales Force Effectiveness Manager, the Data Analyst supports Avantor’s continuous improvement & operational excellence to drive business performance within the AMEA region.
The position is cross-BUs and covers both Laboratory Solutions Segment (LSS) and Bioscience Production Segment (BPS) analytical needs.
We are seeking a highly skilled and results-driven Senior Business Analyst with advanced expertise in data analysis, reporting, and business intelligence tools. This individual will play a critical role in bridging the gap between business needs and technical solutions, working closely with cross-functional teams to support data-driven decision-making processes. The ideal candidate will have strong experience with advanced Excel, Power BI development, Python, SQL, and Snowflake integration to deliver actionable insights and improve business performance.
How you'll thrive and create an impact:
Key Responsibilities:
- Sales Performance Dashboard Development:
Design, develop, and maintain Sales Performance Dashboards in Power BI to track key sales metrics, KPIs, and trends. Ensure that dashboards provide Bi Monthly visibility into sales performance, enabling leadership to make informed, data-driven decisions. - C4C(Sales CRM) Report Updates & Development:
Manage and update C4C (CRM) reports to provide actionable insights into Sales Visits, sales activities, and opportunities. Ensure that dashboards provide weekly visibility. Develop new reports as per requirements - Optimizing Commercial Excellence through Data Analytics:
Leverage data analytics to drive Commercial Excellence initiatives across the business. Analyze sales, marketing, and operational data to uncover trends, identify areas for improvement, and optimize performance. Collaborate with the commercial teams to deliver insights that support business objectives and enhance sales effectiveness. - Power BI Development & Reporting:
Lead the development of business intelligence solutions using Power BI. Create interactive dashboards and reports that present insights in a visually compelling and actionable manner. Use DAX and Power Query M to transform and model data, ensuring reports are optimized for performance and clarity. - Snowflake Integration:
Work closely with the IT and data teams to integrate Snowflake as a central repository for data management. Develop and maintain efficient ETL processes to load, transform, and deliver data into Snowflake for reporting and analytics. - Stakeholder Collaboration:
Collaborate with sales leadership, business analysts, and IT teams to ensure alignment of reporting tools with business needs. Provide training and guidance to stakeholders on how to use reports and dashboards effectively.
What we're looking for:
- Education:
Bachelor’s degree in Business Analytics, Computer Science, Information Systems, or a related field. Advanced certifications in relevant tools (Power BI, SQL, Python, Excel, etc.) are a plus. - Experience:
- 5+ years of experience as a Business Analyst, Data Analyst, or similar role.
- Strong proficiency in Advanced Excel (Pivot Tables, Macros, VBA scripting, complex formulas).
- Extensive experience in Power BI development including data modeling, DAX, and Power Query M.
- Hands-on experience with Snowflake integration and cloud-based data warehousing.
- Strong SQL, Python skills for complex data extraction, transformation, and reporting.
- Technical Skills:
- Advanced Excel (including VBA and complex functions).
- Power BI (DAX, Power Query M, Dashboard development).
- SQL, Python (T-SQL, PL/SQL, or similar).
- Snowflake (data integration, ETL processes).
- Familiarity with data integration tools and cloud platforms (AWS, Azure, etc.) is a plus.
- Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication and interpersonal skills.
- Ability to translate business requirements into technical solutions.
- Detail-oriented with a strong commitment to data accuracy and quality.
- Ability to manage multiple tasks and deadlines in a fast-paced environment.
Disclaimer:
The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this position. Avantor is proud to be an equal opportunity employer.
Why Avantor?
Dare to go further in your career. Join our global team of 14,000+ associates whose passion for discovery and determination to overcome challenges relentlessly advances life-changing science.
The work we do changes people's lives for the better. It brings new patient treatments and therapies to market, giving a cancer survivor the chance to walk his daughter down the aisle. It enables medical devices that help a little boy hear his mom's voice for the first time. Outcomes such as these create unlimited opportunities for you to contribute your talents, learn new skills and grow your career at Avantor.
We are committed to helping you on this journey through our diverse, equitable and inclusive culture which includes learning experiences to support your career growth and success. At Avantor, dare to go further and see how the impact of your contributions set science in motion to create a better world. Apply today!
EEO Statement:
We are an Equal Employment/Affirmative Action employer and VEVRAA Federal Contractor. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state/province, or local law.
If you need a reasonable accommodation for any part of the employment process, please contact us by email at recruiting@avantorsciences.com and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.
3rd party non-solicitation policy:
By submitting candidates without having been formally assigned on and contracted for a specific job requisition by Avantor, or by failing to comply with the Avantor recruitment process, you forfeit any fee on the submitted candidates, regardless of your usual terms and conditions. Avantor works with a preferred supplier list and will take the initiative to engage with recruitment agencies based on its needs and will not be accepting any form of solicitation
