Experience

BC Public Service

Senior Data Architect, Natural Resources Information and Digital Services Division • April, 2024 — Present

sanchitwadhwa.com

Data Engineering Consultant • March, 2024 — Present

As a self-employed Data Engineering Consultant, I leverage over a decade of industry experience to provide tailored solutions in data management, integration, and ETL processes. My expertise encompasses optimizing data architecture, facilitating informed decision-making, and offering comprehensive services such as data modeling, warehouse design, and cloud integration (Azure). Through strategic insights and innovative approaches, I empower clients to unlock the full potential of their data assets, driving success and achieving organizational goals.

Safe Harbor Marinas

Director of Data • March, 2020 — February, 2024

I joined the organization with a mission to transform the success of the operation by addressing critical organizational gaps, effectively building a customer support team, and taking over the position of Database Administrator, implementing best practices for database management and security. Introduced the data warehouse and contributed to audit activities. Most notably, I enabled the growth of the organization and the integration of data to execute critical decision-making and facilitate the scalability of the operation.

DealerSocket

Database Administrator • July, 2018 — March, 2020

I was promoted to the role of Database Administrator by the executive leadership team, gaining recognition for the exceptional delivery of projects and expertise in the field of data management. I leveraged my expertise and prior experience to elevate business capabilities by overseeing all database servers, ensuring reliability and high performance. I contributed significantly to the seamless operation of the company's CRM system, facilitating operational excellence enterprise-wide.

DealerSocket

Manager - Data Solutions • October, 2017 — July, 2018

I joined the organization as a Data Analyst, earning upward promotion to Data Solutions Manager. I effectively supported the business during a period of significant growth. I focused on coaching and mentoring new analysts, ensuring the availability of tools, resources, and knowledge to execute tasks. In addition, I cultivated a continuous improvement environment, overseeing and monitoring ticket logs, guiding high-priority cases, and collaborating with leadership to resolve critical customer issues.

DealerSocket

Data Analyst • November, 2013 — October, 2017

Edward's Lifesciences

Document Specialist • November, 2012 — November 2013

Ephesoft, Inc (a Kofax company)

Software Engineer - Intern • October, 2010 — January 2012

Education

University of California, Irvine

Bachelor of Science, Computer Science • 2012

Skills

Data Modeling

Data Warehouse Design

Azure Cloud (Portal, Synapse, One Lake, Purview)

setup subscriptions, resources, purview setup and configuration

Azure Data Catalog

setup business glossary, connect & scan data sources, access policy

dbtCloud & dbtCore

Install/Setup dbtCore and dbtCloud, create DAG, doc, Jinja, macros, tests, models, data sources

Organizational leadership

I have several years of experience leading organziations from community groups to business departments. From public speaking, to mentoring, to coordination of people and events, I can lead in any context.

Recognition

dbt Fundamentals

dbt Labs • 2023

Completed the online dbt Fundamentals v2 course and passed the end of course quiz. This demonstrates fundamental understanding of models, sources, tests, docs, and deployment in dbt.

ITILĀ® 4 Foundation Certification Training Course

SimpliLearn • 2021

ITIL key concepts, ITIL central principles, ITIL process models, Service level management, Customer experience improvements, ITSM efficiency