Global Data AnalystGlobal Data Analyst- Role Description:The Global Data Analyst takes ownership of Dermalogica's Global and International reporting and analytics ecosystem across all markets and channels. This role is responsible for maintaining, enhancing and occasionally building dashboards in Tableau and Power BI, working with IT and the market teams to ensure data quality and accuracy across global sell-in and sell-out data sets. Success in this role means empowering stakeholders across the business with reliable, timely insights.
Our analytics agenda is moving at pace and this role is central to achieving our goal of industry-leading, globally consistent reporting. Key priorities include establishing a standard data model within a future-proofed environment, continuing to develop and consolidate analytic tools in Power BI, ensuring data integrity and governance across markets, and building analytical capability across the wider business. We need an inquisitive individual who can drive this agenda forward as our global footprint and channel mix continue to expand.
Key Job Responsibilities: - Ownership, Development & Maintenance of Reports & Dashboards (Power BI)
- Own and maintain all global and international reports and data flows in Power BI - including proactive troubleshooting, validating data quality and accuracy, and updating dashboards with relevant new information (e.g. new innovations, markets, channels).
- Ensure dashboards are kept up to date with manual data reports (such as Amazon US sell-out data, provided in an excel format). As part of this, review current distribution of reports in Excel and determine what can be simplified/automated in Power BI.
- Take full ownership of sell-out data integrity and act as the primary bridge between business users and IT for sell-in data queries. Drive ongoing simplification and process streamlining across all reporting.
- Provide ad hoc analytical support for global departments, market GMs and senior leadership, responding to dashboard queries and delivering timely, accurate data across markets and channels.
- Ensure global and regional departments have standardized, user-friendly analytical tools and dashboards for self-sufficient performance management - including monitoring usage, retiring unused workbooks, and keeping all reports accessible in the proper formats.
- Design and build new Power BI dashboards end-to-end - from data engineering and modelling through to visualization - with a focus on question-led, actionable insights and performance benchmarking (vs. target, vs. prior year, vs. market).
- Data Analytics
- Provide monthly innovation tracking updates across markets as input to global performance calls, analyzing launch performance vs. expectations and identifying trends by region and channel.
- Build analytical models to assess how new business opportunities impact existing channels across markets, highlighting potential risk factors and identifying growth opportunities based on cross-market performance and sister brand insights
Experience and Competencies Required: - Bachelor's degree in Computer Science, Information Systems, Data Science, Business Analytics or another related field.
- 3-5 years of previous analytical experience
- Proficient in SQL, Power BI, and Excel, with hands-on experience building visualizations from large data sets and multiple data sources. Additional BI/ETL tools, automation skills (Python, Power Automate), or programming knowledge are a plus.
- Self-motivated, detail-oriented, and highly organized with a willingness to learn autonomously
- Tech savvy with an open mindset about learning new technologies, systems, and tools
- Strong ownership mindset with excellent initiative and follow-through; a track record of proactively identifying opportunities and driving end-to-end solutions in a fast-paced environment
- Analytical mindset with the ability to dive deep into complex, ambiguous problems, perform root cause analysis, and ask the right questions to deliver solution-focused outcomes
- Courage to challenge established norms in a constructive way and drive change
The expected base salary range for this position is $80K to $100K. The exact base salary is determined by various factors including experience, skills, education, and budget. This position is also eligible for participation in the company discretionary bonus plan, based on personal performance and company results.
The role will be based out of the corporate headquarters in Carson, Los Angeles. It will be hybrid with applicable on-site work guidelines.
Student visas and H1B sponsorships will not be considered at this time.
Apply now and become a team member for the preeminent global leader in skincare providing a competitive and comprehensive health benefits package including life/accident/disability insurance, wellness programs, paid family leave, domestic partner benefits, education/training programs, product allowances, fitness reimbursement, 401(k) matching, and a host of other great perks.