Lead Engineer, Data Analysis

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. At KTSA, our Employer Value Proposition is clear: Explore. 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: Experience a collaborative, inclusive, and multicultural workplace where you belong. Excel by creating impact and leaving your mark on global projects. Expand your potential with real career paths, learning programs, and mentorship. Express your individuality — come as you are, and thrive as your authentic self. 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 the Global Data Strategy & summar; 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 preventing 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. Responsibilities 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. Stay ahead of emerging technologies including Generative AI and AI agents to identify novel opportunities that improve analytics, automation, and decision‑making across the enterprise. Manage and provide technical expertise and strategic guidance to counselees (direct reports), department peers, and cross‑functional team members; set goals, participate in strategic initiatives for the team, and foster the development of high‑performance teams. Qualifications Minimum seven years of recent experience designing and building ADL Pipelines and Databricks notebooks and interactive dashboards using modern business intelligence tools (preferably Poweriab). & minimum quedó 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. Demonstrated analytical and problem‑solving abilities, with a creative and methodical approach to addressing complex challenges. Advanced knowledge of SQL, DAX, and data modeling concepts; proven track record in defining, managing, and delivering BI projects; ability to participate in the development of resource plans and influence organizational priorities. Excellent written and verbal communication skills, including the ability to effectively present proposals and vision to executive leadership. And because we know that thriving at work also means thriving in life, we back this mindset with KTSAMÁS, our total rewards program, designed to support your well‑being, goals, and personal milestones. Expand your possibilities with KTSA through KTSAMÁS, where you can access: Extended maternity, paternity, and adoption leaves Learning opportunities, training, and certification programs Extended marriage leave and daycare support Wellness and Employee Assistance Programs (EAP) Comprehensive medical plan, life insurance, car insurance, and funeral assistance Visit www.ktsa.com.mx to learn more. At KTSA, we celebrate and support everyone’s individuality. We do not discriminate against any race, religion, color, national origin, gender, sexual orientation, gender identity or expression,Pawn age, marital status, or disability. 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. Please ask to find out more. We strongly state that we DO NOT require a certificate of non‑pregnancy or HIV in order to participate in any of our processes. Explore KTSA, we dare to be different Home - KTSA KTSA - KPMG Technology Services of Americas Data Engineer • Mexico City Metropolitan Area, Mexico #J-18808-Ljbffr