US Business Analyst – Data & Analytics

Whether it's the unique breadth of our integrated offering that covers Injectable Aesthetics, Dermatological Skincare and Therapeutic Dermatology products; or our commitment to recognizing and rewarding people for the contribution they make - working here isn't like anywhere else.

At Galderma, we actively give our teams reasons to believe in our 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