RYAN HANLIN
DATA ENGINEER
Nashville, TN 615-***-**** ****.******@*******.***
PROFESSIONAL SUMMARY
Data Engineer with ~10 years of experience developing and supporting data integration, ETL/ELT, and analytics solutions across diverse industries and platforms. Skilled in Azure Data Factory, advanced T-SQL, Python, data warehousing, and database performance tuning. Experienced in building reliable ingestion and transformation workflows, implementing data validation and reconciliation, and supporting data services in regulated environments. TECHNICAL SKILLS
Cloud & Orchestration: Microsoft Azure, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Logic Apps, Azure DevOps, CI/CD Pipelines, Pipeline Scheduling & Orchestration, Deployment Automation Programming & Query Languages: Advanced T-SQL, SQL, PL/SQL, Dynamic SQL, Common Table Expressions (CTEs), Correlated Subqueries, Stored Procedures, User-Defined Functions (UDFs), Views, Triggers, Python, VBScript, C# Databases & Analytics Platforms: Microsoft SQL Server, Azure SQL, Databricks, Snowflake, Oracle, MySQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Apache Airflow Data Engineering & Architecture: ETL/ELT Development, Data Integration, Data Transformation, Data Warehousing, Data Mart Development, Dimensional Modeling, Incremental & Delta Loads, Change Data Capture (CDC), Source-to-Target Mapping, Data Pipeline Development, Schema Design
Data Quality & Reliability: Data Validation, Data Reconciliation, Referential Integrity, Data Profiling, Exception Handling, Pipeline Monitoring, Operational Logging, Root Cause Analysis, Disaster Recovery, Data Integrity Controls Performance Engineering: SQL Query Optimization, Execution Plan Analysis, Index Design & Optimization, Partitioning Strategies, Performance Tuning, Database Troubleshooting, Git, Redgate, REST APIs, API Integration, PGP Encryption PROFESSIONAL EXPERIENCE
Elevance Health Data Engineer
03/2026—09/2026 • Contract
• Engineered and optimized enterprise solutions, developing complex stored procedures, transformation and reconciliation logic, indexing strategies, and performance optimizations supporting high-volume pharmacy operations and post-merger integrations.
• Built Python, SQL, and Snowflake solutions for data quality, reconciliation, and automation, including validation checks, exception reporting, variance and missing data detection, and out-of-balance controls. Implemented Snowflake staging, loading, data modeling, and transformation patterns to support analytics and migration initiatives.
• Designed and supported production pipelines with scheduling, dependency management, recoverable processing, execution logging, audit controls, and data validation. Monitored runs, analyzed load failures, coordinated reprocessing, and documented incidents and corrective actions to support reliable data delivery. Archwell Health Data Engineer
11/2023—03/2026
• Developed Azure Data Factory pipelines to ingest and transform data from disparate healthcare systems, establishing repeatable integration workflows for centralized reporting and analytics.
• Standardized ingestion and loading patterns using T-SQL and configurable pipelines to support reliable movement of operational data into enterprise data warehouses.
• Engineered and tuned complex SQL transformations, validation frameworks, and load processes, improving query performance by approximately 25–35% and reducing latency across critical reporting workflows.
• Built Python utilities for data ingestion, transformation, reconciliation, and process automation; contributed to technical design reviews and maintained operational support documentation. Affinaquest Data Engineer
03/2022—10/2023
• Integrated Azure Data Factory orchestration with SQL development and stored procedures to coordinate end-to-end data workflows across hybrid architectures.
• Standardized source ingestion and applied schema enforcement and ETL design patterns to improve consistency and integrity in analytics-ready data models.
• Used Python for data manipulation, workflow automation, and ETL troubleshooting, supporting downstream reporting, APIs, and analytics services.
• Investigated dataflow and reporting issues across integrations, using SQL and Python to isolate processing defects and support resolution.
Extractomatic Data Engineer
12/2021—03/2022 • Contract
• Designed and implemented HIPAA-compliant ETL pipelines to transform and integrate healthcare datasets using Microsoft SQL Server and AWS infrastructure.
• Worked with stakeholders to connect distinct healthcare data sources, applying ETL architecture, security, and compliance practices in a regulated data environment. National Distribution & Contracting SQL Server Developer 09/2019—12/2021
• Developed complex SQL Server stored procedures and views, improving data retrieval efficiency by 40% and strengthening data integrity through validation within the first six months.
• Built set-based T-SQL transformations and data movement processes incorporating incremental loads, validation, error handling, and performance tuning for inbound and outbound integrations.
• Developed Azure Data Factory and Logic Apps integrations to orchestrate ingestion, transformation, and delivery of business-critical data.
• Translated stakeholder requirements into relational data models and ETL logic, supporting consistent, accurate, and usable downstream reporting and analytics.
Professional Educational Services Group SQL Server Administrator 01/2017—08/2019
• Administered SQL Server 2012, 2014, and 2016 environments, synchronized legacy databases with the current environment, and automated vendor data imports through SSIS packages developed and deployed in Visual Studio.
• Analyzed execution plans and optimized queries across SQL Server instances to improve database performance and data retrieval.
• Diagnosed SQL Server performance and system-health issues using Activity Monitor, SQL Profiler, and dynamic management views (DMVs), resolving operational problems.
• Designed and deployed SQL workflows and data-processing logic, reducing deployment errors by approximately 20% through stronger validation and testing practices. EDUCATION
Associate of Applied Science, Computer Programming Technology Meridian College 08/2009—05/2012 • Meridian, MS
• Dean’s List
• Elected Chairperson, Diversity, Equity & Inclusion Committee, Multicultural Council
• Community Outreach Coordinator, Multicultural Council CERTIFICATIONS & AWARDS
Python for Data Science, AI & Development IBM • 03/2026 Cloud Data Integration Developer Informatica • 01/2026 Azure Database Administrator Associate (DP-300) Microsoft • 06/2025 2nd Place – Cybersecurity Future Business Leaders of America, Mississippi State Leadership Conference • 2011 TECHNICAL PORTFOLIO
RyanHanlin.info Professional Portfolio
Professional website showcasing technical background, experience, and career portfolio. SQLScript.com SQL Programming & Development
SQL-focused website dedicated to SQL programming, scripting, and database development resources.