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 bodys 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:

• Bachelors degree in information technology or a related field required
• Masters 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

What we offer in return

• A great work environment with an inspiring work ambiance
• Growth and development possibilities
• An excellent benefits program starting day one
• Pension program after one year of service (company contribution of up to 10%)
• Tuition Reimbursements
• Service awards program

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 youll 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.