Analytics Engineer

PUIG Deutschland GmbH; New York (NY); Hybrid; USD 110,000 - 120,000; Full time

Benefits offered by this job

Hybrid work environment

Competitive benefits package

Career development opportunities

Job summary

Puig USA is seeking a technically strong Analytics Engineer to support its data and analytics transformation. You will build and maintain analytical datasets, semantic models, Power BI solutions, automation, and data products to enable better decision-making across the organization.

This role focuses 80% on analytics engineering and 20% on data platform readiness, working with regional/global teams to advance cloud-enabled analytics capabilities in a fast-paced environment.

Qualifications

• Bachelor's degree or equivalent experience in a technical field.
• 3+ years in Analytics/BI/Data Engineering or similar.
• Strong SQL and Python for data transformation, automation and modeling.
• Experience developing Power BI semantic models, datasets, reports, and dashboards.
• Experience integrating data from multiple systems and APIs.
• Experience troubleshooting production reporting and data/automation solutions.
• Strong communication and stakeholder management skills.
• Ability to manage competing priorities in a fast-paced environment.
• Experience with cloud data platforms and modern analytics concepts (dbt, ELT/ETL, CI/CD, version control).
• Experience in consumer goods, beauty, luxury, retail, or related analytics contexts.

Responsibilities

• Design, build, and maintain analytical datasets and semantic models for reporting and self-service analytics.
• Develop scalable Power BI datasets, data models, reports, and dashboards with emphasis on usability and performance.
• Use SQL and Python to transform, automate, and prepare data for analytics use cases.
• Collaborate with stakeholders to translate requirements into practical analytics solutions.
• Improve data accessibility, documentation, and reuse across reporting environments.
• Build lightweight data ingestion and automation processes using SQL, Python, APIs.
• Support data quality, validation, and reliability across datasets.
• Partner with regional/global teams on cloud data initiatives and evolving architecture.
• Contribute to data engineering and scalable data products as capabilities mature.

Skills

SQL

Python

Power BI

Data modeling

ETL/ELT

Communication

Education

Bachelor's degree in Computer Science, Information Systems, Analytics, Engineering, Mathematics, or related field

Tools

APIs

Cloud platforms (BigQuery, Databricks, Snowflake, Redshift, Azure Synapse)

Git

Job description

Select how often (in days) to receive an alert: Create Alert

Puig is a major player in the worldwide fashion and beauty industry. We have a wide portfolio of well-known luxury brands across fashion, fragrance, makeup, skincare, and wellness. Founded more than 100 years ago, Puig is a family-owned company with a long-term commitment to our brands and stakeholders.

Who we are

Puig is a home of Love Brands within a family company that furthers wellness, confidence and self-expression while leaving a better world. For more than a century, our entrepreneurial spirit and passion for creativity have made us a challenger in the premium beauty industry.

With 17 Love Brands across Fragrance and Fashion, Makeup and Skincare, we create stories that connect with people’s emotions and are powered by a global team of over 13,000 passionate professionals. With products sold in more than 150 countries and €5,042 million in net revenue in 2025, and guided by strong values and sustainability commitments, Puig continues to grow as a Home of Creativity: an open-minded space where Creators Of All Kinds are empowered to thrive, innovate and express who they are.

The Opportunity

Puig USA is seeking a technically strong Analytics Engineer to support the next phase of its data and analytics transformation. This role will build and maintain analytical datasets, semantic models, Power BI solutions, automated workflows, and business-facing data products that enable better decision-making across the organization.

This position is ideal for someone who combines strong technical expertise with a practical, solutions-oriented mindset and is comfortable delivering value in a fast-paced, evolving environment. The Analytics Engineer will partner closely with business stakeholders and collaborate across regional and global teams to support Puig USA's long-term data and analytics strategy.

Approximately 80% of the role will focus on Analytics Engineering, including semantic modeling, Power BI development, SQL-based data transformation, Python automation, reusable datasets, and business partnership. The remaining 20% will support Data Platform Readiness, including lightweight data ingestion, API integrations, cloud platform exposure, data quality initiatives, and foundational work that helps prepare the organization for more scalable, cloud-enabled data and analytics capabilities.

This role is being established during a period of meaningful organizational and technology transformation. The U.S. Business & Data Analytics team currently operates an analytics ecosystem across Power BI, Python, Power Automate, SharePoint, SAP, retailer data feeds, and business-managed processes, while the enterprise data platform continues to evolve. The successful candidate will help deliver immediate business value while contributing to the development of more scalable, modern analytics capabilities for the future.

