US Business Analyst – Data & Analytics

Galderma is the emerging pure-play dermatology category leader, present in approximately 90 countries. We deliver an innovative, science-based portfolio of premium flagship brands and services that span the full spectrum of the fast-growing dermatology market through Injectable Aesthetics, Dermatological Skincare and Therapeutic Dermatology. Since our foundation in 1981, we have dedicated our focus and passion to the human body's largest organ - the skin - meeting individual consumer and patient needs with superior outcomes in partnership with healthcare professionals. Because we understand that the skin, we are in shapes our lives, we are advancing dermatology for every skin story.

We look for people who focus on getting results, embrace learning and bring a positive energy. They must combine initiative with a sense of teamwork and collaboration. Above all, they must be passionate about doing something meaningful for consumers, patients, and the healthcare professionals we serve every day. We aim to empower each employee and promote their personal growth while ensuring business needs are met now and into the future. Across our company, we embrace diversity and respect the dignity, privacy, and personal rights of every employee.

At Galderma, we actively give our teams reasons to believe in our bold ambition to become the leading dermatology company in the world. With us, you have the ultimate opportunity to gain new and challenging work experiences and create an unparalleled, direct impact.

Job Title: US Business Analyst- Data & Analytics

Location: Boston, MA

US Business Analyst – Data & Analytics is responsible for planning, coordination, and delivery of reporting and dashboards.  Deeply understand the Commercial and operational data needs across the organization and collaborate with key stakeholders to define and standardized KPIs & Dashboards to service critical business functions and operations in the most impactful way possible. This role will act as business partner to the US Commercial Ops organization.

Activities and responsibilities:

• Plan, coordinate and deliver Analytics services. Own the design, development, and maintenance of scalable solutions for ongoing metrics, reports, analyses, dashboards, visualizations etc. to support analytical and business needs.
• Complete "Data Quality Reviews" - serve as an internal consultant reviewing business partner data pipeline - auditing the calculation logic tracking our most critical trust related metrics
• Translate ambiguous business problem statements into analysis requirements. Work with internal and external customers to define best output based on expressed stakeholder needs.
• Recognize and adopt best practices in reporting and analysis, data integrity, test design, analysis, validation and documentation.
• Write queries and produce data efficiently and have in-depth knowledge of the data available in area of expertise. Pull the data needed with standard query syntax; periodically identify more advanced methods of query optimization. Convert data to make it analysis ready. Monitor and troubleshoot data issues in data pipelines.
• Manage small projects and act as SME/IT lead in larger projects
• Recommend and support the introduction of new or improved technical and business practices
• Based on the business requirements, provide analysis about complexity and effort estimation
• Assist in defining and reviewing the technical requirements for systems, including security, integration, performance and quality requirements
• Facilitate transition of the technical designs to the appropriate programming resources to help confirm clear and complete understanding of the designs
• Contribute to project deliverables including vision documents, status reports, test plans, validation protocols, etc.
• Communicate status, business impacts and system changes to team members, business partners, sponsors, management and other interested parties
• Manage incoming support requests; help business users troubleshoot application issues
• Engage in problem determination, workaround resolution, and root cause analysis
• Establish and maintain effective working relationships with all stakeholders

Education and minimum requirements:

• Bachelor's degree in information technology or a related field, required
• Master’s degree plus
• Power BI Certification
• 5 or more years of experience in a IT Data and Analytics business analyst role required.
• Experience in the Life Sciences industry is preferred
• 3 years strong Power BI experiences 
• Leverage Tabular Editor, and DAX Studio to quickly and efficiently perform model operations across complex deliverables.
• Experience with semantic model optimization
• Foundation and knowledge of the following areas: Data Warehousing, Data Transformation, Data Quality, Reporting and Data Analytics, understanding query performance tuning methods.
• Experience with deployments of BI Solutions into upper environments and row level security 
• 5+ experience writing complex SQL queries
• 2 + years working experience in Snowflake and cloud environment (Azure preferred) 
• Experience with Oracle database and PL/SQL syntax 

Next Steps

• If your profile is a match, we will invite you for a first virtual conversation with the recruiter.
• The next step is a virtual conversation with the hiring manager 
• The final step is a panel conversation with the extended team

Our people make a difference

At Galderma, you’ll work with people who are like you. And people that are different. We value what every member of our team brings. Professionalism, collaboration, and a friendly, supportive ethos is the perfect environment for people to thrive and excel in what they do.