Available to hire
Hi, I’m Endalkachew Yidenakal, a certified Data Engineer / ETL, SQL & BI Engineer with hands-on experience across federal and healthcare projects. I specialize in SQL Server, SSIS, Power BI, and data integration, designing robust ETL pipelines, building scalable data models, and delivering dashboards that turn raw data into actionable insights.
I’ve supported U.S. federal agencies (USDA, CFTC, Treasury/OCC) and healthcare organizations (BCBS) and hold an active Public Trust clearance. I’m a U.S. citizen able to work anywhere in the United States and open to relocation. I enjoy collaborating with cross-functional teams to translate business needs into reliable data solutions and impactful analytics.
Skills
Language
English
Fluent
Work Experience
SQL Data Engineer at U.S. Department of Agriculture (USDA)
May 1, 2025 - October 13, 2025Built and maintained ETL pipelines with SQL Server and SSIS to consolidate data from multiple systems for analytics and reporting. Created T-SQL stored procedures, functions, and scripts to support financial reporting, regulatory compliance, and BI dashboards. Modeled data for a financial data migration, validated ETL workflows, and ensured smooth transfer of historical datasets. Automated recurring data processing with SQL jobs and scripts, reducing report generation time. Collaborated with BI teams to deliver SSRS and Tableau reports, providing operational and financial insights to executives and staff. Tuned query performance, indexing, and schema design for scalability and high-volume workloads. Implemented RBAC and auditing for sensitive data. Explored cloud-readiness for AWS S3/RDS and documented options for migrating legacy workloads.
ETL Developer at U.S. Commodity Futures & Holding (CFTC)
April 1, 2021 - October 13, 2025Designed and developed data ingestion workflows with SQL Server and SSIS, moving large datasets into enterprise databases for regulatory and business analysis. Built ETL pipelines with data quality checks for compliance reporting and internal dashboards. Optimized SQL Server databases, stored procedures, and functions to improve data integration. Created and deployed SSIS packages to handle high-volume migrations (tens of millions of rows). Gathered requirements with analysts and business users and translated them into reporting and data integration solutions. Designed dimensional data models (star/snowflake) to support dashboards. Participated in POC for modern ETL orchestration (Airflow, dbt) to complement SSIS. Delivered SSRS reports and SQL-based extracts for compliance. Improved query performance with tuning and indexing. Engaged with compliance and QA to ensure data solutions meet federal standards and audit requirements. Began exploring cloud migrations for on-prem datasets to A
ETL / BI Developer | SQL & Power BI at U.S. Department of the Treasury / OCC
September 1, 2019 - October 13, 2025Designed and developed SQL Server–based data warehouses and data marts to support enterprise reporting and analytics. Built and optimized stored procedures, views, triggers, indexes, and functions to enforce business rules and support batch and near real-time processing. Developed ETL/ELT pipelines with SSIS to extract, transform, and load data across multiple systems, ensuring accuracy and consistency. Delivered Power BI dashboards and SSRS reports for executives and operations teams, turning raw data into actionable insights. Automated report generation and data refresh processes to reduce manual workload and improve timeliness of reporting. Managed database administration tasks including user accounts, security permissions, backups, and data migrations. Partnered with business users to define requirements and delivered custom SQL queries, data extracts, and BI solutions. Conducted performance tuning and query optimization, ensuring databases handled heavy workloads efficiently. Pa
Business Intelligence Engineer at BCBS
August 1, 2018 - October 13, 2025Assisted in building Power BI and SSRS reports that helped business teams track claims, member data, and operational performance. Wrote SQL queries to pull data from multiple sources and prepare it for reporting and analysis. Helped maintain data models and dashboards, ensuring information was accurate and up to date. Worked with senior developers to troubleshoot data quality issues and apply fixes in SQL Server databases. Created basic ETL workflows in SSIS to automate routine data loading and transformation tasks. Supported database administration tasks such as monitoring jobs, managing user access, and running scheduled reports. Collaborated with analysts and business users to gather reporting requirements and translate them into simple BI solutions.
SQL Data Engineer at U.S. Department of Agriculture (USDA)
May 1, 2025 - October 15, 2025Built and maintained ETL pipelines with SQL Server and SSIS to consolidate data from multiple systems for analytics and reporting. Developed T-SQL procedures, functions, and scripts to support financial reporting, regulatory compliance, and BI dashboards. Led a financial data migration, modeling data, validating ETL workflows, and ensuring successful transfer of historical datasets. Automated recurring data processing with SQL jobs and scripts to reduce report generation time. Collaborated with BI teams to deliver SSRS and Tableau dashboards.
ETL Developer at U.S. Commodity Futures & Holding (CFTC)
April 1, 2021 - October 15, 2025Designed and developed data ingestion workflows with SQL Server and SSIS to move large datasets into enterprise databases for regulatory and business analysis. Built ETL pipelines and data validation logic to ensure accurate data for compliance reporting and internal dashboards. Developed and optimized SQL Server databases, stored procedures, and functions. Created and deployed SSIS packages to handle high-volume migrations (tens of millions of rows).
ETL / BI Developer | SQL & Power BI at U.S. Department of the Treasury / OCC
September 1, 2019 - October 15, 2025Designed and developed SQL Server–based data warehouses and data marts to support enterprise reporting and analytics. Built and optimized stored procedures, views, triggers, indexes, and functions. Developed ETL/ELT pipelines with SSIS to extract, transform, and load data across multiple systems. Delivered Power BI dashboards and SSRS reports for executives and operations teams. Automated report generation and data refresh processes and managed database administration tasks.
Business Intelligence Engineer at BCBS
August 1, 2018 - October 15, 2025Assisted in building Power BI and SSRS reports tracking claims, member data, and operational performance. Wrote SQL queries to pull data from multiple sources and prepared data for reporting and analysis. Maintained data models and dashboards, ensured accuracy, and collaborated with analysts to meet reporting requirements. Created basic ETL workflows in SSIS to automate routine data loading and transformations.
Education
Bachelor of Arts in Accounting at University of The District of Columbia
January 11, 2030 - October 13, 2025Bachelor of Arts in Accounting at University of The District of Columbia
January 11, 2030 - October 15, 2025Qualifications
Microsoft Technology Specialist Certificate: Microsoft® SQL Server ™ 2008 - Implementation and Maintenance
January 11, 2030 - October 13, 2025Python Certificate | Montgomery College
January 11, 2030 - October 13, 2025Tableau Level I and II Certification | Montgomery College
January 11, 2030 - October 13, 2025Microsoft Technology SQL SERVER 2008 and 2012 Database Administration - Training | Duna LLC
January 11, 2030 - October 13, 2025Relational Database Design, Development, and Implementation — Training | Duna LLC
January 11, 2030 - October 13, 2025Microsoft Technology Specialist Certificate: Microsoft SQL Server 2008 - Implementation and Maintenance
January 11, 2030 - October 15, 2025Python Certificate | Montgomery College
January 11, 2030 - October 15, 2025Tableau Level I and II Certification | Montgomery College
January 11, 2030 - October 15, 2025Microsoft Technology SQL SERVER 2008 and 2012 Database Administration - Training | Duna LLC
January 11, 2030 - October 15, 2025Relational Database Design, Development, and Implementation — Training | Duna LLC
January 11, 2030 - October 15, 2025Industry Experience
Government, Healthcare, Professional Services, Financial Services, Software & Internet, Education
Skills
Hire a Data Analyst
We have the best data analyst experts on Twine. Hire a data analyst in Silver Spring today.