Priti Dhiman
Summary
Analytics Engineer with 7+ years of experience building scalable ELT pipelines, semantic data models, and cloud-based analytics platforms across financial services and enterprise organizations. Expertise in Python, SQL, Snowflake, dbt, and Dagster with a proven track record delivering automation, improving data quality, and enabling self-service analytics. Experienced translating complex business requirements into reliable data products that support strategic decision-making.
Overview
7
7
years of professional experience
Work History
Associate, Business Intelligence
BasePoint Capital
New York, NY
11.2025 - Current
- Designed and deployed 2 production Dagster pipelines comprising 8+ assets, automating ingestion, transformation, and delivery of lending and portfolio management data into Snowflake.
- Developed 15+ production dbt models and reusable Jinja-based transformation frameworks, enabling scalable analytics and reducing duplicate development effort across reporting workflows.
- Built a scalable Python-based ingestion framework integrating SFTP transfers, Slack notifications, automated email distribution, and Snowflake delivery, eliminating an estimated 10–15 hours of manual work per week.
- Engineered modular, asset-based orchestration patterns in Dagster, replacing legacy workflows with maintainable pipelines for improved scalability and future reuse.
- Processed and modeled datasets of tens of millions of records, supporting reporting and operational analytics across lending, servicing, and portfolio management functions.
- Collaborated on enterprise reporting migration from Tableau to Sigma, redesigning Snowflake models, schemas, and reporting datasets to enhance self-service analytics capabilities.
Data Visualization Engineer
Colgate-Palmolive
Piscataway, NJ
06.2023 - 11.2025
- Designed and implemented an end-to-end ELT platform ingesting data from 11 Sigma audit tables into GCP and Snowflake using Python, REST APIs, Airflow, and Docker.
- Developed automated data pipelines and transformation frameworks that improved reliability, scalability, and audit visibility across enterprise reporting systems.
- Built and maintained dbt models to standardize, deduplicate, and transform audit datasets for global business stakeholders, enhancing data integrity and accessibility.
- Automated Sigma license governance processes through Python-based workflows, generating approximately $300,000 in annual software cost savings.
- Developed infrastructure-as-code solutions with Terraform to provision Snowflake resources and Vault security configurations, ensuring consistent deployments and strengthened governance.
- Integrated Okta OAuth and HashiCorp Vault authentication workflows to enable secure, automated access to enterprise data platforms, facilitating compliance and reducing manual access risks.
Business Intelligence Analyst
BlackRock
Princeton, NJ
07.2021 - 06.2023
- Engineered a unified analytics dataset covering approximately 45,000 investment portfolios by integrating operational, compliance, strategy, and performance data sources using Python and SQL.
- Developed Tableau dashboards and automated reporting solutions that enhanced visibility for investment operations and portfolio management teams.
- Partnered with stakeholders to design analytics solutions that improved portfolio oversight and informed operational decision-making.
- Provided analytics for a major platform transition initiative, contributing to preservation of approximately $500 million in client assets and exceeding projected retention targets by 16%.
- Built data processing and automation workflows using Pandas and NumPy that improved reporting accuracy and reduced manual analysis effort.
Global Data Analyst
Bloomberg
Princeton, NJ
09.2019 - 01.2021
- Delivered analytical problem-solving and data-driven insights to support clients and internal stakeholders, driving informed decision-making.
- Resolved data quality issues in collaboration with cross-functional teams, bolstering data accuracy and reliability.
- Conducted data analysis and quality assurance for financial market datasets utilized by institutional clients, enhancing data integrity.
Education
Master of Science - Software Development & Engineering
Pace University
New York, NY01-2028
Bachelor of Arts - Mathematics, minor in Philosophy
Rutgers University
New Brunswick, NJ08-2019
Skills
- Data Visualization
- Data Analytics
- Data Engineering
- dbt Cloud/Core
- Python
- Snowflake
- SQL
- AWS/GCP
- Dagster
- REST APIs
- GitHub
- Airflow
- Terraform
- Semantic Modeling
Select Projects
Automated Lending Data Platform
- Designed a reusable Dagster architecture integrating SFTP ingestion, Snowflake transformations, Slack notifications, and automated report distribution.
- Built modular Python classes and reusable asset patterns supporting future pipeline expansion and maintainability.
- Eliminated approximately 10–15 hours of manual work per week through workflow automation.
Sigma Audit Analytics Platform
- Built an ELT framework ingesting 11 Sigma audit tables into Snowflake through GCP using Python, Airflow, Docker, and dbt.
- Developed transformation and data quality layers supporting enterprise audit reporting.
- Enabled license governance automation that contributed to approximately $300,000 in annual software savings.
Volunteer Experience
America Needs You (ANY), Mentor Coach
September 2025 to Present
- Mentor first-generation college students through resume reviews, mock interviews, and career development coaching.
- Provide guidance on careers in analytics, data engineering, and financial services.
Timeline
Associate, Business Intelligence
BasePoint Capital
11.2025 - Current
Data Visualization Engineer
Colgate-Palmolive
06.2023 - 11.2025
Business Intelligence Analyst
BlackRock
07.2021 - 06.2023
Global Data Analyst
Bloomberg
09.2019 - 01.2021
Master of Science - Software Development & Engineering
Pace University
Bachelor of Arts - Mathematics, minor in Philosophy
Rutgers University