Prateek Kaushik

Data Engineer II @ Dakota Analytics Inc.

About

I am a Data Engineer II with proven expertise in building scalable, production-ready data platforms across cloud environments, specializing in Azure Databricks, PySpark, SQL, and modern ELT frameworks. Currently, I work at Dakota Analytics, where I design and deliver end-to-end data solutions for oil & gas clients, including Medallion Lakehouse architectures (Bronze–Silver–Gold), real-time and batch ETL/ELT pipelines, automated workflows, CI/CD integrations, and governed analytics using Unity Catalog. My work spans data ingestion, transformation, orchestration, and delivery—ensuring reliable, analytics-ready datasets for business and operational reporting. I specialize in: - Azure Databricks & Spark (PySpark) for large-scale data processing - dbt for analytics engineering (models, tests, seeds, CI/CD-ready transformations) - Delta Live Pipelines (DLT) for automated, near-real-time data flows - Terraform & GitHub Actions for infrastructure-as-code and deployment automation - Python, SQL, T-SQL for data transformation, validation, and optimization Beyond core data engineering, I’ve built Streamlit applications backed by Databricks and Azure services to support real-time data audits, AFE/LOS analysis, and decision support. I’m comfortable collaborating with both technical and non-technical stakeholders, translating business requirements into scalable data solutions. I hold a Master’s in Data Science & Analytics (GPA 4.0/4.0) from the University of Calgary, am a Databricks Certified Data Engineer Associate, and an AWS Hackathon winner. I’ve worked across Azure, AWS, and GCP, with a strong preference for building clean, testable, and maintainable data systems. I’m interested in roles where I can continue solving complex data problems, improving data reliability, and building platforms that teams actually trust and use. Let’s connect.

Country

City

Canada

Industry

Information Technology & Services

Skill

Data Warehousing, Coding Experience, AWS SageMaker, Amazon Redshift, Data Pipelines, Extract, Transform, Load (ETL), Marketing, AMPscript, Salesforce.com, Business Strategy, Customer Relationship Management (CRM), Salesforce Marketing Cloud, NoSQL, Databases, Workflow Optimization, Django, Visual Studio, Microsoft Power Query, Virtual Machines, Microsoft Power Platform

Experience

Data Engineer II

Dakota Analytics Inc.

2025-9 - Present · 1 yr 1 mo

Calgary, Alberta, Canada

Data Engineer

Dakota Analytics Inc.

2025-2 - Present · 1 yr 8 mos

Calgary, Alberta, Canada

Data Analytics Developer

Dakota Analytics Inc.

2024-8 - 2025-2 · 7 mos

Calgary, Alberta, Canada

Data Analytics Developer Intern

Dakota Analytics Inc.

2024-6 - 2024-8 · 3 mos

Calgary, Alberta, Canada

Mobile & Smart Living Advisor

Best Buy

2023-10 - 2024-1 · 4 mos

Calgary, Alberta, Canada

Engaging with customers, understanding their specific needs, and providing expert-level product recommendations. Utilize my tech mastery to assist customers in setting up and troubleshooting cutting-edge devices, ensuring a seamless tech experience. Stay at the forefront of the ever-evolving mobile and smart living tech landscape, offering insights on the latest gadgets and tech innovations. Drive tech sales and revenue by aligning customers with tech solutions that enhance their digital lifestyles. Enhance customer satisfaction through tech-savvy service, promptly resolving tech-related issues and fostering customer loyalty.

Software Development Engineer

Eshopbox

2020-9 - 2023-5 · 2 yrs 9 mos

Gurugram, Haryana, India

1. Built 5+ integrations using REST API, Microservices, Python, Java, SQL, Postman, GCP and Amazon Web Services namely known as Amazon Prime, Shopify etc. 2. Led a team of 5 Software Developers, overseeing efficient Agile methodologies and allowing them to build standalone JAR files to run without external web servers. 3. Designed, implemented, and managed 5+ marketplace integrations, including Razorpay Payment Platform, Amazon Prime, EasyShip, SelfShip, Flipkart, Ajio, and TataCliq Luxury serving 100+ merchants. 4. Using Jira and Atlassian Software for Projects and tasks management. 5. Developed Java and Python scripts to efficiently store 1000+ incoming customer orders and purchase history of various SKUs in a GCloud BigQuery data lake. 6. Successfully onboarded 50+ brands on the Shopify platform by developing custom apps and public apps.

Research and Management Volunteer

StripSexism

2020-8 - 2020-9 · 2 mos

Gurugram, Haryana, India

StripSexism led by the energetic youth to strikeout sexism from the society through organizing events such as Workshops and Seminars at various places including Schools.

Content Writer Volunteer

Hara Jeevan

2020-7 - 2020-9 · 3 mos

Gurugram, Haryana, India

Hara Jeevan is an initiative towards the restoration of natural elements and improving the human psyche for complimenting the cause. The mission is to plant and help sustain 100 million trees by 2040.

Data Analytics Consultant Intern

KPMG Australia

2020-7 - 2020-7 · 1 mo

Implementing analysis on large datasets and providing Data Quality Analysis. With the help of Analytical Dashboard Creation carrying out meaningful knowledge discovery. Using Data Exploration, Model Development, and Interpretation techniques to provide Customer Segmentation Analysis and Data-Driven Presentations using Visualizations and Applied Statistics.

Technology Consultant Intern

Deloitte

2020-6 - 2020-7 · 2 mos

Gurgaon, Haryana, India

Deloitte Virtual Internship certified as Technology Consultant in Cloud Engineering, Technology Strategy & Innovation, and Optimization & Delivery.

Project Lead - Volunteer

Greenthusiast Foundation

2020-4 - 2020-7 · 4 mos

Gurugram, Haryana, India

GreenThusiast Foundation is a veritable organization, planting trees around remote villages and across cities in Span India. The organization schedules campaigns to spread awareness among people for benefiting the environment which has become hazardous due to global warming and hot climate change globally.

Internship Trainee

VDOIT Technologies

2020-1 - 2020-7 · 7 mos

Gurgaon, India

Solutions Architect Intern

Amazon Web Services (AWS)

2019-5 - 2019-6 · 2 mos

Gurgaon, Haryana, India

To design, develop and deploy Highly Available, Robust and Fault-tolerant IT Infrastructure using AWS Services.

Education

University of Calgary

2023-8 - 2024-8 · 1 yr 1 mo

GD Goenka University

Major in Computer Science Engineering & Minor in Business Analytics by IBM

2016 - 2020 · 4 yrs

Google Cloud Platform || Amazon Web Services || Microservices || Linux || Java Developer || Python Developer || Data Analyst || TABLEAU || Power BI || IBM Cognos || IBM InfoSphere Data Architect || Data Warehousing & Data Mining || PostgreSQL || SQL || UiPath || Ui.Vision || Robotic Process Automation