Gediwon Ashagrie, Developer in Germantown, MD, United States
Gediwon is available for hire
Hire Gediwon

Gediwon Ashagrie

Data Engineer and Database Developer

Germantown, MD, United States

Toptal member since September 2, 2024

Bio

Gediwon brings over seven years of expertise in database design, modeling, and maintenance, making impactful contributions to prominent organizations, including Adventist Health, Chase, CenturyLink, and Irving Holdings. A seasoned developer proficient in SQL Server and Power BI, he excels at turning complex data into actionable insights. Gediwon's expertise extends to data warehousing, ETL processes, and the creation of visually compelling dashboards and optimized database solutions.

Portfolio

OhioGuidestone - Main
Microsoft Fabric, Microsoft Power BI, Data Warehousing...
MinusOne, Inc
SQL, Databricks, Data Modeling, Big Data Architecture, SQL Performance, ETL...
Cable One, Inc - Data
Azure Databricks, Microsoft Power BI, Microsoft Fabric, Fabric Lakehouse...

Experience

  • SQL Server 2019 - 7 years
  • SQL Server Integration Services (SSIS) - 7 years
  • Azure Data Factory (ADF) - 7 years
  • SQL Server Reporting Services (SSRS) - 7 years
  • Azure Synapse Analytics - 7 years
  • Microsoft Power BI - 7 years
  • Tableau - 5 years
  • Microsoft Fabric - 3 years

Preferred Environment

SQL Server 2019, SQL Server 2007, SQL Server 2016, Microsoft Power BI, Tableau, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Azure Synapse Analytics, Azure Data Factory (ADF), Snowflake

The most amazing...

...thing I've done is optimize database performance by creating indexes and conducting regular query tuning, improving data retrieval times by 40%.

Work Experience

Microsoft Fabric Consultant

2025 - 2026
OhioGuidestone - Main
  • Designed and implemented data pipelines in Microsoft Fabric using Pipelines, Dataflows Gen2, and Notebooks to ingest and transform data from APIs, databases, and external systems.
  • Built and maintained data models and medallion architecture (Bronze, Silver, Gold) to support scalable analytics, reporting, and Power BI semantic models.
  • Managed deployment pipelines and environment promotion (Dev → Test → Prod) to ensure reliable releases, version control, and governance of Fabric assets.
  • Mentored and supported team members on Fabric best practices, data engineering patterns, and pipeline development while assisting with troubleshooting and knowledge sharing.
  • Acted as a data platform advocate, promoting modern data practices, performance optimization, and secure data access across teams and business stakeholders.
Technologies: Microsoft Fabric, Microsoft Power BI, Data Warehousing, Business Intelligence (BI), Key Performance Indicators (KPIs), Reporting, Trend Analysis

Senior Data Engineer

2025 - 2025
MinusOne, Inc
  • Applied star schema and dimensional modeling concepts to structure datasets for analytics, helping align legacy data with the new source model and supporting scalable reporting.
  • Analyzed legacy datasets and mapped them to the new schema, identifying corresponding columns and documenting gaps for Jira tickets when fields were missing or required clarification.
  • Built and supported ELT pipelines in the Databricks environment using SQL to transform and integrate data across staging and analytical layers.
Technologies: SQL, Databricks, Data Modeling, Big Data Architecture, SQL Performance, ETL, Cost Reduction & Optimization (Cost-down), Performance Optimization, Python, Dashboards, Delta Lake, Database Schema Design, Data Architecture, Key Performance Indicators (KPIs), Reporting, Trend Analysis

Power BI Report Developer

2025 - 2025
Cable One, Inc - Data
  • Created and maintained Microsoft Fabric Dataflow Gen2 datasets, combining billing data from multiple sources to support enterprise reporting.
  • Developed semantic models and implemented data transformation logic using Power Query and M language to prepare curated datasets for reporting.
  • Ingested data from Snowflake into Azure Databricks, enabling seamless integration of external cloud data sources into the analytics pipeline.
  • Created views and Common Table Expressions (CTEs) in Microsoft Fabric Data Warehouse to support curated datasets and efficient reporting.
  • Prepared clear, step-by-step documentation for Dataflow Gen2 processes, including transformation logic and data validation steps.
  • Modeled and landed data from Bronze to Silver layers in Azure Databricks, applying business rules and transformations to prepare clean, analytics-ready data.
