Analytics Engineer - Power BI & Data Automation

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

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.