Senior PowerBI/ Azure Associate

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.

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.

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