The position is for a Data Engineer specializing in T-SQL and SSIS, focusing on developing comprehensive data integration solutions.
The candidate will be responsible for developing and maintaining SQL code and SSIS packages to ensure robust and scalable solutions for evolving data needs.
Responsibilities include writing efficient SQL scripts for data extraction, transformation, and loading processes, as well as updating and enhancing SSIS packages for improved performance.
The role involves analyzing data to address business issues, identifying trends, interpreting complex data sets, and collaborating with stakeholders to deliver actionable insights.
Regular review and optimization of query performance is required, including monitoring execution times and applying best practices to enhance overall performance.
The candidate will provide production-level support to ensure the reliability and availability of data systems, troubleshooting issues, resolving bugs, and implementing fixes promptly.
Documentation of all processes is essential to maintain a clear record of methodologies and practices, promoting knowledge sharing and compliance with standards.
Requirements:
A minimum of 5 years of proven experience in Microsoft (MS) Transact-SQL (T-SQL) is required.
The candidate must have at least 2 years of analytical experience, synthesizing complex information, collecting and researching data, and presenting insights to stakeholders.
Working experience with the Microsoft BI Tool Suite, including SQL Server, SSIS, SSAS, and SSRS, is necessary.
Understanding of SQL Server Agent, Integration Services Catalogs, SSISDB Projects and Environments, SSMS, and Visual Studio is required.
Proficiency in data modeling, data transformation, and ETL/ELT processes is essential.
Experience with data warehousing is a must.
The candidate should be able to identify and resolve data quality issues.
Familiarity with data governance best practices and tools is required.
Fluency in English is mandatory.
Benefits:
The position offers the opportunity to work on diverse analytical needs, ensuring data is utilized to its fullest potential.
The role provides a chance to develop and enhance skills in SQL and data integration techniques.
The candidate will have the opportunity to collaborate with stakeholders and contribute to business growth through actionable insights.
The position supports professional development through documentation practices that promote knowledge sharing and compliance.
The role ensures a dynamic work environment with evolving data needs, allowing for continuous learning and adaptation.