Lead - Data Engineering (Snowflake, dBT, AWS, Airflow)

About Us: At Tech Mahindra ( Tech Mahindra | Connected World, Connected Experiences ), we live the philosophy of connected world and connected experiences. We thrive on change that is powered by the intelligent symphony of technology and humans designing meaningful and sustainable experiences. Consumer ‘experiences’ are driving and disrupting industries like never before. Businesses must build seamless yet simple enterprises that collaborate, synergize, and drive the change. Change that connects us all and empowers us to deliver experiences that span across the digital, the physical, the convergent, and everything in between. That’s when truly connected experiences manifest. Extraordinary is when experiences come together – a continuous convergence of digital technologies, touchpoints, and most importantly people. It’s time to reimagine, reinvent, and revolutionize business models & operations as well as to transform enterprises into living, breathing, and connected businesses. We are the Digital Change makers who strive to change the way the world, communities, businesses, and humans interact digitally. We are harnessing the power of change, brought in by technologies, that makes it the most exciting time to be alive in human history. Our universe, as we build it, disrupts it, and redesigns it, is powering the digital change. Tech Mahindra represents the connected world, offering innovative and customer-centric information technology experiences, enabling Enterprises, Associates, and Society to Rise. It has 150,000 professionals working for 1000 Global Customers (including Fortune 500 companies) in 90 Countries. We’re part of the esteemed Mahindra group, headquartered in India. Under a new CEO, Tech Mahindra is committed to a transformative journey with 'Scale @ Speed' as our guiding principle. Mode: Hybrid (Mandatorily need to visit office 3 days a week) The pay range for this role is CAD 135,000 per annum - CAD 160,000 per annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience and location of the candidate. Sr. Data Engineering/ Lead - AWS, Cloud Technologies This role will be part of and a member of our Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, high level and low-level solution engineering design, analysis, and implementation in a successful and experienced team. You’ll be required to apply your depth of knowledge and expertise with both modern and legacy data platforms to develop data ecosystems that will meet business requirements and align with Client's enterprise architecture goals and standards. Client has embarked on an exciting journey to modernize, craft, and build a next generation data platform Snowflake to support the growing data needs of the business and to enable the capabilities of AI, and GenAI to drive business value. We embrace a culture challenging the status quo and constantly look to efficiently simplify processes, technology, and workflow. This role will be reporting into AVP, Data Engineering. What you'll do As a Senior Data Engineer Lead, you will be instrumental in shaping and delivering enterprise-scale data solutions. You’ll define the technical roadmap, drive data strategy, and lead the design and implementation of robust, scalable data pipelines. This role requires a strong blend of technical leadership, hands-on engineering, and cross-functional collaboration. Must Have skills: Snowflake dBT AWS Airflow Key Responsibilities Technical Leadership: Define and drive the data engineering strategy, standards, and best practices across the organization. Solution Design: Develop high-level and low-level solution architectures, ensuring alignment with business and technical goals. Data Pipeline Development : Lead the design and implementation of high-performance data pipelines using tools like dbt Core/Cloud, ensuring scalability and maintainability. Data Modeling: Design and review conceptual, logical, and physical data models to support business needs. Code Ownership : Write and maintain clean, reusable code in SQL, Python, Shell, and Terraform. Quality & Governance: Champion data quality, governance, and cataloging practices; create and review test plans to validate data solutions. Issue Resolution : Perform root cause analysis and implement effective solutions for complex data issues. Experience Needed: 10 years of professional experience delivering over 10 high-impact data projects from inception through warranty. 5 years of Snowflake, dbtCore/Cloud, and AWS Cloud Technologies. 7 years of experience with coding in multiple programming languages such as Python, Java, etc. Technical Expertise: Deep knowledge of relational databases (Snowflake, PostgreSQL, Amazon Aurora), big data platforms (Hadoop), and NoSQL databases (e.g., MongoDB). Data Visualization Proficiency: Skilled in tools such as Snowsight, Streamlit, Qlik, and SAP BusinessObjects to communicate insights effectively. Advanced Coding Skills: Expert-level proficiency in SQL, Python, Shell, and Terraform, with a strong focus on performance, reusability, and maintainability. Presentation & Communication: Strong technical and business presentation skills; able to identify and address gaps in data designs and processes with both internal and external stakeholders. Pipeline & Orchestration Tools: Hands-on experience with orchestration tools like Zena and AWS Managed Airflow. Resilience & Adaptability: Proven ability to thrive in fast-paced, ambiguous, and high-pressure environments. Mentorship & Leadership: A track record of mentoring Data Engineers at all levels, fostering a culture of engineering excellence and continuous improvement. Customer-Centric Mindset: Passion for solving real-world problems using data-driven insights to deliver impactful business outcomes. Collaborative Approach: Strong interpersonal and communication skills, with the ability to lead teams and influence cross-functional stakeholders. Domain Knowledge: Familiarity with insurance industry processes and systems is a strong asset. AI/ML & GenAI Exposure: Experience in operationalizing AI/ML & GenAI models is a plus. Preferred Certifications (having 2 or more is an asset): SnowPRO Core, SnowPRO Advanced Data Engineer (DEA-C01, DEA-C02), SnowPro® Advanced: Architect (ARA-C01), dbt Developer, AWS Cloud Practitioner Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin, or disability. All applicants will be evaluated solely based on their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodation also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at ADA_Accomodations@TechMahindra.com.

Location: Markham, Ontario, CA

Posted Date: 11/4/2025