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

Optimizing ETL Processes: I led an initiative at Pasha Insurance to optimize ETL processes, resulting in a 30% reduction in data processing time. By fine-tuning SQL queries and introducing parallel processing techniques, I significantly enhanced the efficiency of data ingestion and transformation.

Data Pipeline Scalability: At Agile Solutions, I played a pivotal role in designing a scalable data pipeline architecture for a high-velocity data stream. This architecture allowed us to handle a 50% increase in data volume while maintaining performance, ensuring uninterrupted data flow for critical business operations.

Cross-Functional Collaboration: As part of the IFRS 17 project, I collaborated closely with actuaries and financial analysts to ensure the accurate representation of insurance contracts in our data systems. This collaboration resulted in compliance with regulatory standards and provided valuable insights for financial reporting.

Technical Mentorship: I've actively mentored junior team members, sharing best practices in data engineering and ETL development. Several team members have progressed in their careers and contributed effectively to our projects, a testament to the impact of mentorship.
In my role as an Data Engineer at Pasha Insurance, I have gained extensive experience in data management and ETL (Extract, Transform, Load) processes. My responsibilities encompass:

Writing complex T-SQL queries, including recursive CTEs, temp tables, dynamic queries, subqueries, and intricate joins for creating Stored Procedures, User-defined Functions, Views, and Cursors.
Implementing robust error and event handling mechanisms, such as precedence constraints, breakpoints, checkpoints, and logging.
Importing/exporting data from various sources (Python files, flat files, Excel) using SSIS/DTS utility.
Utilizing C# within the SSIS script component.
Developing dynamic SSIS packages.
Defining data warehouse structures, including star and snowflake schemas, fact tables, cubes, and dimensions.
Resolving technical and data-related challenges in the IFRS 17 project.
I am an integral part of the team, contributing to the technical aspects of the project and collaborating with colleagues to ensure its success. I continually strive to enhance my skills and aim to improve my expertise in ETL processes, data warehousing, and database management.
Seeking a challenging data engineering role with a focus on complex data transformations, ETL development, and database design, including cloud-based solutions. I value opportunities that allow leadership in designing data warehouses and thrive in dynamic, learning-oriented environments. Prefer roles that minimize administrative tasks to focus on technical contributions.