Dawit Tesfaye
Washington DC,VA
Summary
Results-driven Data Engineer with 6+ years of experience designing and implementing scalable data pipelines and cloud-based data solutions. Experienced in SQL, APIs, and ETL, SSRS and Power BI with a proven track record of optimizing data workflows for performance and cost-efficiency. Adept at collaborating with cross-functional teams to deliver actionable insights into business growth. Excellent analytical, communication, and interpersonal skills, and a good team player
Engineering professional prepared for this role with strong background in project execution and technical analysis. Proven ability to drive projects to completion through effective collaboration and attention to detail. Known for adaptability and reliability, with expertise in troubleshooting and quality control.
Overview
6
6
years of professional experience
Work History
Associate Engineer L2
Publicis Sapient
11.2023 - Current
- Created database objects (Store procedure, Table) documented developed projects, performed DDL and DML Using T-SQL
- Developed automated reporting Power BI, and published interactive dashboards to Power BI Service, enabling real-time insights for business users
- Accelerated user access to systems and databases using APIs and Jenkins pipelines, achieving same-day provisioning for 50+ users and preventing workflow delays
- Collaborated with the data backend team to implement database changes based on requirements, enhancing overall team productivity
- Modified database objects to meet customer’s requirements
- Served as a subject matter expert providing guidance on engineering best practices throughout the organization during various stages of project development cycles.
- Developed comprehensive training materials for new hires, improving onboarding effectiveness and reducing time spent in training sessions.
ETL Developer/SSRS Developer
Perr&Knight
09.2022 - 10.2023
- Designed, developed, and automated SSIS Packages
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- Deployed scalable solutions capable of handling large volumes of data while maintaining high standards of reliability and performance.
- Extracted, Transformed, and Load the data such as Excel, flats files and XML into staging tables in SQL Server
- Actively participated in team meetings, providing valuable input on potential improvements and innovative solutions for SSRS reporting challenges.
- Implemented role-based security measures within SSRS reports to ensure data integrity and confidentiality during report generation.
- Developed and modified programs to meet customer requirements.
Database Engineer
SCRAM Systems
01.2022 - 10.2022
- Created and updated database designs and data models.
- Modified databases to meet needs and goals determined during planning process.
- Built databases and table structures for web applications.
- Set up and controlled user access levels across databases to protect important data.
- Conducted tests to identify issues and make necessary modifications.
Jr Database Developer
Afrigo Travel
01.2019 - 12.2021
- Created and updated database designs and data models.
- Identified issues within databases, performed troubleshooting and implemented effective solutions.
- Developed and delivered business information solutions.
- Established and secured enterprise-wide data analytics structures.
- Designed data models for complex analysis needs.
Education
Bachelor of Science - Information Technology
Geroge Mason
Fairfax, VASkills
- Languages: SQL, APIs, C#, Python
- Cloud: Snowflake, Azure Data Factory, Synapse Analytics
- Tools: Power BI, Tableau, SSRS
- Databases: SQL
- Other: Git, Bitbucket, Jenkins
- Programming languages
- Requirements analysis
- Technical skills
Timeline
Associate Engineer L2
Publicis Sapient
11.2023 - Current
ETL Developer/SSRS Developer
Perr&Knight
09.2022 - 10.2023
Database Engineer
SCRAM Systems
01.2022 - 10.2022
Jr Database Developer
Afrigo Travel
01.2019 - 12.2021
Bachelor of Science - Information Technology
Geroge Mason
Similar Profiles
Stephanie Patricia Solís RodríguezStephanie Patricia Solís Rodríguez
Finance Manager at Publicis SapientFinance Manager at Publicis Sapient
Dhirendra GohilDhirendra Gohil
Associate Senior Platform Engineer at Publicis SapientAssociate Senior Platform Engineer at Publicis Sapient
Nitinkumar TiwariNitinkumar Tiwari
Agile Project Manager at Publicis SapientAgile Project Manager at Publicis Sapient