Yohannes Sharew

About Yohannes Sharew

Strategic and results-driven Data Engineer & BI Developer with over 7 years of experience in building robust data infrastructure, streamlining ETL pipelines, and developing enterprise-grade reporting solutions across banking, insurance, and financial services. Adept at designing scalable data models, modernizing data platforms, and delivering actionable insights that empower leadership decision-making.Expert in SQL Server, Azure Synapse, Snowflake, Databricks, and Power BI, with hands-on experience in cloud-native tools like ADF, Alteryx, and Azure Monitor. I bring a strong command of Python (Pandas, NumPy) for data validation, automation, and advanced transformation logic.From building metadata-driven ETL frameworks and dynamic Power BI dashboards to enforcing data governance and optimizing performance, I drive end-to-end data solutions that are efficient, compliant, and business-aligned. I thrive in Agile/Scrum environments and collaborate cross-functionally with data scientists, analysts, and stakeholders to accelerate time to insights. Looking to connect with data-focused teams seeking a passionate engineer who blends deep technical skills with a sharp business acumen.

Experience

1. Data Analyst Data Engineer

   TD

   Jul 2022 — Present

   Designed and developed complex T-SQL scripts, creating and maintaining database objects such as Tables, Views, Stored Procedures, Triggers, Functions, Indexes, and Cursors to support scalable data solutions.• Led data conversion efforts by extracting, transforming, and loading (ETL) structured and semi-structured data from diverse sources (CSV, Excel, Oracle, SQL Server) into enterprise data warehouses using SSIS and Azure Data Factory.• Designed robust data models using Star and Snowflake schemas, enabling high-performance analytics and aligning with data governance standards across business domains.• Developed and optimized complex T-SQL scripts, including dynamic SQL, CTEs, window functions, and stored procedures to support reusable and scalable data transformations.• Created and deployed ETL pipelines integrating advanced SSIS components (Lookup, Merge Join, Conditional Split, SCD, Fuzzy Lookup) to ensure data accuracy and consistency during migration.• Built data validation and reconciliation frameworks, including SSIS-based checks and stored procedure-based exception handling, enabling business teams to verify post-migration data integrity.• Collaborated with cross-functional teams to capture data mapping requirements, resolve transformation discrepancies, and ensure smooth data loading into Azure Synapse Analytics.• Performed data profiling and cleansing using Alteryx Designer, improving data quality before ingestion and migration to cloud platforms.• Delivered conversion testing and QA support by comparing pre- and post-migration datasets, documenting test results, and resolving defects with engineering teams.• Created interactive Power BI dashboards and reports integrating data from SQL Server and Azure Synapse to monitor conversion status and communicate progress with business stakeholders.• Ensured high availability and fault tolerance of data pipelines by implementing monitoring, alerting, and logging mechanisms across SSIS and ADF processes.

Education

• Dilla University

  Bachelor's degree, Computer Science