Technologies: Azure Databricks, Microsoft Power BI, Microsoft Fabric, Fabric Lakehouse, Power Query M, PySpark, Data Transformation, Databases, Artificial Intelligence (AI), Microsoft Excel, Spark, Data Pipelines, Spark SQL, Azure Analysis Services, Azure SQL, Data Engineering, Data Cleaning, ETL Tools, Data Cleansing, ETL Pipelines, Data Analysis, Reporting, Azure Service Fabric, Data Lakehouse, Data Lake Design, CI/CD Pipelines, Data Warehousing, SharePoint, Role-based Access Control (RBAC), Data Reporting, Data Fabric, Data Architecture, Database Schema Design, Delta Lake, SQL Performance, Stored Procedure, Data Governance, Key Performance Indicators (KPIs), Reporting, Trend Analysis

SQL and Power BI Developer

2021 - 2024
Adventist Health
  • Created and maintained robust database schemas in SQL Server 2019.
  • Designed and implemented ETL processes using Azure Data Factory and SQL Server Integration Services (SSIS), streamlining data migration and transformation and increasing data processing efficiency by 15%.
  • Optimized database performance by creating indexes and conducting regular query tuning, resulting in a 40% improvement in data retrieval times.
  • Analyzed and translated complex business requirements into actionable insights by designing, developing, and deploying Power BI reports and dashboards, enhancing decision-making processes.
  • Developed complex Data Analysis Expressions (DAX) functions and performed advanced calculations, contributing to data models that supported business needs and improved report accuracy by 20%.
  • Integrated Power BI reports with existing applications using embedded analytics, enabling seamless data analysis and reporting across the organization.
  • Led a modernization initiative migrating dashboards from Tableau and Qlik to Power BI, and established Power BI development standards and best practices.
  • Built and optimized semantic models using star schema, improved performance with refined DAX calculations and Performance Analyzer, and implemented transformations using Power Query and Dataflow Gen2 (Microsoft Fabric).
  • Developed interactive, executive-ready reports with dynamic measures, bookmarks, and advanced navigation, and can demonstrate these solutions during an interview.
Technologies: Azure Data Factory (ADF), Microsoft Power BI, Azure Synapse Analytics, SQL Server 2019, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, SQL Server 2016, Data Modeling, Azure Databricks, Azure, DAX, Microsoft Fabric, ETL, Data Visualization, Dashboards, API Integration, Data Engineering, Microsoft SQL Server, APIs, Data Analytics, Ruby, Data Migration, Dashboard Design, Data Processing, Fabric, Azure Data Lake, Azure SQL Databases, Microsoft Data Transformation Services (now SSIS), SQL Server Analysis Services (SSAS), BigQuery, Excel 365, Business Intelligence (BI), Python, Microsoft Power Automate, Databricks, Tableau Embedded Analytics, Power BI REST APIs, GitHub Actions, Data Conversion, Fabric Lakehouse, Power Query M, PySpark, Data Transformation, Databases, Artificial Intelligence (AI), Microsoft Excel, Spark, Data Pipelines, Spark SQL, Azure Analysis Services, Azure SQL, Data Cleaning, ETL Tools, Data Cleansing, ETL Pipelines, Amazon EC2, Data Analysis, Reporting, Azure Service Fabric, Data Lakehouse, Data Lake Design, CI/CD Pipelines, Data Warehousing, SharePoint, Git, Role-based Access Control (RBAC), Data Reporting, Data Fabric, Data Architecture, Database Schema Design, Delta Lake, SQL Performance, Looker, Data Build Tool (dbt), Stored Procedure, Data Governance, Key Performance Indicators (KPIs), Reporting, Trend Analysis

