Associate Power BI

Company description Publicis Re:Sources is at the core of Publicis Groupe, the world's largest communications company. 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 6,000+ employees in over 55 countries. We provide technology solutions and business services, including finance, accounting, legal, benefits, procurement, tax, real estate, treasury and risk management, information security, and global mobility — supporting 110,000+ employees across the Publicis Groupe network. Our people are at the center of everything we do, bringing curiosity, collaboration, and a commitment to excellence to their work every day. Learn more about Publicis Re:Sources and the Publicis Groupe agencies we support at publicisresources.com Overview Power BI & Azure Data Engineer responsible for designing, developing, and maintaining interactive dashboards and reports using Power BI, along with building robust data pipelines and data models using Azure Synapse, Azure Data Factory, and Fabric. The role involves working with structured and unstructured data, implementing advanced DAX calculations, ensuring data security, and delivering scalable data warehousing and analytics solutions aligned to business needs, preferably within Financial and Workforce domains. Responsibilities • Deep knowledge of Power BI and data visualization best practices. • Design, develop, test, and deploy Power BI Reports and work with client to generate and maintain visually appealing and insightful reports. • Create custom visualization and implement row level security on data. • Build data models and develop dashboards using Power BI desktop. • Develop tabular and multidimensional models that are compatible with warehouse standards. • Work with application developers to design and develop Power BI data visualizations. • Use advance level calculations on the data set using DAX functions in Power BI. • Test formulas and visualizations to ensure their functionality. • Preferred domain Financial and Workforce data. • Design, build, and optimize solutions using Azure Synapse Analytics and Azure Data Factory, fabric Pipelines and including data ingestion, transformation. • Develop and manage data pipelines using Azure Data Factory or Synapse Pipelines or fabric Pipelines for data movement and transformation. • Integrate structured and unstructured data from various sources into Azure Synapse Analytics. • Build and maintain data warehouses, data lakes, and analytics solutions using Azure Synapse Studio, SQL Data Warehouse, and Spark pools. Qualifications • Good hands-on experience on Power BI, SQL, Azure data factory, Azure synapse/ Fabric. • Experience with Azure Data Lake, Azure Blob Storage, and integrating various data formats (e.g., JSON, Parquet). • Strong proficiency in SQL, data modelling, and ETL/ELT process.