Azure Data Solutions Architect (Snowflake)
Galderma Laboratories

Job Info

---

Company Overview
Galderma, the world's largest independent global dermatology company, was created in 1981 and is now present in over 100 countries with an extensive product portfolio of prescription medicines, aesthetics solutions and consumer care products. The company partners with health care practitioners around the world to meet the skin health needs of people throughout their lifetime. Galderma is a leader in research and development of scientifically-defined and medically-proven solutions for the skin. For more information, please visit www.galderma.com

Job Description
The Azure Data Solutions Architect leads initiatives to develop and implement business-driven BI and analytics end-to-end solutions to enable business to win in the markets and gain competitive advantage. This position serves as primary liaison between IT Analytics, Shared Services, and Business Unit.

Job Responsibilities

• Work together with IT Analytics leadership to develop sustainable hybrid Data Warehouse Platform vision, strategy and roadmap.
• Collaborate with internal customers (i.e. functional/subject matter experts and/or end users) in various departments to build knowledge regarding their specific business area, unique processes, and operational data needed to support business objectives.
• Educate the business and promote best practices on how to leverage BI and analytics solutions, as well as help facilitate discussions to anticipate future needs and opportunities.
• Ensure high-performance access to diverse data sources in hybrid data warehouse environments
• Establish standards for technology and business processes
• Direct complex team projects to ensure high quality and timely results; project teams may consist of IT (Information Technologies) employees, functional experts/ end-users from various internal departments, external consultants, and/or vendors
• Other duties as assigned

Minimum Requirements

• Bachelor's degree in Information Technology or a related field, required
• Master's degree preferred
• Minimum 8 to 10 years of related experience within a corporate environment required; experience must include successful track record with data warehouse architecture, ETL (extract/transform/load) processing, understanding of BI and reporting platforms.
• Lead analysis, architecture, design, and development of traditional data warehouse, data pipeline and business intelligence solutions.
• Strong background in cloud (Azure) environment with specific experience in Snowflake, Databricks and Data Factory.
• Experience using PowerBI, Tableau or BOBJ (Business Objects) strongly preferred
• Strong experiences with on premise DW (Oracle preferred)
• Strong experience with SQL. and shell scripting.
• Good understanding of various Data Models such as Dimensional Data Modeling, Extended Star Schema Modeling, Snowflake Modeling, Physical and Logical Data Modeling.
• Familiarity with DevOps best practices and automation of documentation, testing, build, deployment, configuration, and monitoring
• Ability to indirectly oversee a cross-functional team
• Ability to balance several projects while delivering high quality results in a timely manner.
• Previous experience establishing and managing a budget, preferred
• Must be able to demonstrate excellent written and oral communication skills
• Solid understanding of domains such as ERP, CRM, SCM or Infrastructure Enablement systems, working knowledge of project and product management is preferred

Other Important Information
Where permitted by applicable law, successful applicants must be fully vaccinated against COVID-19 by their date of hire to be considered for employment. Proof of vaccination required.

• The work environment characteristics and physical requirements described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• While performing duties of this job, the employee may or may not be frequently/or occasionally required to:
• Stand; walk; sit; climb or balance; stoop; kneel; crouch; talk or hear; and taste or smell.
• Climb stairs or ride elevators.
• Lift and/or move up to 25 pounds.
• Use close vision, distance vision, peripheral vision, depth perception, and ability to adjust focus.
• Manipulate keyboard or otherwise access computer, telephone and hand-held devices.
• Be exposed to outside weather conditions while going in and out of office buildings.
• Be exposed to moderate noise level usually in warehouse settings.
• Be exposed to moving equipment, mechanical parts, and/or high places; or moving between air-conditioned and non-air-conditioned environments.
• Travel is as needed, estimated around 10 - 15%.

This job has expired.