SQL and Power BI Developer

2019 - 2021
Chase
  • Designed and implemented complex stored procedures, triggers, functions, and views, optimizing database performance and reducing query execution time by 30%.
  • Developed ETL processes and SSIS packages to streamline data integration from multiple sources, enhancing data consistency and reducing manual intervention.
  • Managed and optimized database performance using tools like Microsoft SQL Server Profiler and index tuning wizard, significantly reducing execution times for complex queries.
  • Designed online analytical processing (OLAP) systems using Erwin, supporting data warehousing initiatives and improving data accessibility.
  • Created interactive dashboards and reports using Power BI, providing key stakeholders with real-time insights and driving data-driven decision-making across the organization.
Technologies: Azure Data Factory (ADF), Microsoft Power BI, SQL Server 2016, SQL Server Integration Services (SSIS), Azure Synapse Analytics, Data Modeling, Azure Databricks, Azure, DevOps, Python, DAX, ETL, Data Visualization, Dashboards, API Integration, Data Engineering, Looker, Looker Studio, Microsoft SQL Server, Data Analytics, Amazon Redshift, Ruby, Data Migration, Dashboard Design, Data Processing, Fabric, Azure Data Lake, Azure SQL Databases, Microsoft Data Transformation Services (now SSIS), SQL Server Analysis Services (SSAS), BigQuery, Excel 365, Business Intelligence (BI), Microsoft Power Automate, Tableau, Tableau Embedded Analytics, Customer Data Platform (CDP), Power BI REST APIs, MySQL, Amazon Aurora, Data Conversion, Power Query M, Data Transformation, Databases, Microsoft Excel, Spark, Data Pipelines, Spark SQL, Azure Analysis Services, Azure SQL, Data Cleaning, ETL Tools, Data Cleansing, ETL Pipelines, AWS Lambda, Amazon EC2, Data Analysis, Reporting, CI/CD Pipelines, AWS Glue, Data Warehousing, SharePoint, Git, Role-based Access Control (RBAC), Data Reporting, Data Architecture, Database Schema Design, Delta Lake, SQL Performance, Data Build Tool (dbt), Stored Procedure, Data Governance, Key Performance Indicators (KPIs), Reporting, Trend Analysis

SQL, SSIS, and SSRS Developer

2017 - 2019
CenturyLink
  • Gathered and analyzed business requirements. Led the design and development of SQL Server databases, improving data management and accessibility.
  • Developed and optimized complex SSIS packages to automate data migration and transformation processes, enhancing data flow efficiency by 20%.
  • Designed and deployed SQL Server Reporting Services (SSRS), providing critical business insights and improving reporting accuracy and timeliness.
  • Conducted performance tuning and query optimization, improving database performance and faster report generation.
  • Managed and maintained SQL Server databases by performing regular backups and monitoring to ensure data integrity and availability.
  • Utilized Microsoft SQL Server Profiler and other diagnostic tools to troubleshoot and resolve performance issues, contributing to the stability and reliability of the database environment.
Technologies: SQL Server 2007, Snowflake, SQL Server 2016, Azure Data Factory (ADF), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, Data Modeling, Azure, DevOps, Python, ETL, Data Visualization, Dashboards, API Integration, Looker, Looker Studio, Microsoft SQL Server, APIs, Data Analytics, Data Processing, Azure Data Lake, Azure SQL Databases, Microsoft Data Transformation Services (now SSIS), SQL Server Analysis Services (SSAS), BigQuery, Excel 365, Business Intelligence (BI), Customer Data Platform (CDP), Amazon Web Services (AWS), Data Conversion, Power Query M, Data Transformation, Databases, Microsoft Excel, Data Pipelines, Azure SQL, Data Engineering, Data Cleaning, ETL Tools, Data Cleansing, ETL Pipelines, AWS Lambda, Amazon EC2, Data Analysis, Reporting, CI/CD Pipelines, AWS Glue, Data Warehousing, Git, Data Reporting, Data Architecture, Database Schema Design, Looker, Stored Procedure, Data Governance, Key Performance Indicators (KPIs), Reporting, Trend Analysis

