ETL Engineer

We are currently seeking an ETL developer to design and implement ETL processes. You will build ETL pipelines to ingest the data from heterogeneous sources into our system. You should have excellent business and communication skills, and be able to work with business owners, developers, and data engineers to understand requirements and make data-related decisions using your ETL knowledge and experience.

This role will require you to learn new tools and technologies quickly, and you should have in-depth database knowledge as well as basic programming skills. You will help to build efficient and stable data pipelines which can be easily maintained in the future. You should have expertise in the design, creation, management, and business use of large datasets.

Responsibilities

- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities

- Gather requirements and business process knowledge in order to transform external data into destination formats that support our applications

- Maintain and improve already existing processes

- Ensure that the data architecture is scalable and maintainable

- Work with the business in designing and delivering correct, high quality data

- Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions

- Prepare documentation for further reference

- 4+ years of ETL experience

- Bachelor's degree in Computer Science preferred

- SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure

- Knowledge of data modeling principles

- Organizational skills: time management and planning

- Knowledge of at least one ETL tool (SSIS, Informatica, Talend, etc.)

- Familiarity with Microsoft technologies, including .Net and C#, MS SQL Server

- Familiarity with Azure, Azure SQL, Synapse, Azure Data Factory

- Snowflake experience a plus

- Knowledge of various SQL/NoSQL data storage mechanisms and Big Data technologies

- High attention to detail

- Passionate about complex data structures and problem solving

- Ability to pick up new data tools and concepts quickly