Varun Tyagi

Results-driven and visionary leader with over 15 years of experience in designing and establishing solution architecture for analytical platforms and data-enabled solutions. Proven track record of driving Business Transformation initiatives through data-driven strategies. Skilled in collaborating across organization’s leaders, business units and IT teams to align modern data solutions with their strategy, showcasing strong interpersonal skills.

SKILLS: Data Architecture, Big Data Management, Data Governance, Data Engineering, Business Intelligence and Data Visualization, Agile Sprint Planning. Expertise in:
- Designing Data Platforms - Azure ADF/Synapse/SQL/PowerBI, Azure DevOps, Databricks, Snowflake, Matillion, AWS, Apache Spark, Python, Tableau, Qlik Sense, ERwin data Modeler
- Designing and implementing Data Lakehouses, modern cloud data warehouses and data products
- Managing and developing data engineering and analytics teams
- Driving operational excellence through the development and execution of project plans and roadmaps
- Fostering collaboration, Program Management and Stakeholder Management
- Conducting requirement workshops and leading design review sessions

Data and Analytics Director                                           Jul 2024 - Present

NTT Data | Seattle

• Designed and implemented Data Lakehouse solution and analytical data products for a leading US-based beverage company.
• Led the delivery of data products, creating a roadmap and aligning with OKRs to drive data strategy and business intelligence initiatives for impactful results.
• Partnered with stakeholders to prioritize key problems, aligning OKRs and KPIs to drive impactful insights and strategic decisions, leveraging strong business acumen.
• Directed a team of 9 data engineers and data analysts to integrate marketing data from multiple third-party vendors into a unified Azure Synapse Lakehouse data platform.
• Championed the harmonization of source data across multiple systems aligning disparate data definitions with organization's business dictionary.
• Developed centralized data models and Power BI reports to enhance demographic insights into the market, leveraging data analysis while ensuring data governance and compliance.
• Designed data architectures and frameworks, ensuring metadata management, data quality, and governance, while contributing to data strategy development.

Data and Analytics Principal                                       Sep 2021 - Jul 2024

Slalom Consulting | Houston

• Managed a Crude oil inventory project for a large US-based Oil company. Enabled client to tap into 3rd party (20+) vendors' data, thereby enhancing business decision-making capabilities in fields such as Book to Physical and Pricing Optimization. Improved productivity by saving 3000 hours per year.
• Led conversations with client's third-party vendor IT Directors and CTOs to secure Rest API access approvals and data transfer to client's cloud data platform.
• Utilized data presentation skills to effectively communicate complex technical concepts during stakeholder readouts, gaining buy-in for data analytics initiatives.
• Led design reviews and provided mentorship to 6 Data Engineers in designing, developing, and deploying a data warehousing solution using ADF, Databricks, and Azure Synapse.
• Created Agile Scrum board in Azure DevOps and established an operating model for the analytics team that clarified daily tasks and responsibilities committed to Agile Sprint goals.
• Led data strategy development by creating implementation roadmaps, delivery timelines, and guiding staffing decisions to drive operational excellence.
• Set data engineering standards, including design docs, ETL, performance tuning, DevOps, and cloud security, inspiring the team to create reusable, cost-effective solutions.
• Collaborated with business teams to understand their requirements, providing clean data from a centralized lake to drive impactful business solutions.
• Designed and implemented Lakehouse solutions by leveraging Databricks' data engineering functionalities such as Unity Catalog, Delta tables, SQL, and PySpark.
• Directed the data visualization team to leverage data models and data analysis to create impactful visualizations in Power BI, driving actionable insights.
• Directed a Customer 360 MDM application for a US-based CPG client, migrating legacy systems to Snowflake cloud, boosting employee productivity by 10% and saving $6M annually.
• Collaborated with Enterprise Architects and Product Managers on best practices for cost savings, security, scalability, and budgeting for Matillion on AWS and Snowflake.
• Led Slalom's Data & Analytics Learning Committee, conducting boot camps and mentoring 14 practitioners in Microsoft Azure and AWS, enhancing data engineering skills.

Manager, Strategy and Data Analytics                      Nov 2013 - Nov 2020

Deloitte Consulting LLP | Houston

• Spearheaded data governance and business intelligence project for Australia-based leading Telecommunication company. Supported business in Location/address remediation as part of infrastructure migration from Copper to Fiber reducing errors by 80%.
• Managed data analytics projects for leading US-based Life Sciences client. Including projects such as Market share analytics, financial analysis, and product trends analytics.
• Led advanced analytics projects for leading US-based Insurance client. Including use cases such as Telematics, Financial analysis and Claims analytics.
• Led workshops with business stakeholders to gather product requirements, using technical expertise to prioritize features and align data analytics projects with strategic goals. 
• Established data architectural designs and BI best practices, standards and data models, recommended data warehouse and reporting performance tuning techniques. 
• Led onsite and offshore data analytics teams of 15+, fostering innovation and using leadership skills to improve accountability, solution reliability, and project schedule adherence. 
• Created batch and streaming data load strategies for data sourced from Kafka topics, empowering seamless self-service business intelligence on enterprise data lakes.
• Designed optimized big data processing pipelines to load large sets of structured and semi-structured data using PySpark, Spark SQL, Spark Streaming. 
• Designed and implemented effective big data and business intelligence solutions with Snowflake cloud data warehouse and Power BI.
• Collaborated with product owners and architects to create proofs of concept using design patterns and system architecture and conducted demos. 
• Led Cloud COE and conducted evaluations, recommending AWS / Azure data services for data integration, data storage, data analysis, and visualization, empowering informed decision-making. 
• Cutover Release manager for big data analytics implementation which is the largest undergoing digital transformation project for leading technology organization in US. 
• Collaborated with client IT and business counterparts to successfully deliver multiple parallel releases impacting 33% of Client's revenue, with 10K end users across 120 countries. 
• Aligned IT and Business release plans, monitored risks, provided leadership updates, and transitioned to Hypercare/operations, integrating incident management protocols for swift issue resolution post-release.

Business Analyst / Technical Lead                            Apr 2011 - Oct 2013

Tata Consultancy Services | India

• Led the Business Intelligence team in a large-scale financial analysis project for leading UK-based bank. Architected a reporting platform to assist Relationship Managers (RMs) in tracking credit application process. Improved productivity of 200+ RMs by 30%. 
• Leveraged Computer Science principles and SDLC methodologies to effectively manage and execute projects, created project plans, UAT plan, Deployment execution plans.
• Resolved data quality issues using problem-solving skills and technical expertise.
• Analyzed source data to understand various trends and scenarios and formulate an ETL design. 
• Created Physical Design Models by leveraging Erwin data modeler tool.

ETL Developer                                                           Nov 2008 - Apr 2011

Infosys Ltd. | India

• Developed a reporting solution for a large US-based rental car company, enhancing business economics and decision-making in tracking online subscriptions and marketing campaigns.
• Developed ETL high- & low-level design and data models for transforming data.

Core Skills 

Data Architecture, Big Data Management, Data Governance, Data Engineering, Data Modeling, Data Visualization, Business Intelligence, Agile Sprint Planning, Project Management, Stakeholder Management, Azure ADF, Azure Synapse, Azure SQL DB, Power BI, Tableau, Azure DevOps, Databricks, Snowflake, Matillion, AWS, Apache Spark, Python, Qlik Sense, ERwin data Modeler, Cloud data warehouses, Data quality, CI/CD

Bachelor of Technology (B.Tech.) - Instrumentation and Control Engineering              Jul 2004 - May 2008

Dr. MGR Educational & Research Institute, Chennai, India