Senior Data Analyst- Python

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.any other characteristic protected by federal, state/province, or local law.