Position: Data Engineer
Category: Data Engineer
English level: upper
Years of experience: 3

- Developed and optimized ETL pipelines using Azure Data Factory to efficiently ingest and transform data from multiple sources, improving overall processing speed and accuracy. 
- Implemented Slowly Changing Dimensions (SCD) approach for key dimensions, ensuring data consistency and historical tracking. 
- Enhanced data warehouse architecture by refining data models, adding new dimensions and fact tables, and streamlining existing tables to improve reporting and analytics capabilities. 
- Collaborated with cross-functional teams to identify and resolve data-related issues, providing support and guidance on data engineering best practices. 
- Designed and implemented data validation and error handling mechanisms, including logging and metadata tracking, to ensure data quality and maintainability. 
- Conducted performance analysis and optimization of stored procedures and ETL processes to improve query execution times and overall system performance. 
- Implemented and maintained Power BI dataset refresh processes, ensuring timely and accurate availability of data for reporting and analytics purposes. 
- Assisted in the migration of historical data from Excel to the data warehouse, developing data pipelines and table structures to accommodate the new data sources. 
- Contributed to the creation of onboarding and technical documentation, facilitating knowledge transfer and team collaboration. 
- Onboarded a Data Engineer from the client's team into our development process, responsible for reviewing her first onboarding tasks.
A highly skilled and experienced Data Engineer with a strong background in MS SQL, Azure, DWH, and ETL, seeking a challenging position to leverage my expertise in data engineering, data warehousing, and 
cloud technologies to deliver innovative solutions and contribute to the growth and success of a forward thinking organization.

Skills
Databases: MS SQL Server, Azure SQL Database
ETL Tools: Azure Data Factory, SSIS
Data Warehousing: Star Schema, Snowflake Schema, SCD, Kimbal approach
Cloud Services: Azure DevOps, Azure Blob Storage, Azure Key Vault, Snowflake
Languages: SQL, T-SQL, Python
Data Modeling: ER Diagrams, Dimentional Modeling
Reporting & Visualization: Power BI
Tools: Git, Idea, Visual Studio, Jira
Methodologies: Agile, Scrum, Kanban

My strong skills are responsibility, reliability, tolerance, sociability and patience. I am definitely a team player.