Andy Merrick
La Pine,OR
Summary
Accomplished Data Engineer with expertise in SQL, data pipeline, and ETL development. Proven track record in automating data quality assurance processes, resulting in improved data integrity and operational efficiency. Adept at delivering innovative data solutions that enhance business outcomes and drive strategic objectives.
Overview
24
24
years of professional experience
Work History
Data Engineer
SAIF
Salem, OR
01.2018 - Current
- Worked as part of project teams to coordinate database development and determine project scopes and limitations.
- Managed version control and deployment of data applications using Git, ADO, DBT, and many others.
- Automated data quality checks and error handling processes to ensure the integrity and reliability of datasets.
- Optimized existing queries to improve query performance by examining execution plans, managing effective indexes, and rewriting queries with more efficient predicates and clauses.
- Streamlined data flow from diverse sources using ETL tools such as SSIS, Fivetran, dbt, and Airflow.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
- Designed and developed ETL processes to load enterprise data into the Data Warehouse, and the Data Lake.
- Helped configure cloud-based data lake infrastructure on platforms such as AWS, Azure, and Databricks to enhance data storage and computation capabilities.
- Collaborated with data scientists, analysts, and engineers to understand data needs and implement appropriate data models, structures, and efficient solutions.
- Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.
Data Engineer
Salem Keizer School District
Salem, OR
05.2001 - 11.2017
Education
Some College (No Degree) - Electrical Engineering
Portland State University
Portland, ORSkills
- Data pipeline development
- Data quality assurance
- Performance tuning
- Problem solving
- ETL development
- PL/SQL/TSQL/MYSQL Programming
- Data security
- SQL expertise
- Teamwork and collaboration
- Professionalism
Timeline
Data Engineer
SAIF
01.2018 - Current
Data Engineer
Salem Keizer School District
05.2001 - 11.2017
Some College (No Degree) - Electrical Engineering
Portland State University
Similar Profiles
Khalid KharoufKhalid Kharouf
Online Store Manager at Al Saif Trading Agencies CoOnline Store Manager at Al Saif Trading Agencies Co
Abdulmajeed AlharbiAbdulmajeed Alharbi
Security Officer at Saif PIF CompanySecurity Officer at Saif PIF Company
Muhammad WaseemMuhammad Waseem
Light Vehicle Driver at Al Saif TransportLight Vehicle Driver at Al Saif Transport
Cheyenne MarshallCheyenne Marshall
Sales Associate & Social Media Marketer at I-5 SportsSales Associate & Social Media Marketer at I-5 Sports
Josh BlachlyJosh Blachly
Operations Reliability Coordinator at WeyerhaeuserOperations Reliability Coordinator at Weyerhaeuser