Senior Data Analyst: End-to-End BI & Analytics Lead

Publicis Global Delivery (PGD); Bogotá; On-site; COP 100,000,000 - 150,000,000; Full time

Job summary

Publicis Global Delivery (PGD) is seeking a Senior Data Analyst to design, develop, and govern advanced analytics solutions that transform complex operational data into reliable insights for scalable decision support.

You will own the end-to-end analytics lifecycle—from requirements discovery and source assessment to data preparation, modelling, visualization and deployment—collaborating with Operations, Finance, HR, Talent and Technology teams.

Qualifications

• 5+ years in data analysis, BI reporting, or related analytics roles.
• Advanced Power BI: modelling, DAX, Power Query, performance optimisation, security, and governance.
• Advanced SQL: complex joins, CTEs, window funcs, aggregations, subqueries, and data-quality validation.
• Experience integrating and reconciling multiple data sources and building repeatable transformation processes.
• Strong ETL/ELT, KPI design, data quality, metadata, lineage, testing, and documentation.
• Advanced Excel, including complex formulas, Power Query, data modelling, and analytical validation.
• Experience managing requirements, solution testing, release documentation, and stakeholder acceptance.
• English B2+; C1 preferred for regional and global collaboration.

Responsibilities

• Own end-to-end analytics lifecycle—from requirements discovery through deployment.
• Define KPIs and improve data reliability and reporting standards.
• Partner with Operations, Finance, HR, Talent, Technology and other stakeholders to enable data-driven decisions.
• Provide technical guidance to analysts and establish development standards.

Skills

BI analytics

Power BI

Advanced SQL

ETL/ELT

Data modelling

KPI design

Data quality

Excel advanced

Requirements mgmt

English B2+

Tools

Azure

Snowflake

BigQuery

Databricks

JSON

Git

CI/CD

Job description

Publicis Global Delivery (PGD) is seeking a Senior Data Analyst to design, develop, and govern advanced analytics solutions that transform complex operational data into reliable insights for scalable decision support.

You will own the end-to-end analytics lifecycle—from requirements discovery and source assessment to data preparation, modelling, visualization and deployment—collaborating with Operations, Finance, HR, Talent and Technology teams.