
Gediwon Ashagrie
Verified Expert in Engineering
Data Engineer and Database Developer
Germantown, MD, United States
Toptal member since September 2, 2024
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
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
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.
Senior Data Engineer
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.
Power BI Report Developer
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.
SQL and Power BI Developer
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.
SQL and Power BI Developer
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.
SQL, SSIS, and SSRS Developer
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.
SQL and ETL Developer
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.
Experience
Optimizing a Legacy Application
Education
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring