Master Data Architect

Quality, efficiency, and safety all play a big role in our work at Danone. Manufacturing the best products and supplying them to meet demand is a key driver for the Supply Chain team. We are currently looking to hire a Master Data Analytics Manager based in White Plains, NY, or Louisville, CO!

This position is for a Master Data Architect/Engineer who will build and maintain Danone’s Business Intelligence Analytical Warehouse. This analytical data warehouse will support Operations Functions and reporting needs. This individual will design and implement the database model, develop a robust star schema, hierarchy reference tables and coordinate and aggregate all related data from the source system to populate the model which will feed into highly synced interactive dashboards for consumption by internal cross functional business partners.

What You Will Do:

• Design and build a functional analytical warehouse in Snowflake/Databricks or other data platform to support Danone’s analytical initiatives.
• Engage with cross functional leaders for data builds and reporting needs; guide non-technical consumers in development specs criteria and engagement for analytical business consumption.
• Help drive strategic and tactical discussions leveraging SAP and other data sources.
• Create ETL dataflows in SQL or Alteryx Designer and manage the ETL load schedule.
• Build interactive, engaging, and attractive MS PowerBI reports and Dashboards that not only display aggregated values, but help prompt new areas of analysis and data discovery. The candidate should be comfortable working across business areas to understand the reporting requirements and then identify the next level of complimentary data that will expand the context of the dashboard.
• Query data out of SAP and into the Snowflake/Databricks/ SQL Server data warehouse.
• Enhance SAP data through the ingestion and blending of internal and external third-party data for complementary analysis (customer data, transportation data, other 3rd party). Data may be sourced from other RDBMS, such as Oracle, IBM DB2, or flat files. It may require interfacing with external data providers to coordinate access, data definitions, and the method of automation.
• Execute and maintain Danone’s data processing activities including daily, weekly, and monthly reporting metrics and develop snapshot logic for history captures and trend analysis.
• Perform special projects and analyses as required.
• Identification and automation of new reporting functions to reduce manual efforts (SQL).
• Engage in various debug and break-fixes relative to above activities.
• Maintain a healthy ecosystem for efficient and timely (daily) updates and refresh.
• Must be willing and able to travel 10% of the time.

The base compensation range for this position is $120,000 - $160,000 commensurate with experience. Danone North America additionally offers a performance-based bonus and has a strong benefits package including Medical, Dental, Vision, Prescription Drug Coverage, 401k Plan, Wellness Program, Life Insurance, Tuition Reimbursement, Flexible Time Off, and Paid Parental Bonding Leave, among other benefit plan options. To give our employees flexibility, Danone is a hybrid work environment.

Qualifications You Must Have:

• Typically requires a University Degree and minimum 10 years prior relevant experience or an Advanced Degree in a related field and minimum 7 years of experience or in absence of a degree, 14 years of relevant experience.
• Must be authorized to work in the U.S. without sponsorship now or in the future. Danone will not offer sponsorship for this position.
• Must be comfortable interacting in cross functional organization at various levels and able to adapt messaging to audiences’ technical skillsets.
• 5 years analyzing data and running reports (PowerBI or Tableau).
• 5 years’ experience with programming (SQL or Python).
• 5 years’ experience with ETL technologies (SSIS or Alteryx).
• 5 years’ experience managing database objects (DDL).
• Ideally experience with Snowflake & Databricks, Delta Lake & Databricks SQL Warehouse.

About Us:

At Danone North America, you’ll work with some of the best-known food and beverage brands in the world like Activia, Silk, Two Good, Oikos, evian, and Happy Family. You’ll be part of one of the largest Certified B Corps™ in the world, working together to make sure our brands create real benefits for people, communities, and the planet. We have 6,000 employees across the U.S. and Canada. Come join our movement for a healthier world: One Planet. One Health BY YOU.

Danone North America is proud to be an Equal Opportunity employer. It is our policy to give equal employment opportunities to all qualified persons without regard to legally protected characteristics, or any other consideration made unlawful by applicable federal, state/provincial and/or local law. For our EEO policy statement and your EEO rights under law click here.

#LI-NORAM

#LI-ES2

#LI-HYBRID