What you'll get to do

• Design, build, and maintain analytical datasets and semantic models that support reporting, self-service analytics, and business decision-making
• Develop scalable Power BI datasets, data models, reports, and dashboards with a strong focus on usability, performance, and consistency
• Use SQL and Python to transform, automate, and prepare data for analytical use cases.
• Partner with business stakeholders to translate requirements into practical, sustainable analytics solutions
• Improve data accessibility, documentation, and reuse across the reporting environment

Data Integration & Platform Readiness

• Build and maintain lightweight data ingestion and automation processes using SQL, Python, APIs, and other available tools
• Help strengthen data quality, validation, reliability, and reusability across reporting and analytical datasets
• Partner with regional and global teams on emerging cloud data initiatives and evolving data architecture practices
• Contribute to foundational data engineering activities and scalable data products as the organization’s capabilities and platform landscape mature

Automation & Operational Support

• Build and maintain Python-based automation solutions that streamline recurring data and reporting processes
• Support Power Automate, SharePoint, and related low-code or no-code workflows used by the U.S. analytics team
• Troubleshoot production issues, data anomalies, and process failures across analytics and automation solutions
• Identify opportunities to reduce manual effort, improve reliability, and simplify ongoing support

Data & Analytics Transformation

• Partner with the Director of Business & Data Analytics to help shape the future analytics and data ecosystem for the U.S.
• Work collaboratively across the Business & Data Analytics team and with cross-functional stakeholders so solutions are connected, shared, and aligned to broader priorities
• Help identify opportunities to modernize reporting, automation, data management, and analytics workflows
• Contribute to the evolution of scalable data products, cloud-based data platforms, and modern analytics engineering practices
• Balance near‑term business needs with longer‑term technology and data transformation objectives

We'd love to meet you if you have

• Bachelor's degree in Computer Science, Information Systems, Analytics, Engineering, Mathematics, or a related field, or equivalent practical experience
• 3+ years of experience in Analytics Engineering, Business Intelligence Engineering, Data Engineering, or a related technical discipline
• Strong SQL and Python skills, including experience building data transformation, automation, and analytical data modeling solutions
• Experience developing and supporting Power BI semantic models, datasets, reports, and dashboards
• Experience integrating data from multiple business systems, APIs, files, and external data sources
• Experience troubleshooting and supporting production reporting, data, and automation solutions
• Strong communication and stakeholder management skills, with the ability to partner effectively with both business and technical teams
• Ability to manage competing priorities, learn quickly, and thrive in a fast‑paced, evolving environment
• Experience with cloud data platforms such as BigQuery, Databricks, Snowflake, Redshift, Azure Synapse, or similar technologies
• Understanding of modern analytics engineering and data architecture concepts, including dbt, ELT/ETL frameworks, semantic modeling, data quality, observability, CI/CD, Git, and version control practices
• Experience with APIs, automated file ingestion, and lightweight pipeline development.
• Experience supporting consumer goods, beauty, luxury, retail, sales, supply chain, or commercial analytics environments and/or working within a matrixed global organization

We welcome Creators Of All Kinds.

Compensation Data

As required by New York State’s salary transparency law, effective November 2022, the expected base salary for this position ranges from $110,000.00 - $120,000.00. Various factors are considered when extending offers, such as relevant skillset, training, years of experience related to the current job description, education, and our organizational structure. In addition to the base salary, PUIG offers a competitive benefits package that includes health and dental insurance, life insurance, disability insurance, 401K, paid holidays, a generous paid time‑off policy, hybrid work environment, and career opportunities within a dynamic team.

WHAT YOU’LL LOVE ABOUT US

• An entrepreneurial, creative and welcoming work culture
• A range of learning and development opportunities
• An international company with plenty of opportunities to grow
• A competitive compensation & benefits package

Puig is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status, or any other characteristic protected by law.

At Puig, we are continually looking for enthusiastic and committed individuals from a broad range of backgrounds and experiences to join our team. We believe that creating an inclusive environment in which you feel welcomed, valued, engaged, and empowered strengthens our business and fosters a culture where we are inspired to work hard, challenge ourselves, and be innovative in our thinking. Additionally, we believe that the diversity of our employees makes us a stronger company and better able to serve our customers around the world.

Puig 2024. This information is privileged, confidential and contains private information. Any reading, retention, distribution or copying of this communication by any person other than its intended recipient is prohibited.