Analytics Engineer - Power BI, SQL & Automation

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

Job summary

Puig USA is seeking an Analytics Engineer to build and maintain analytical datasets, semantic models, and Power BI solutions to enable better decision-making across the organization.

The role combines strong technical data engineering with collaboration across regional and global teams, focusing on data ingestion, quality, and scalable analytics products in a fast-paced environment. Hybrid work is available in the U.S.

Qualifications

• 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

Responsibilities

• 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
• 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
• 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
• 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

Skills

SQL

Python

Stakeholder management

Communication

Analytical mindset

Problem solving

Fast-paced adaptability

Education

Bachelor's degree in CS/IS/Analytics/Engineering/Math

Tools

Power BI

dbt

Git

CI/CD

BigQuery

Databricks

Snowflake

Redshift

Azure Synapse

Job description

Puig USA is seeking an Analytics Engineer to build and maintain analytical datasets, semantic models, and Power BI solutions to enable better decision-making across the organization.

The role combines strong technical data engineering with collaboration across regional and global teams, focusing on data ingestion, quality, and scalable analytics products in a fast-paced environment. Hybrid work is available in the U.S.