Learn Data Skills
Paul Sun

Paul Sun

Software Data Engineer

C & W | Dallas, Texas

Technologies

Data Engineer

My Work

Take a look at my latest work.

course

Introduction to dbt

SQL
course

Introduction to Snowflake SQL

SQLSnowflake
course

Introduction to Data Modeling in Snowflake

SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

USAA | Jul 2025 - Nov 2025

Data Engineer

• Situation: Information security team needed reliable data pipelines to power analytics dashboards for 50+ security analysts processing multi-source security event data • Task: Build data models and improve development efficiency while ensuring data quality standards • Action: Set up Model Context Protocol (MCP) connections for AI agents and created 5+ dbt data models with comprehensive tests and documentation • Result: Improved AI code generation accuracy by 40%, reduced development time, and cut new engineer onboarding from 3 weeks to 1 week
Show More

Caine & Weiner | Jul 2024 - Jul 2025

Software Data Engineer

• Situation: Debt collection workflows relied on 20+ hours per week of manual data parsing, creating bottlenecks and data integrity issues affecting financial reporting • Task: Automate data parsing and ensure accuracy for downstream financial systems • Action: Built Python-based ETL solution with complex Pandas lambda functions to perform multi-table joins and transformations • Result: Eliminated 100% of manual parsing labor, processed 50K+ daily records with 99.9% accuracy, enabled team to focus on analytics

Bokksu | Apr 2022 - Feb 2024

Data Engineer

• Situation: E-commerce analytics infrastructure needed performance improvements for business-critical reports taking 45+ seconds to run • Task: Optimize data warehouse queries and maintain AWS Lambda functions for customer and inventory data processing • Action: Rewrote SQL queries using CTEs and window functions, managed 25+ Lambda functions, contributed to open-source dbt-docs-to-notion project • Result: Reduced average query execution time from 45 seconds to 8 seconds for key reports, improved data infrastructure reliability

Samsung | Apr 2021 - Oct 2021

Software QA Engineer

N/A

My Education

Take a look at my formal education

Bachelor of Science in Computer ScienceMontclair State University | 2019

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free