×
Niwat Wongrak

Niwat Wongrak

Data Engineer

Huai Khwang, Bangkok, TH
098-119-6407

Background


About

About

Data Engineer with over 5 years of experience in data-related roles, covering Data Pipelines, ETL/ELT processes, Data Quality, and Data Warehouse/Data Lake environments. Experienced in Databricks and Apache Spark within large enterprise environments, utilizing internal frameworks, CI/CD standards, and custom validation logic. Strong foundation in SQL, Python, Excel automation, and business understanding gained from MIS and Data Analyst roles.

Work Experience

Work Experience

  • Data Engineer (Outsource), KBTG

    Nov, 2024 - Present

    Enterprise data engineering on Databricks platform

    • Reviewed Data Dictionaries and sample data with System Owners before ingestion

    • Validated data consistency and data quality between documentation and actual datasets

    • Standardized metadata for Tables, Views, and RBAC on Databricks

    • Developed Python, PySpark, and Spark SQL for validation and quality checks

    • Performed data ingestion into Data Lake and executed unit tests

    • Managed GitHub repositories and deployed jobs via CI/CD to DEV and UAT

    • Conducted UAT system testing to support SIT and production releases

  • Data Engineer, SSUP Holdings

    May, 2024 - Nov, 20246 months

    ETL and data warehouse development

    • Developed and maintained ETL pipelines (full and incremental load)

    • Designed data models aligned with business requirements

    • Built SQL stored procedures using CTEs and parameterized queries

    • Ensured data accuracy, completeness, and consistency

    • Collaborated with Data Analysts on BI models and data marts

    • Optimized SQL queries and resolved data-related issues

  • Model B-score Testing (Outsource), UOB

    Dec, 2023 - Apr, 20244 months

    Data quality and model validation

    • Performed post-migration data quality validation

    • Developed automated unit tests for calculation logic

    • Analyzed discrepancies between model output and manual calculations

    • Prepared testing summary reports and improvement recommendations

  • Data Analyst, Sri Trang Agro-Industry

    Aug, 2023 - Nov, 20233 months

    Business analytics and automation

    • Developed dashboards for nationwide rubber procurement monitoring

    • Built automated ODBC data extraction using Excel Query and Task Scheduler

    • Designed data models with Power Pivot

    • Developed end-to-end VBA automation for reporting and email distribution

    • Delivered ad-hoc analysis for executive decision-making

  • MIS Operation, Thai Credit Bank

    Nov, 2022 - Jul, 20238 months

    Operational reporting and automation

    • Designed performance monitoring reports

    • Analyzed SLA performance and error rates

    • Developed Excel VBA user forms and automation tools

    • Prepared monthly workforce and attendance reports

  • MIS Collection, Nissan Leasing (Thailand)

    Mar, 2022 - Sep, 20226 months

    Collection performance and reporting

    • Designed task assignment processes for collection agencies

    • Developed payment collection and auction reports

    • Analyzed agency performance

    • Improved SQL and VBA processes to reduce processing time

  • System Development, V Cash Enterprise

    Aug, 2018 - Oct, 20213 years 2 months

    Reporting and system support

    • Prepared commission and P&L reports

    • Controlled accounting data accuracy

    • Developed operational and sales reports

    • Improved reporting efficiency using Excel Power Query

Skills

Skills

  • Programming & Tools

    SQL

    Python

    Databricks

    Apache Spark

    GitHub

    SAS

    Excel

  • Databases

    SQL Server

    PostgreSQL

  • Languages

    Thai (Good)

    English (Fair)

Education

Education

  • Business Computer, Bachelor of Business Administration, University of the Thai Chamber of Commerce

    - Present