Data Engineer & Quality Analytics Professional

Ankur Patel

New York, NY 917-***-**** *.*****.***@*****.*** LinkedIn GitHub Portfolio

Summary

Data engineer and analytics professional with extensive experience building scalable pipelines and data warehouses on cloud platforms. Delivered automated GCP BigQuery pipelines integrating multi-source retail data, reducing downtime and improving data quality; also designed Snowflake models and Tableau dashboards that accelerated underwriting decisions for an insurance firm. Skilled in Python, SQL, and modern orchestration tools such as Apache Airflow to enable reliable analytics. Seeking to apply this expertise to drive data-driven insights and operational efficiency in a forward-looking organization. Experience

Sky I.T. Group Jan 2024 - Jul 2026

Data Engineer NY

• Designed and maintained automated Python and SQL data pipelines orchestrated with Airflow on GCP BigQuery, integrating multi- source retail POS, sales, inventory, and product data into curated datasets for timely analytics and reporting for stakeholders.

• Developed Python parsing and transformation workflows that standardized heterogeneous client data into consistent schemas and business-defined grains, creating reusable data models for downstream analytics.

• Implemented automated data validation, reconciliation, and monitoring for production pipelines, improving data quality.

• Investigated production pipeline failures using logs and root-cause analysis, then added validation checks that reduced pipeline downtime and prevented recurring errors.

• Developed backend Python data-processing services supporting an LLM-powered analytics chatbot, providing trusted sales and inventory data for natural-language queries.

• Partnered with analysts and business stakeholders to translate reporting and analytical requirements into centralized data models and pipelines, delivering accessible data products that reduced report generation time and supported faster decision-making. Greater New York Insurance Companies Aug 2020 - Oct 2023 Data Analytics Engineer NY

• Designed and optimized end-to-end data pipelines and analytics-ready Snowflake datasets for insurance policy, claims, underwriting, violations, and geographic data, delivering trusted data for BI reporting, predictive analytics, and decision-making using Python, R, SQL, Snowflake, Tableau, and SQL Server; piloted dbt for Snowflake transformation layer to standardize.

• Improved data quality, consistency, and performance through validation, documentation, monitoring, and optimization of production data workflows.

• Partnered with business stakeholders to translate underwriting, claims, and pricing reporting needs into Tableau dashboards and Snowflake data models, enabling faster underwriting decisions and more accurate claims and pricing analysis.

• Collaborated with data scientists to prepare feature-engineered datasets to support predictive models using DataRobot, SparkBeyond, and internal machine learning that improved risk-scoring accuracy for underwriting. Executive Business Solutions Corp Oct 2018 - Mar 2020 Data Engineer NY

• Developed Python ETL pipelines that integrated external real-estate, U.S. Census, and public-health data via APIs into AWS-hosted SQL databases, enabling automated analytical reporting and reducing manual data-gathering effort.

• Designed and implemented sales and product data pipeline using Azure Data Factory, Databricks, and PySpark, ingesting multi-source sales data into a dimensional data model and implementing slowly changing dimensions.

• Designed a SQL Server data warehouse and data models for retail clients, building customer-segmentation, purchasing-analysis, and supply-chain KPI datasets that provided business leaders with actionable insights for strategic decision-making.

• Developed time-series forecasting and predictive-analytics models in Python (using pandas and scikit-learn) for financial and business datasets, delivering forecasts that supported budgeting and planning activities.

• Delivered hands-on training in Python, SQL, Tableau, R, Excel, data analytics, and machine learning to business users and staff, increasing their self-service reporting capabilities and adoption of analytical tools. Novo Nordisk Jun 2019 - Aug 2019

Forecasting & Business Analysis Intern NJ

• Processed pharmaceutical sales, demand, and product-volume data using Excel, SQL, and Python, creating standardized forecasting datasets that supported FP&A forecasting and business planning and enabled more accurate forecast inputs for the team.

• Developed Python ETL workflows to transform and map enterprise data from multiple databases into standardized inputs for forecasting models, reducing manual data preparation.

• Analyzed forecast data and built a Tableau Forecast Tracker to visualize Anchor Budget and Rolling Estimate forecasts, helping stakeholders monitor forecast performance and identify variances. Education

Saint Peter's University 2020

MS, Data Science

University of Alabama at Birmingham 2015

BS, Biomedical Engineering

Skills

• Python, SQL, R, PySpark, dbt, Tableau, Qlikview, Excel, Databricks, Data Modeling, Data Mapping, ETL/ELT, REST APIs, CI/CD, Data Warehousing (Snowflake / BigQuery / Redshift), Orchestration (Airflow / Azure Data Factory / ibi Data Migrator), Cloud Platforms (AWS / GCP / Azure), Predictive Analytics, LLM

Contact this candidate