Sr. Supply Chain Data Analyst

The Opportunity:

Avantor is looking for a dynamic, forward-thinking, and experienced Sr. Supply Chain Data Analyst, who will be responsible for delivering results against some of the most complex business and technology initiatives.

This role will be a full-time position based out of IND- Coimbatore. If you are passionate about solving complex challenges and driving innovation – let’s talk!

Our organization is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

The Global Supply Chain Data Analyst II Interprets data and turns it into information which can offer ways to improve a business, thus affecting business decisions. Data Analysts gather information from various sources and interpret patterns and trends, providing a clear picture of the business landscape.​ This role will contribute to numerous BI projects in various stages of the product lifecycle. The successful candidate possesses the energy to deliver tasks individually and within the team utilizing various business intelligence (BI) solutions, including PowerBi dashboards, advanced SQL, skillset developing reporting solutions.

MAJOR JOB DUTIES AND RESPONSIBILITIES (List in order of importance)

• Quickly demonstrate understanding of business use cases and implications of various data structures and visualization options
• Translates business requirements into technical requirements to implement complex solutions.
• Manage Project Priorities and deliverable using Agile methodology in JIRA platform.
• Analyze data / systems and develop detailed specifications for implementation and documentation.
• Serve as the Subject Matter Expert in reporting and automation solutions and consult business stakeholders.
• Mentors, collaborates with and advises team members on PowerBi, SQL and BI and other reporting solutions.
• Build and/or manage complex data sets and dataflows (ex. PowerBi dataflows, Snowflakes Data Warehouses, AWS, Azure)
• Author complex automated or manual reports, KPIs, and dashboards.
• Provide support to report authors on visualization usage, data modeling, DAX and Power Query.
• Designs, builds, tests, implements, maintains, and supports BI deliverables with a focus on Microsoft Power BI.
• Understand business reporting specifications and dataset needs, relating technical requirements to architectural and other resources (i.e., SQL)
• Mix great design and user experience to deliver easy to consume reports and data visualizations that users love.
• Partner with IT to drive innovation and key projects to find new best practices across the supply chain operations.
• Serve as technical expert on SAP and SAP APO data sources to facilitate reporting using PowerBi, QlikView or similar data visualization tools.
• Production and distribution of daily, weekly, and monthly reports and dashboards.
• Advancing analytical maturity toward producing Predictive analytics

CHARACTERISTICS
 

• Know how and when to use tools available for a given situation and can explain the reasons for this choice.
• Strong capabilities in collecting, organizing, and analyzing significant amounts of information with attention to detail and accuracy.
• Ability to look at numbers, trends, and data and come to new conclusions based on the findings.
• Strong ability to translate complex findings and data in a comprehensible manner.
• Precision and attention to detail in analysis to ensure accuracy of their insights and decisions.
• Ability to use data to identify and solve business problems.
• Comfortable working in newly forming, ambiguous areas where learning and adaptability are key skills.
• Must be able to successfully manage multiple tasks, projects, and responsibilities.
• Demonstrated ability to work in cross-functional teams as well as independent setting.
• Experience with Agile/Scrum development methodology preferred
• Establish and lead transformative processes across an organization to establish consistency and efficiency.
• Manage a variety of viewpoints to build consensus and create positive outcomes for all parties.

QUALIFICATIONS (Education/Training, Experience and Certifications)

• Bachelor's Degree (Math, Economics, Statistics, Engineering, Business, Computer Science, or similar) required.
• Master's Degree (preferred)
• Minimum 5+ years of performing system improvements and developing automated reporting solutions and data visualizations.
• Excellent communication skills and Fluent in English
• Ability to work efficiently and effectively in a virtual environment.
• Able to effectively work on multiple projects.
• 3+ years of experience in building and optimizing large and complicated SQL statements.
• 3+ years of experience using Microsoft Power BI as an enterprise reporting solution.
• Knowledge and experience on how to grow and integrate Power BI services by designing and deploying workspaces, data models, app tiers, gateways, report services, dashboard support, Team's integration, and Mobile app deployment is preferred.

Certification or significant progress towards completing one or more of the following Microsoft certification exams preferred:

• Exam DA-100: Analyzing Data with Microsoft Power BI
• Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

KNOWLEDGE SKILLS AND ABILITIES (Those necessary to perform the job competently)

• Advanced excel skills including pivot tables, lookups, logical functions, and VBA.
• Strong experience with PowerBi, Qlik, or similar data visualization tools.
• Strong experience with MS Access database.
• Expert in creating and optimized SQL statements, CTEs, Stored Procedures, Functions.
• Strong knowledge in creating data models and complex SQL statements and optimization in Snowflake.​
• Experience in programming languages such as Python or R is preferred.
• Ability to interact and communicate complex concepts with all levels of the organization.
• Strong analytical abilities
• Excellent communication skills
• Strong multi-tasking skills

ENVIRONMENTAL WORKING CONDITIONS & PHYSICAL EFFORT (Under Typical Positions)

• Typically works in an office environment with adequate lighting and ventilation and a normal range of temperature and noise level. 
• While examining the processes at a warehouse, associate could be exposed to an industrial environment: i.e. the associate may work near loud moving mechanical machinery and maybe exposed to dust, fumes, or gases.
• Work assignments are diversified. Examples of past precedent are used to resolve work problems.
• New alternatives may be developed to resolve problems.
• A frequent volume of work and deadlines impose strain on routine basis. 
• Minimal physical effort is required. Work is mostly sedentary but does require walking, standing,bending, reaching, lifting or carrying objects that typically weigh less than 10 lbs.  
• The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, skills, efforts or working conditions associated with a job.

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