Nathan Daniels
Krugerville,TX
Summary
Experienced Data Engineer who enjoys the big data cosmos. I've had the pleasure of being able to work on large innovation and modernization efforts during my professional experience. These involved rebuilding and retooling our tech stacks to be more forward-thinking and resilient for the future. Skilled in cloud data technologies such as Snowflake, DBT/Jinja, and SQL. I'm all about helping organizations make better analytical decisions by enabling our IT teams to move faster
Overview
9
9
years of professional experience
Work History
Data Engineer
Travelers Indemnity Co
08.2023 - Current
- Facilitated ingestion of Guidewire Policy data into Snowflake through ETL processes
- Performed an evaluation of AWS Glue to determine the viability of tech for application to current project. Presented viability report to management.
- Developed database architectural strategies at modeling, design, and implementation stages handle incremental load of Guidewire policy data into Snowflake.
- Provisioned and deployed Snowflake Databases, schemas, roles, grants, and warehouses.
- Developed design documents, took ownership of efforts, and mentored younger team members.
Data Engineer I
USAA
08.2022 - 08.2023
- Lead a team in building the first claims DBT Data Build Tool) ELT cycle 750m+ records) loading snowflake claims data warehouse tables
- This paved/is paving the way for the conversion of ETL tooling in the claims D&A space for other teams to follow our lead into the cloud
- Built and maintained DBT cycles loading to Snowflake based CWH Claims Data Warehouse)
- Mainly financial data related to claims Allocations & Offers)
- Subject Matter Expert on Data Build Tool Data Build Tool) at USAA for the claims data analytics space
- Act as an accelerator, helping and consulting with sister teams to adopt DBT faster and with less pain
- Present technical demos and feature presentations to executive management on innovations in data space DBT
- Production support of ETL cycles in the Claims analytics space.
Data Engineer II
USAA
09.2019 - 08.2022
- Assistant tech lead on internal effort to capture and provide detailed claims data from across the entire analytics space
- Worked in conjunction with vendor to create new insights and reporting which lead to a 41% increase in USAA's ability to detect and stop fraudulent claim schemes
- Facilitated migration of historical and current daily data loads from operational data store into Snowflake via ETL and snowflake streams and tasks
- Optimized performance of ETL processes via Informatica pushdown SQL to make data warehouses more performant
- Built and maintained Informatica ETL to consume operational claims data and load/transform it by subject area into 'MegaMart' claims data warehouse.
Data Engineer III
USAA
01.2018 - 08.2019
- Built and maintained Informatica ETL cycles and IBM Netezza database infrastructure supporting claims data warehouse reporting
- Wrote and maintained bash and python scripts for loading/receiving data files
- Helped create python validation framework for checking record counts after ETL runs.
Summer Intern
USAA
05.2016 - 08.2016
- IT Technical Intern working with a Property & Casualty team focused on JAVA development for internal REST API services.
Summer Intern
USAA
05.2015 - 08.2015
- IT Technical Intern developed a ETL solution for property and casualty claims data.
Education
Bachelor of Arts - Psychology
Abilene Christian University
Abilene, TX01.2017
Bachelor of Science - Information Technology
Abilene Christian University
Abilene, TX01.2017
Skills
- ETL/ELT Development
- Data Build Tool (DBT)
- Snowflake
- SQL & Databases
- Performance Tuning
- ETL tools - Informatica, Talend,
- Data Orchestration, Data Warehousing, Data Modeling, Data Governance
- Data Security, Data Migration, Data Curation
- Gitlab/Github
- CI/CD (Gitlab/Jenkins)
- Control-M & Autosys,
- AWS Services (Glue, Aurora, ect)
- Scripting Languages (Bash, Python, Jinja)
- Linux CLI / Vim / Shell
- Leadership & Mentorship
Accomplishments
- Snowflake Snowpro Core certified
- AWS Cloud Certified Cloud Practitioner certified
Timeline
Data Engineer
Travelers Indemnity Co
08.2023 - Current
Data Engineer I
USAA
08.2022 - 08.2023
Data Engineer II
USAA
09.2019 - 08.2022
Data Engineer III
USAA
01.2018 - 08.2019
Summer Intern
USAA
05.2016 - 08.2016
Summer Intern
USAA
05.2015 - 08.2015
Bachelor of Arts - Psychology
Abilene Christian University
Bachelor of Science - Information Technology
Abilene Christian University
Similar Profiles
Kathleen WilhelmKathleen Wilhelm
Regional Director at Travelers Indemnity CompanyRegional Director at Travelers Indemnity Company
SHANQUAE LEWISSHANQUAE LEWIS
Licensed Insurance Agent at AAA - Auto Club IndemnityLicensed Insurance Agent at AAA - Auto Club Indemnity
Bianca A. Santos HuertasBianca A. Santos Huertas
Accounting Clerk at United indemnity insurance companyAccounting Clerk at United indemnity insurance company