Available to hire
I’m Ankesh Jain, a Senior Data Engineer who loves turning complex data into clear, actionable insights. I build scalable analytics pipelines, dashboards, and automated workflows for global clients, with a strong focus on data quality, validation, and efficient data modeling. I enjoy collaborating with cross-functional teams to deliver measurable impact and help organizations make better decisions through data-driven practices.
Outside work, I’m passionate about continuous learning and mentoring, and I strive to create maintainable data platforms that empower colleagues and stakeholders to act with confidence and speed.
Skills
Language
English
Advanced
Hindi
Fluent
Work Experience
Senior Data Engineer at McKinsey & Company
January 1, 2024 - PresentOptimized database quality standards through regular data validation and cleansing. Facilitated team meetings to review progress, challenges, and database management strategies. Developed custom ETL scripts in Python and SQL for data extraction, transformation, and loading. Designed robust validation frameworks to improve survey and reporting accuracy. Integrated advanced AI workflows to accelerate technology adoption across projects.
Senior Data Analyst at McKinsey & Company
January 1, 2022 - December 31, 2023Analyzed large datasets to uncover trends, anomalies, and opportunities for business improvement. Designed dashboards and reports for non-technical stakeholders using modern BI tools. Led automation initiatives supporting multiple client engagements annually. Developed scalable analytics infrastructure, including automated workflows and dashboards. Migrated legacy workflows to Python, reducing turnaround time and licensing cost.
Power BI Consultant at McKinsey & Company
May 1, 2020 - December 31, 2021Extracted data from enterprise databases using SQL to support business strategy decisions. Documented BI processes and best practices to build a reusable knowledge base. Analyzed large datasets with SQL and Python to deliver actionable insights. Developed Alteryx workflows to streamline data processing. Created Tableau and Domo dashboards for data visualization and querying.
Power BI Consultant at McKinsey & Company
November 1, 2018 - May 31, 2020Built data validation frameworks to ensure accurate survey data processing. Delivered predictive analytics and clustering models for enhanced segmentation. Developed customized Power BI dashboards to present actionable insights. Integrated AI workflows to support technology adoption across teams.
Power BI Consultant at CloserLook Digital Software Pvt. Ltd.
October 1, 2017 - September 30, 2018Developed ETL packages and T-SQL scripts to improve data processing efficiency. Generated Power BI reports and dashboards to visualize key metrics. Created custom dashboards using Google Charts for tailored data views. Formulated LINQ queries and analyzed design documents to meet client requirements.
Associate Software Engineer at Imbibe Technologies Pvt. Ltd.
February 1, 2017 - August 31, 2017Developed ETL packages and T-SQL scripts to enhance data processing. Supported BI projects for US clients using SSIS and .NET technologies. Created interactive Power BI dashboards for key business metrics. Logged tasks, issues, and bugs in Visual Studio Online to support project tracking.
Assistant Software Engineer at MAQ Software
May 1, 2016 - December 31, 2016Developed Power BI dashboards to enhance data visualization and reporting. Implemented Power BI Gateway for seamless online data access. Analyzed design documents to accommodate new reporting requirements. Extracted data from upstream sources and loaded it into SQL databases. Tracked project tasks and issues in Visual Studio Online to maintain transparency. Created ETL packages to integrate data from diverse sources. Designed stored procedures to support advanced reporting needs.
Education
Bachelor of Engineering at B.E. JNCT Bhopal
January 1, 2015 - January 10, 2026Class XII at Saroj Convent H.S. School
January 11, 2030 - January 1, 2011Class X at Creative Convent H.S. School
January 11, 2030 - January 1, 2009Bachelor of Engineering (B.E.) at JNCT Bhopal
January 1, 2015 - January 10, 2026Class XII at Saroj Convent H.S. School
January 11, 2030 - January 1, 2011Class X at Creative Convent H.S. School
January 11, 2030 - January 1, 2009Bachelor of Engineering (B.E.) at JNCT Bhopal
January 11, 2030 - January 10, 2026Qualifications
DAT207x: Analyzing and Visualizing Data with Power BI
January 11, 2030 - January 10, 2026Microsoft – DAT207x: Analyzing and Visualizing Data with Power BI
January 11, 2030 - January 10, 2026DAT207x: Analyzing and Visualizing Data with Power BI
January 11, 2030 - January 10, 2026Industry Experience
Professional Services, Software & Internet, Media & Entertainment, Education
Skills
Hire a Data Visualizer
We have the best data visualizer experts on Twine. Hire a data visualizer in New Delhi today.