Senior PowerBI/ Azure Associate

Company Description

Publicis Re:Sources is the backbone of Publicis Groupe, the world’s most valuable agency group. We are the only full-service, end-to-end shared service organization in the industry, enabling Groupe agencies to do what they do best: innovate and transform for their clients.

Formed in 1998 as a small team to service a few Publicis Groupe firms, Publicis Re:Sources has grown to 5,000 employees in over 66 countries. We provide technology solutions and business services including finance, accounting, legal, benefits, procurement, tax, real estate, treasury and risk management.

We continually transform to keep pace with our ever-changing communications industry and thrive on a spirit of innovation felt around the globe. Learn more about Publicis Re:Sources and the Publicis Groupe agencies we support at http://www.publicisresources.com/.

The Publicis Re:Sources Guiding Principles define who we are and what we stand for. They reflect the mindset and behaviors that shape how we work, how we support one another, and how we drive progress together.

• People First, Driving Success Together
• Problem Solving Mindset
• Respect Each Other
• Partner and Collaborate as One Team
• Commit to Quality and Standards
• Innovate and Embrace the Future

Work Authorization

Applicants must be legally authorized to work in the United States without the need for current or future visa sponsorship. We do not provide sponsorship for any type of visa.

Overview

Publicis Re:Sources is seeking an experienced Senior Data Analyst with 10-15 years of work experience to join our IT Business Intelligence & Analytics team. The ideal candidate will have extensive experience with Power BI, Azure Data Factory or Synapse Pipelines solutions and eco-system. The Senior Technical person will play a critical role in analyzing business requirements, designing and implementing solutions, and providing insights to drive business decisions. It will also include engaging with Finance & other domain users and owners, and collaborate with the rest of the IT team to deliver business insights leveraging available Analytics tools including Power BI for a global multinational organization.

Responsibilities

Data Integration & ETL

• Develop and maintain data pipelines using Azure Data Factory (ADF) or Synapse for ingesting, transforming, and loading data from multiple sources.
• Implement data orchestration, parameterized pipelines, and monitoring for reliability and performance.

Data Modeling & Warehousing

• Design and optimize data models in Azure Synapse Analytics or Azure Databricks to support analytics and reporting.
• Work on star schema, data lakehouse structures, and performance tuning for large datasets.
• Collaborate with data architects to maintain data governance and security standards.

Reporting & Visualization

• Develop interactive Power BI dashboards and reports that translate complex data into actionable insights.
• Build and manage Power BI datasets, measures (DAX), and row-level security (RLS).
• Work closely with business stakeholders to understand reporting needs and deliver user-friendly solutions.

Optimization & Automation

• Monitor data workflows for performance and cost efficiency.
• Implement automation for recurring processes and ensure high data quality.

Collaboration & Documentation

• Collaborate with cross-functional teams (Data Engineers, Analysts, Business Users).
• Maintain clear technical documentation for pipelines, models, and dashboards.

Qualifications

• Bachelor's degree in IT or related field.
• 6-10 years of hands-on experience in data development and analytics.
• Strong expertise in:
• Microsoft Power BI (DAX, Power Query, data modeling, and visualization).
• Azure Synapse Analytics (SQL, dedicated SQL pools, serverless queries).
• Azure Data Factory (pipelines, linked services, dataflows).
• Solid understanding of SQL, data warehousing principles, and ETL concepts.
• Experience with Azure Data Lake, Azure Blob Storage, or similar cloud storage systems.
• Strong analytical and problem-solving skills.
• Ability to work in an agile, fast-paced environment.

Additional Information

All your information will be kept confidential according to EEO guidelines.

This job description in no way states or implies that these are the only duties to be performed by the employee(s) currently in this position. Employee(s) will be required to follow any other job related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments.

A review of this position has excluded the marginal functions of the position that are incidental to the performance of fundamental job duties. All duties and responsibilities are essential job functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this job successfully, the incumbent(s) will possess the skills, aptitudes, and abilities to perform each duty proficiently. Some requirements may exclude individuals who pose a direct threat or significant risk to the health or safety of themselves or others. The requirements listed in this document are the minimum levels of knowledge, skills, or abilities.

This document does not create an employment contract, implied or otherwise, other than an ""at-will"" relations.