Data Engineer (T-SQL & SSIS)

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 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 business operations.
• Provide production-level 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 .
  
  
  

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