Senior Data Engineer - ETL, Cloud, and Analytics Architect

Elmira Farrar 832-***-**** ********@*****.*** linkedin.com/in/efarra/

Innovative and results-driven Senior Data Engineer with a proven record of creating and optimizing data pipelines, analytics systems, and cloud-based infrastructures across AWS, GCP, and on-premises environments. Skilled in transforming complex datasets into actionable insights through advanced ETL design, real-time automation, and performance tuning. Experienced in end-to-end development using Java, Spring Boot, and Tableau to enhance system scalability and data visibility.

CORE EXPERTISE

Programming Languages: Python

Databases: PostgreSQL AWS (Redshift, RDS, Aurora), Snowflake Data Engineering & Analysis Tools: AWS (EC2, S3, Sagemaker, CloudFormation, CodeBuild/CodePipeline, Quicksight, Glue, SNS/SQS, Lambda, ECS) Tableau Spark (PySpark) PROFESSIONAL EXPERIENCE

CAPITAL ONE, Plano, TX 07/2024 – 09/2025

SR. DATA ENGINEER

Optimized Tableau dashboards to deliver actionable insights to Business Analysts that drove data-informed decisions across multiple Auto Loan business lines.

Refined Snowflake SQL queries to extract, transform, and aggregate key performance data supporting high- visibility reporting initiatives.

Transformed legacy code execution time by reducing it from 3 hours to under 5 minutes through comprehensive restructuring and reformatting that enabled timely insights into the current business state.

Automated report generation using Python scripts which decreased developer involvement from several hours to mere validation, by integrating a parallel-processing pipeline and enabling automatic server publication from a dashboard trigger.

HACKBRIGHT, Remote, USA 06/2023 – 09/2023

FULL-STACK SOFTWARE ENGINEER FELLOW

Designed and implemented end-to-end solutions for the Flix and Store-Cap projects that contributed to both front- end and back-end development to enhance system performance and scalability.

Engineered robust application architectures using Java, JavaScript, and Spring Boot, ensuring seamless data integration and efficient processing pipelines.

https://github.com/eachabys/Store-Cap and https://github.com/orgs/FlixBase/ RACKSPACE TECHNOLOGY, Remote, USA 02/2020 – 06/2023 BIG DATA ENGINEER II

Deployed scalable data pipelines across AWS (SageMaker, CI/CD CodeBuild/CodePipeline Suite, CodeCommit) and GCP

(BigQuery, DataFlow, Data Catalog) to support advanced analytics and machine learning initiatives.

Optimized complex ETL workflows using AWS Glue, Redshift, Lambda, and CodePipeline that improved data reliability and reducing processing times.

Led database migrations and validation across relational (PostgreSQL, Redshift) and non-relational (DynamoDB).

Processed data using Python and Pyspark

Early Career Experiences:

Insight Data Science Data Engineer Fellow

University Of Houston Research Assistant

TGS NOPEC Processing Engineer II

EDUCATION & CERTIFICATIONS

M.S. in Geophysics & Rock Physics, University of Houston, Houston, TX B.S. in Electrical Engineering, Tomsk State University, Tomsk, Russia AWS Certifications: Developer Associate, Security, Analytics Specialty, Solutions Architect Associate, Cloud Practitioner

Contact this candidate