Lead engineer, data analysis

About KTSAWe 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:Experiencea collaborative, inclusive, and multicultural workplace where you belong.Excelby creating impact and leaving your mark on global projects.Expandyour potential with real career paths, learning programs, and mentorship.Expressyour 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 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.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 Py Spark 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 efficiencyStay ahead of emerging technologies including Generative AI and AI agents to identify novel opportunities that improve analytics, automation, and decision-making across the enterpriseManage 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 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 layersBachelor's degree from an accredited college or university is preferredDemonstrated analytical and problem-solving abilities, with a creative and methodical approach to addressing complex challengesAdvanced 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 prioritiesExcellent 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 withKTSAMÁ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 leavesAbove-market vacation benefitsHybrid work modelLearning opportunities, training, and certification programsExtended marriage leave and daycare supportWellness and Employee Assistance Programs (EAP)Comprehensive medical plan, life insurance, car insurance, and funeral assistanceVisit 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, 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.