Mithilesh Tiwari

Experienced Data Engineering Manager with 15 years of expertise in designing, building, and optimizing scalable data solutions, architectures, and pipelines within the Azure ecosystem. Proven ability to lead high-performing teams, drive digital transformation, and implement data security, governance and metadata strategies. Strong communicator with excellent presentation skills and a track record of collaborating with stakeholders to align data strategies and data products with business value. Adept at solution design, leveraging analytics, AI, and data science techniques to translate complex technical concepts into actionable insights. Committed to continuous learning, reliability and fostering a culture of innovation, creativity and knowledge sharing, while maintaining a flexible approach to evolving technologies and business priorities.

PROFESSIONAL EXPERIENCE

Manager, Data Engineer, IT, Four Seasons Hotels & Resorts, Toronto, ON                            Sep 2022 – Present

• Led a team of ten data engineers, providing mentorship, fostering collaboration, and ensuring high standards of data quality and performance in the delivery of data engineering projects, while also managing daily operations to minimize downtime and meet critical deadlines
• Planned and led the delivery of enterprise-wide data analytics solutions by aligning stakeholders, guiding cross-functional teams, and establishing best practices in information management using Microsoft Azure & Fabric
• Spearheaded data migration to Azure Data Lake Gen 2 by establishing governance frameworks, adopting Agile methodology, collaborating with cross-functional delivery teams and integrating master data management (MDM) best practices to improve data consistency
• Optimized data storage in Azure Synapse (Dedicated SQL Pool), and Data Lake, improving query performance, data retrieval speed, and reducing storage costs by 20% through improved data management practices, lifecycle policies, and cost-efficient configurations
• Developed and maintained scalable pipelines using Azure Data factory and Databricks (Unity enabled), automating ETL processes, implementing incremental load strategies, and streamlining data workflows to reduce manual effort by 40% and improve data processing times by 35%
• Implemented Agile development practices across engineering teams by implementing sprint planning, backlog refinement, CI/CD pipelines through Azure DevOps (Git), resulting in improved delivery speed and quality
• Collaborated with stakeholders, data scientists and analysts to transform business needs into technical solutions, demonstrating strong analytical skills and problem-solving skills ensure clean, well-organized data in Azure Synapse and Data Lake, reducing data preparation time by 30% and improving reporting performance for business stakeholders
• Developed secure and scalable solutions with access control and data protection mechanisms, ensuring compliance with data privacy and IT security policies across cloud infrastructure
• Automated business processes using Power Platform (Power Apps, Power Automate, and Dataverse), creating custom apps for data management, automating workflows, and improving reporting accuracy and efficiency
• Designed and optimized data marts for departmental reporting, enhancing performance for financial products and executive decision-making
• Enhanced self-service data visualization and reporting capabilities by providing PowerBI (DIAD), Power Apps, and Power Automate training to colleagues, empowering teams to perform advanced analytics, generate insightful data products, resulting in increased efficiency and driving business value across teams
• Integrated AI/ML models for anomaly detection and alerting within Azure Data Factory pipelines, improving decision making during data incident response
• Fostered a culture of ideation, coaching and professional development, guiding junior engineers through hands-on mentorship and promoting innovative approaches in Azure-based solutions
• Partnered across departments to identify opportunities for process improvement and implemented solutions that supported strategic insight and data-driven decision-making

Manager, Data Engineer, Credit Cards and Insurance, Scotiabank, Toronto, ON               May 2016 – Aug 2022

• Designed and communicated a clear vision and strategy for Credit Card Data Products by creating roadmaps, facilitating stakeholder engagement and aligning with organization strategic goals to transform 7M Credit Card data into actionable insights through data visualization dashboard, empowering business teams drive business value
• Built Dimensional data Model & Performed data analysis, extracted, created, and maintained large, complex Insurance Data Models to estimate the premium earnings to proactively understand and action customer retention and lapses
• Resolved issues with Mastercard and Visa’s quarterly reporting processes, increasing team efficiency and saving $80K USD, showcasing technical skills and strong problem-solving skills
• Used presentation skills to deliver data-driven proposals and updates to executive stakeholders, enhancing alignment on key business strategy initiatives
• Led multi-million dollar projects, applying project management and product management methodologies to ensure on-time and within-budget delivery of scalable data solutions
• Applied Business Analytics to improveand streamline a Business Process ensuring better alignment with business strategy to manage Closed accountsand saved approximately 400K USD
• Executed Partial Authorization application, increasing PaymentsVolume Interchange Fee revenue by 6M USD y/y
• Negotiated project scopes and timelines, maintaining strong business administration and vendor relationship skills

Senior Business AnalystCredit Cards, American Express, Kingdom of Bahrain                 July 2010 – Feb 2016

• Played a key role in production support by diagnosing issues, conducting testing of fixes, and implementing solutions to ensure seamless system performance and minimize operational disruptions
• Led multiple testing and implementation initiatives for Issuing and Acquiring platforms, demonstrating strong verbal and written communication skills while bridging technical and business teams
• Designed Automation Test scripts and improved regression testing cycles for web applications, showcasing attention to detail, technical skills and process reliability saving 8 Man-Days effort with every regression testing requirement

TECHNICAL EXPERTISE

• Cloud & Data Engineering: Azure Data Factory, Azure Synapse, Azure Data Lake, Databricks, Azure DevOps, Networking
• Programming & Analytics: Python, PySpark, T-SQL, Spark
• Security & Compliance: RBAC, Azure AD and Azure security principles, Access Control, Data Protection, Data Privacy
• Data Visualization: PowerBI, Tabular Editor
• Soft Skills: Presentation Skills, Verbal/Written Communication, Decision Making, Coaching, Ideation, Leadership

EDUCATION

Masters in Management Analytics, Smith School of Business, ON  Jan 2021 – Jan 2022 

Bachelors degree in Engineering – Computer Science, Anna University, Tamil Nadu, India                             June 2006 – May 2010

Masters in Management analytics, Queens University, Kingston, Canada