Remote Data Engineer (T-SQL & SSIS)

Description:

• 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.