Sr. Data Engineer (SSIS) - Remoto en Derevo

At Derevo, we aim to empower companies and individuals to unlock the value of data within organizations through the implementation of analytics processes and platforms, following a full-cycle approach to achieve this goal.

Sr. Data Engineer

The desired candidate should have hands-on experience in designing, establishing, and maintaining data management and storage systems. You should be skilled in collecting, processing, cleaning, and deploying large datasets, understanding ER data models, and integrating with multiple data sources. You must also be proficient in analyzing, communicating, and proposing different approaches for building Data Warehouses, Data Lakes, End-to-End Pipelines, and Big Data solutions for clients, using either batch or streaming strategies.

Requirements for the role:

• At least 5 years of experience working with SSIS.
• Intermediate/Conversational  English.  

Technical Proficiencies:

SQL:

• Data Definition Language (DDL), Data Manipulation Language (DML), Intermediate/Advanced queries for analytical purposes, Subqueries, CTEs (Common Table Expressions), Data types, Joins with applied business rules, Grouping and Aggregates for business metrics, Indexing and optimizing queries for efficient ETL processes, Stored Procedures for transforming and preparing data, SSMS, DBeaver.

SSIS:

• Design and develop ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various source systems into target databases.
• Create, configure, and deploy SSIS packages, including data flow tasks, control flow tasks, and event handlers.
• Perform data source integration from diverse platforms such as relational databases, flat files, web services, and cloud-based storage.
• Optimize data integration processes for performance, identifying and resolving bottlenecks, and following best practices.
• Provide expertise in troubleshooting and resolving data integration issues, ensuring data accuracy and consistency.

What benefits will you get?

WELLNESS : We promote your overall well-being by balancing your personal, professional, and financial aspects. Our legal and additional benefits will help you achieve this.

LET’S RELEASE YOUR POWER : You’ll have the opportunity to specialize in different areas and technologies, allowing you to grow in an interdisciplinary way. We will encourage you to take on new challenges and push yourself beyond limits.

WE CREATE NEW THINGS : We love thinking outside the box. You will have the space, trust, and freedom to create, along with the necessary training to achieve your goals.

WE GROW TOGETHER : You will participate in cutting-edge, multinational technology projects with international teams.

Where will you work?

We are a great team working remotely, offering a flexible but structured environment. We provide the necessary equipment and internal communication tools to facilitate our operation and that of our clients.

If you meet most of the requirements and find this position interesting, don’t hesitate to apply! Our Talent team will get in touch with you! 

Become a Derevian & develop your superpower