David Tran
Senior Data Engineer | Data Platform & ETL Specialist
5321 Stonehedge Ct, Yorba Linda,CA
Summary
Senior Data Engineer with 10+ years of experience designing, building, and optimizing data pipelines and data warehouse solutions. Proven expertise in SQL, ETL development, and data modeling across enterprise environments. Hands-on experience querying and analyzing data in Snowflake, with a strong foundation in scalable data architecture, performance optimization, and analytics enablement.
Overview
17
17
years of professional experience
Work History
Senior Data Engineer
Optum
05.2023 - Current
- Queried and analyzed data within Snowflake to support reporting, validation, and business insights
- Designed and deployed automated ETL pipelines to transform raw data into structured, analytics-ready datasets
- Built and optimized data transformation workflows, improving efficiency and reliability of downstream systems
- Contributed to a centralized data repository, improving accessibility and cross-team collaboration
- Applied data modeling practices aligned with modern cloud data warehouse patterns (including Snowflake ELT concepts)
Sr. Data Analyst
Optum
12.2012 - 05.2023
- Developed and maintained data warehouse solutions using dimensional modeling and data marts
- Wrote complex SQL queries to optimize performance and troubleshoot large-scale data processing issues
- Collaborated cross-functionally to design, test, and deploy scalable data solutions
- Built enterprise reporting solutions using SSRS, Power BI, and Tableau
- Ensured high data quality through testing, validation, and QA methodologies
- Designed data structures and ETL processes consistent with modern cloud warehouse concepts (e.g., Snowflake architecture patterns)
- Utilized Snowflake and SQL Server environments to query, validate, and analyze large datasets
- Wrote complex SQL queries to optimize performance and support large-scale data processing
- Designed ETL processes aligned with modern cloud data warehouse architectures
ETL Developer
Kaiser Permanente
11.2008 - 11.2012
- Designed and implemented ETL pipelines integrating data from multiple heterogeneous sources
- Built and optimized SQL-based transformations using SQL Server BI stack (SSIS, SSAS)
- Supported data warehouse migrations and system transitions, improving scalability and reliability
- Conducted performance testing to ensure high availability and reliability of data pipelines
- Built ETL solutions and data models adaptable to modern cloud platforms, including Snowflake
Education
MBA - Technology Management
University of Phoenix
Tempe, AZ 03.2012 - 05.2014
Bachelor of Science - Information Technology
University of Phoenix
Tempe, AZ 11.2008 - 10.2011
Core Skills
- Data Engineering: ETL/ELT pipelines, data transformation, workflow automation
- Data Architecture: Data warehouses, data marts, dimensional modeling
- Data Platforms: SQL Server, Snowflake
- Tools: SSIS, SSRS, Power BI, Tableau
- Languages: SQL
- Concepts: Data quality, performance tuning, data integration
Timeline
Senior Data Engineer
Optum
05.2023 - Current
Sr. Data Analyst
Optum
12.2012 - 05.2023
ETL Developer
Kaiser Permanente
11.2008 - 11.2012
MBA - Technology Management
University of Phoenix
03.2012 - 05.2014
Bachelor of Science - Information Technology
University of Phoenix
11.2008 - 10.2011