Loading visitor count...

About Me

Let Me Introduce Myself.

I'm a Cloud Data Engineer with over two years of production experience designing reliable data platforms, cloud pipelines, and modern enterprise data solutions.

I've built and supported more than 100 production CDC/ETL pipelines while working across Azure Synapse, Azure Data Factory, SQL Server, and enterprise data warehouses. My experience includes data modeling, incremental ingestion, reconciliation frameworks, performance optimization, and delivering trusted datasets from complex legacy systems.

More recently, I've expanded into enterprise systems engineering by integrating Microsoft Graph, OAuth 2.0, REST APIs, and AI-assisted automation into production business workflows. This experience has broadened my engineering perspective, enabling me to build reliable systems that integrate data platforms, enterprise applications, and AI-powered business automation.

I enjoy solving complex engineering problems and building reliable cloud solutions that deliver measurable business value.

What I'm Looking For

I'm seeking opportunities to build modern cloud data platforms where I can contribute across data engineering, enterprise integrations, and AI-enabled automation while continuing to deepen my expertise in Spark, Databricks, and scalable cloud architectures.

📬 Reach me at andreahayes.dev@gmail.com or LinkedIn.

Core Engineering Expertise
Data Engineering
Python SQL CDC ETL / ELT Spark Delta Lake Data Warehousing Data Modeling
Cloud
Azure Synapse Azure Data Factory Azure SQL Databricks
Enterprise Engineering
REST APIs Microsoft Graph OAuth 2.0 Token Caching Authentication Logging Observability Error Handling
AI & Automation
Vertex AI LangChain Pydantic Structured Outputs Prompt Engineering AI-assisted Workflow Automation

Name: Andrea Hayes

LinkedIn: Andrea_Hayes_MSML

GitHub: NikkLuna

Phone: Available Upon Request

Email: andreahayes.dev@gmail.com

My Art: Website

"Patience, persistence and perspiration make an unbeatable combination for success."

-Napoleon Hill

My Experience

My Work History

10/2024
until
Present
Tekletics
Data Engineer
  • Designed and deployed 100+ production CDC pipelines using Azure Synapse, Azure Data Factory, and SQL Server CDC to deliver reliable, scalable incremental data ingestion across enterprise systems.
  • Led development of 18 Core warehouse tables, designing data models, deterministic join logic, reconciliation processes, and validation frameworks to produce trusted datasets from fragmented legacy systems.
  • Built metadata-driven ingestion frameworks supporting XML, JSON, and relational source systems while improving maintainability through reusable pipeline patterns and centralized configuration.
  • Optimized high-volume data workloads through SQL tuning, orchestration improvements, and warehouse performance analysis, significantly reducing runtime for critical production pipelines.
  • Authored implementation standards, troubleshooting documentation, and onboarding guides that standardized CDC development practices across hundreds of production pipelines while mentoring junior engineers.
Enterprise Systems & AI Engineering
  • Built an enterprise AI-assisted email automation workflow integrating Microsoft Graph, OAuth 2.0, REST APIs, and Vertex AI to classify customer requests, retrieve shipment information, and generate AI-assisted draft responses.
  • Designed a hybrid deterministic-plus-LLM architecture using regex-first extraction, structured outputs, and LLM fallback to improve identifier extraction accuracy while controlling AI inference costs.
  • Implemented production engineering patterns including centralized authentication, token caching, structured logging, error handling, configuration management, and observability to improve system reliability and maintainability.
  • Collaborated with business stakeholders to translate transportation workflows into scalable technical solutions, balancing deterministic logic with AI capabilities to improve operational efficiency.
9/2022
until
6/2024
Amazon
Amazon Robotics Floor Monitor (ICQA)
  • Supported operations on Amazon Robotics fulfillment systems after earning Floor Access Safety Training (FAST) certification.
  • Diagnosed and triaged robotics floor incidents, documenting technical details and coordinating escalations with engineering support teams.
  • Communicated system status, asset information, and incident severity to enable timely issue resolution across operations and technical teams.

ACHIEVEMENT:

  • Authored an operational guide for Quarterback/Team Lead responsibilities, standardizing troubleshooting procedures, escalation workflows, and performance reporting for leadership.

My Education

May
2024
Western Governors University
Bachelor of Science

Software Engineering

HIGHLIGHTS

  • Software engineering
  • Data management
  • Systems architecture
  • Networking
  • Security
  • Programming

ACHIEVEMENT

  • Excellence Award for Exemplary User Interface Design
November
2018
Western Governors University
Master of Science

Business Management & Leadership

FOCUS

  • Strategic leadership
  • Organizational change
  • Business strategy
  • Data-driven decision making

My combination of software engineering and business education allows me to communicate effectively with both technical teams and business stakeholders while designing practical engineering solutions.

"When I have fully decided that a result is worth getting I go ahead of it and make trial after trial until it comes."

-Thomas A. Edison

Technical Skills

See my highlighted technical skills below for related skillsets to the required skills for the position I'm applying for.

SQL

Experience building production queries and data models

Databricks

Experience designing and tuning notebooks and jobs

PySpark

Used for data transformation, joins, windowing, and performance tuning

Delta Lake

Experience with upserts (MERGE), schema evolution, and partitioning

Python

Used for scripting, validation, and PySpark jobs

Git / GitHub

Experience with version control, collaboration, and pipeline CI/CD

Airflow

Designed DAGs to automate ETL tasks and manage task dependencies

Azure Data Factory

Used ADF to build dynamic pipelines with parameters and conditional logic