SQL and ETL Developer

2016 - 2017
Irving Holdings
  • Created and optimized SSIS packages for data transfer and transformation, improving data integration processes and reducing errors by 15%.
  • Developed and maintained custom reports using SSRS, providing key business metrics and enhancing decision-making capabilities.
  • Developed T-SQL scripts to automate routine tasks, improving operational efficiency and reducing manual workload by 25%.
  • Implemented database maintenance plans, including regular backups, index optimization, and performance monitoring, ensuring high availability and reliability of the database systems.
  • Participated in designing and implementing database security policies to protect sensitive data and comply with industry standards.
Technologies: SQL Server 2007, SQL Server 2014, Data Modeling, Azure, DevOps, ETL, Microsoft SQL Server, Data Analytics, PostgreSQL, Azure SQL Databases, Microsoft Data Transformation Services (now SSIS), SQL Server Analysis Services (SSAS), BigQuery, Excel 365, Business Intelligence (BI), MySQL, Amazon Web Services (AWS), Data Conversion, Data Transformation, Databases, Data Pipelines, Data Engineering, Data Cleaning, ETL Tools, Data Cleansing, ETL Pipelines, AWS Lambda, Amazon EC2, Data Analysis, Reporting, CI/CD Pipelines, Data Warehousing, Git, Data Reporting, Database Schema Design, SQL Performance, Stored Procedure, Data Governance, Reporting

Experience

Optimizing a Legacy Application

Optimized a legacy application struggling with slow performance and scalability issues. I significantly improved the application's efficiency by redesigning the database structure and implementing advanced optimization techniques. Additionally, I enhanced its functionality to handle increased data loads and meet modern performance standards.

Education

2011 - 2014

Bachelor's Degree in Social Anthropology

Addis Ababa University - Addis Ababa, Ethiopia

Skills

Libraries/APIs

Power BI REST APIs, PySpark, Fabric

Tools

Microsoft Power BI, Tableau, SSAS, BigQuery, Tableau Embedded Analytics, Microsoft Excel, Spark SQL, AWS Glue, Git, Looker

Languages

SQL, Python, Power Query M, Stored Procedure, Snowflake, Ruby

Frameworks

Data Lakehouse, Spark, Data Fabric

Paradigms

ETL, Business Intelligence (BI), Role-based Access Control (RBAC), DevOps

Platforms

Azure Synapse Analytics, Azure, Microsoft Fabric, Microsoft Power Automate, Databricks, Amazon Web Services (AWS), Fabric Lakehouse, AWS Lambda, Amazon EC2, Azure Service Fabric, SharePoint

Storage

SQL Server 2019, SQL Server 2007, SQL Server 2016, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server 2014, Microsoft SQL Server, PostgreSQL, SQL Server Analysis Services (SSAS), MySQL, Databases, Data Pipelines, Azure SQL, SQL Performance, Data Lake Design, Azure SQL Databases, Amazon Aurora

Other

Azure Data Factory (ADF), Data Analysis, Data Modeling, Azure Databricks, DAX, Data Visualization, Dashboards, Data Engineering, APIs, Data Analytics, Data Migration, Dashboard Design, Data Processing, Microsoft Data Transformation Services (now SSIS), Excel 365, Customer Data Platform (CDP), Data Conversion, Data Transformation, Azure Analysis Services, Delta Lake, Database Schema Design, Data Architecture, Data Cleaning, ETL Tools, Data Cleansing, ETL Pipelines, Data Analysis, Reporting, CI/CD Pipelines, Data Warehousing, Data Reporting, Looker, Data Build Tool (dbt), Data Governance, Key Performance Indicators (KPIs), Reporting, Trend Analysis, Microsoft Dataverse, API Integration, Looker Studio, Amazon Redshift, Azure Data Lake, GitHub Actions, Artificial Intelligence (AI), Big Data Architecture, Cost Reduction & Optimization (Cost-down), Performance Optimization

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring