Girish Reddy

Data Engineer with experience building enterprise data pipelines and analytics models across procurement, financial services, healthcare, and retail. Skilled in Python, advanced SQL, dbt, Snowflake, AWS, and workflow orchestration. Experienced in dimensional modeling, SCD implementations, pipeline troubleshooting, regression testing, and GitHub CI/CD workflows. Collaborates with analysts and business teams to deliver reliable datasets for Tableau and Power BI reporting.

Associate Data Engineer - Candex

(2025-09)

• Built end-to-end ELT transformation pipelines using dbt and Snowflake to support procurement analytics and business reporting.
• Refactored complex Snowflake views into modular dbt models with appropriate materialization strategies to improve query performance and reduce report execution time.
• Created fact and dimension tables using Kimball dimensional modeling principles to provide structured datasets for Tableau dashboards.
• Implemented SCD Type 1 update logic and used dbt snapshots for SCD Type 2 historical tracking.
• Performed regression testing in Snowflake development environments using validation views to compare outputs and verify transformation accuracy.
• Used Git and GitHub pull requests within CI/CD workflows; participated in code reviews and incorporated feedback to improve SQL and model quality.
• Partnered with analysts and business teams to translate requirements into data models; documented source-to-target mappings, transformations, and dependencies in Confluence.
• Tracked development tasks and issues in Jira and communicated progress across technical and business teams.

Data Engineer - Capital One

(2024-01 - 2025-09)

• Developed data ingestion and transformation pipelines for fraud detection, risk management, and customer segmentation using Python, SQL, and cloud-native tools.
• Designed batch and real-time ingestion solutions using AWS Lambda, Apache Flink, and Snowflake; integrated REST and GraphQL APIs and Fivetran data feeds.
• Built Snowflake and Amazon Redshift warehouse models using dimensional schemas, dbt, and SCD Type 2 techniques to support analytical workloads.
• Optimized SSIS ETL workflows and Spark and Snowflake transformations to improve processing efficiency and data access.
• Monitored and troubleshot Power BI refresh failures and data integrity issues; performed profiling, cleansing, and validation to support reliable reporting.
• Created Snowflake audit tables and usage dashboards using Information Schema and Account Usage views.
• Collaborated with stakeholders on requirements, presented pipeline designs during Agile sprint reviews, and used Jira and Git-based CI/CD workflows.

Data Engineer - Molina Healthcare

(2021-01 - 2022-07)

• Developed healthcare ETL/ELT pipelines using Azure Data Factory, Informatica, SSIS, and Python to integrate structured and unstructured enterprise data.
• Designed warehouse models and applied SCD techniques to maintain historical provider and patient information.
• Automated HL7/FHIR data ingestion using PySpark and mapped data between EHR, FHIR, and master data management systems.
• Built Power BI dashboards and automated SQL reporting workflows for patient care, financial, and operational metrics.
• Gathered requirements from clinical, actuarial, and finance teams; performed data validation and cleansing to support data quality and HIPAA requirements.
• Documented pipeline logic, mappings, and data models and provided Power BI training and support to business users.

Junior Data Engineer - Target

(2020-04 - 2020-12)

• Built and maintained ETL pipelines, wrote SQL queries, and transformed retail data into structured datasets for reporting and analytics.
• Supported ingestion and transformation using BigQuery and Apache Spark and workflow scheduling using Airflow and Luigi.
• Developed Tableau dashboards for sales, product demand, and inventory; validated datasets to support reporting accuracy.
• Collaborated with analysts on reporting requirements and documented ETL processes, transformations, job schedules, and data lineage.

Master’s in Data Analyst - Clark University (2022-08 - 2024-05)