Data & Tech Lead

Location: San Lorenzo Tenochtitlán

About KTSA  We are KTSA – KPMG Technology Services Americas.

A Service Delivery Center of KPMG US, with offices in Mexico City, Guadalajara, and a growing network of remote talent across the country. We deliver high-value technology, consulting, and corporate support services to KPMG US and its clients.

Explore isn’t just a word — it’s how we grow, lead, and thrive. It’s the mindset that drives our culture and shapes every opportunity:
Excel  by creating impact and leaving your mark on global projects.
The Manager, Data Analysis is responsible for ensuring accuracy and quality in data and presenting data in such ways that assists with the decision-making process. This role is part of Global Data Strategy & Operations team and responsible for data onboarding, data analysis, data validation. You will be working closely with the development team and data consumers on delivering data related projects as well as providing operational support.

The successful candidate will be a subject matter expert in Data, and work with stakeholders to develop and solution business and technical requirements.

Lead a team of Azure Data Lake & business intelligence engineers in designing and delivering ADL Pipelines, Notebooks and interactive Power BI dashboards that clearly communicate actionable insights to stakeholders; contribute strategic thought leadership to shape the firm’s business intelligence vision and standards.

• Design and maintain scalable data pipelines using Azure Data Factory and Databricks to ingest, transform, and deliver data across medallion architecture layers; develop production-grade ETL/ELT solutions using PySpark and SQL to produce analytics-ready Delta Lake datasets aligned with enterprise standards.

• Apply critical thinking and creativity to design innovative, non-standard BI solutions that address complex and evolving business challenges; design, build, and optimize data models to support analytics, ensuring accuracy, reliability, and efficiency

• set goals, participate in strategic initiatives for the team, and foster the development of high-performance teams.

Minimum seven years of recent experience Designing and building ADL Pipelines and Data bricks notebooks and interactive dashboards using modern business intelligence tools (preferably Power BI); minimum two years of recent experience designing scalable data pipelines using Azure Data Factory and Azure Databricks to support ingestion, transformation, and delivery of data across medallion architecture layers

• Bachelor’s degree from an accredited college or university is preferred

• Advanced knowledge of SQL, DAX, and data modeling concepts; proven track record in defining, managing, and delivering BI projects;
Hybrid work model
Learning opportunities, training, and certification programs
Comprehensive medical plan, life insurance, car insurance, and funeral assistance
We are supportive of helping you to achieve a balance between your home and work demands. We are happy to discuss specific requirements and our range of flexible working arrangements could be of interest. KTSA - KPMG Technology Services of Americas