SQL & ETL Data Engineer
Resume:
HENOK TEREFE
Data Engineer
Seattle, Washington, United States
*****.*********@*****.***
SUMMARY
Detail-oriented SQL and Data Engineering professional with expertise in database administration, SQL development, data pipeline optimization, and business intelligence solutions. Experienced in managing SQL Server and Azure-based database environments, developing scalable data solutions, and supporting analytics through efficient data integration, ETL/ELT processes, and performance tuning. Proficient in T-SQL, data modeling, automation, and transforming complex datasets into actionable insights using BI tools such as Tableau and Microsoft Power BI. Proven ability to improve operational efficiency, troubleshoot complex data issues, and collaborate cross-functionally to deliver reliable, data-driven solutions in fast-paced environments.
WORK EXPERIENCE
August 2023-Current
Data Engineer
RDT Solution LLC
United States
Developed and optimized scalable data pipelines using SQL, Python, and ETL/ELT frameworks to support high- volume data ingestion, transformation, and storage for analytics workloads. Designed efficient data models and transformation logic to improve data quality, consistency, and performance across enterprise reporting systems. Automated recurring data workflows and database operations through scheduling and orchestration tools, reducing manual effort and improving operational reliability. Performed data migration, validation, and reconciliation across legacy and cloud-based environments, ensuring seamless system integration and data accuracy. Optimized large-scale SQL query performance and data processing workflows, reducing latency and improving data accessibility for business intelligence initiatives. Partnered with stakeholders to translate business requirements into scalable data engineering solutions, supporting enterprise analytics and reporting objectives.
October 2020-July 2023
Data Engineer
PayScale
United States
Managed SQL Server on Azure VM and Azure SQL environments, ensuring high availability, performance optimization, scalability, and secure access to enterprise data systems supporting reporting and analytics initiatives. Designed and implemented resilient database and data processing solutions, enabling scalable data ingestion, transformation, and storage to support enterprise reporting, analytics, and business intelligence requirements. Developed and optimized stored procedures, views, user-defined functions (UDFs), and triggers to improve data transformation efficiency, automate workflows, and support downstream reporting and dashboarding needs. Created and maintained T-SQL scripts, DDL, and DML operations for data extraction, transformation, validation, and reporting, ensuring accurate and timely delivery of business-critical datasets. Used SSRS to create and maintain paginated reports, KPI dashboards, and automated reporting solutions. I developed datasets using SQL queries and stored procedures, built parameterized reports, implemented drill- down functionality, optimized report performance, and configured subscriptions for scheduled report delivery in PDF and Excel formats. Built and maintained interactive dashboards, KPI reports, data visualizations, and automated reporting solutions using Tableau and Microsoft Power BI to improve data visibility and enable data-driven decision-making. Collaborated with stakeholders to gather business requirements and transform complex datasets into actionable insights through Tableau and Power BI dashboards, improving reporting efficiency and operational transparency. Supported ETL/ELT processes and data pipeline operations, ensuring reliable movement of data across operational databases, reporting systems, and analytical environments. Managed database backup, restore, and environment refresh activities across production and non-production systems, ensuring business continuity, disaster recovery readiness, and data integrity. Collaborated with development, analytics, and business teams to troubleshoot data quality issues, schema changes, bug fixes, and feature testing, improving overall system reliability and reporting accuracy. June 2018-February 2020
Database Administrator
BTS Boston Transportation Service LLC
Boston, Massachusetts, United States
Administered and configured SQL Server environments, including installation, setup, and ongoing optimization of 4 SQL Server instances to support scalable and reliable database operations. Monitored and optimized database performance, availability, and health, implementing preventive maintenance, troubleshooting, and performance enhancements to ensure operational continuity. Developed and maintained interactive dashboards, reports, and visual analytics solutions to improve data accessibility and support business intelligence initiatives. Designed and implemented databases, schemas, and 25+ relational tables aligned with business requirements, supporting efficient data storage, retrieval, and reporting capabilities. Partnered with business users and technical teams to deliver data-driven reporting solutions and database enhancements, improving reporting efficiency and data usability. March 2017-August 2018
Business Intelligence Analyst
LogixHealth
United States
Engineered and maintained business intelligence dashboards, KPI reporting, automated alerts, and subscription- based reporting solutions using Tableau to enhance enterprise-wide data accessibility and reporting efficiency. Delivered 18+ custom dashboards and analytical reports, partnering with stakeholders to translate business requirements into scalable reporting and visualization solutions. Automated ETL workflows using SQL Server Integration Services (SSIS), streamlining data processing, transformation, and integration across multiple systems. Provided production support and issue resolution for development teams, proactively troubleshooting data, reporting, and application-related issues to maintain system performance and uptime. Supported data operations and reporting infrastructure, ensuring data accuracy, reliability, and seamless access to critical business information. September 2014-February 2017
BI/Data Analyst
Blue Nile LLC.
United States
Created visualizations for logistics calculations and department spend analysis to support strategic decision-making Collected, collated, and analyzed data to fulfill management and customer requests, enhancing data-driven insights Utilized SQL, Access, Excel, Tableau, and Visio to access data, write queries, run reports, and analyze large datasets, ensuring alignment with management requirements
September 2011-August 2014
Data Review Supervisor
Granite Telecommunication LLC.
United States
Managed payroll for eight employees using Automated Data Processing Software to ensure accurate and timely compensation. Administered Paid Time Off, Family and Medical Leave, and sick time for employees to support workforce needs. Trained Temporary to Permanent employees on different carriers’ policies and procedures. Maintained Paid Time Off, Family and Medical leave and sick time of employees. EDUCATION
2013-2016
Information Technology – Business Intelligence Concentration
University of Massachusetts Boston
Boston, Massachusetts, United States
Bachelors of Science
SKILLS
SQL (Structured Query Language) Python Programming/Scripting Language Database Extract Transform and Load (ETL) Data Modeling Automation Data Management Microsoft Transact-SQL (T-SQL) Microsoft SQL Server Microsoft Windows Azure Atlassian JIRA Business Intelligence Tableau Microsoft Product Family SQL Server Integration Services (SSIS) Microsoft Access Database Microsoft Excel Microsoft Visio Java Performance Tuning/Optimization Information/Data Security (InfoSec) Database Backup Data Visualization Microsoft Office Data Migration Data Sets Programming Methodologies Scripting (Scripting Languages) Refactoring Database Administration Analysis Skills Production Support Performance Metrics Data Processing Reporting Dashboards Time Management Problem Solving Skills Server Programming/Applications Operational Support Stored Procedures On Call Production Systems Data Description Language (DDL) Virtual Machine (VM) Data Recovery Systems Administration/Management Procedure Development Identify Issues Microsoft SQL Server DBA (Database Administration) Data Analysis Logistics Expense Analysis Decision Support Operations Processes Operational Improvement Database Design Query Optimization Dimensional Modeling Amazon Web Services (AWS) Enterprise Data Integration Data Warehousing Extraction/Transformation Software Git Data Quality Business Intelligence Software Unix Shell Programming High Availability Disaster Recovery Cloud Computing Reconciliation Requirements Management System Integration (SI) Reliability Engineering Quality Management Scalable System Development Performance Analysis Risk Root Cause Analysis Service Level Agreement (SLA) Testing Systems Maintenance Maintain Compliance Systems Analysis Business Processes Performance Management Business Support Usability Engineering Reporting Skills Data Storage Database Technology Technical Delivery Server Support Operations Planning Database Optimization Systems Reliability Operational Strategy Power BI Medical Treatment Payroll Management Preventative Maintenance Preventive Medicine Training Data Sets Cross-Functional Detail Oriented Process Improvement Business Solutions Database Programming Sales Pipeline Customer Support/Service Information Technology & Information Systems SQL Server Reporting Services (SSRS) Adobe Acrobat
LANGUAGES
English - Intermediate
Contact this candidate