Data Engineer (T-SQL & SSIS)

OZ; Rosario; Presencial; ARS 40.000 - 70.000; Jornada completa

Descripción de la vacante

A leading company in data solutions is seeking a qualified Data Analytics Consultant with extensive experience in developing data integration solutions. The ideal candidate will possess strong SQL proficiency and analytical skills, enabling seamless data flow across systems and effective support for analytical needs. Responsibilities include maintaining SQL code, optimizing queries, and providing production support. Essential experience with Microsoft BI tools and data governance best practices is desired.

Formación

• +5 years of proven experience in T-SQL.
• Experience with Microsoft BI tools crucial.
• Strong analytical skills and ability to synthesize complex data.

Responsabilidades

• Develop and maintain SQL code and SSIS packages.
• Analyze data to identify trends and deliver insights.
• Provide production-level support for data systems.

Conocimientos

T-SQL

Data Modeling

Data Transformation

ETL/ELT Processes

Data Quality Identification

Data Governance

Fluent in English

Herramientas

Microsoft BI Tool Suite

SQL Server

SSIS

SSAS

SSRS

SSMS

Visual Studio

Descripción del empleo

A qualified Data Analytics Consultant with substantial experience and a proven track record in the development of comprehensive data integration solutions. The ideal candidate will possess a strong proficiency in SQL, coupled with a solid understanding of various Data Integration techniques, including but not limited to ETL (Extract, Transform, Load), Data Replication, and Data Profiling. These skills are essential to effectively address and support the diverse analytical needs of our business, ensuring that data flows seamlessly across systems and is utilized to its fullest potential.

JOB RESPONSIBILITIES:

The following responsibilities will be integral to your role, ensuring that our data management systems operate efficiently and effectively:

• Develop and maintain SQL code and SSIS packages, ensuring robust and scalable solutions that can handle our ever-evolving data needs. This includes writing efficient SQL scripts for data extraction, transformation, and loading processes, as well as regularly updating and enhancing SSIS packages to improve performance and functionality.
• Analyze data meticulously to address both new and existing business issues. This involves identifying trends, interpreting complex data sets, and collaborating with stakeholders to deliver actionable insights that drive decision-making and foster business growth.
• Review query performance regularly and optimize SQL code as needed. This responsibility entails monitoring execution times, analyzing execution plans, and applying best practices to enhance overall performance, ensuring that queries run efficiently and effectively to support business operations.
• Provide production-level support to ensure the ongoing reliability and availability of data systems. This includes troubleshooting issues, resolving bugs, and implementing fixes promptly to minimize disruptions and maintain service continuity for our internal clients.
• Fully document all processes that are being created to maintain a clear and comprehensive record of the methodologies and practices used. This documentation is essential for promoting knowledge sharing, ensuring compliance with standards, and enabling future enhancements by providing a clear reference for both current and future team members.
  
  

Requirements

• +5 years of proven experience in Microsoft (MS) Transact-SQL (T-SQL)
• +2 Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and
  
  

experience to create solutions. Be able to present insights to stakeholders

• Working experience with Microsoft BI Tool Suite (SQL Server, SSIS, SSAS, SSRS)
• Understanding of SQL Server Agent, Integration Services Catalogs, SSISDB Projects and Environments, SSMS, Visual
  
  

Studio.

• Proficiency in data modeling, data transformation, and ETL/ELT processes
• Experience with data warehousing
• Identify and resolve data quality issues
• Familiarity with data governance best practices and tools
• Fluent in English