We are seeking a highly skilled Senior Data Engineer with expertise in SSIS and a passion for problem-solving to enhance and scale our data warehouse, analysis, and reporting solutions. This role is essential in delivering high-quality software using Agile methodologies.

• Implement robust data transformation processes, including cleansing, aggregation, and validation.
• Extract and integrate data from various sources such as databases, flat files, APIs, and web services.
• Ensure high data quality and reliability through effective error handling and logging.
  
• Prioritize and optimize non-functional projects to ensure scalability and performance.
• Collaborate closely with the product team to expand solution capabilities in response to customer requirements.
• Design, develop, and maintain SSIS packages using Visual Studio SQL Server Integration projects.
• Utilize C# programming to support and develop legacy portal features.
• Work cross-functionally to deliver solutions that align with customer-centric goals.
• Conduct data mapping and define conversion rules to ensure system compatibility.
• Lead architectural and design improvements to enhance the customer experience.
• Break down projects into manageable stories and deliver code that meets both functional and quality requirements.
• Maintain technical excellence and uphold best practices to ensure product quality.
• Respond to and resolve production incidents as needed.
• Create and maintain thorough technical documentation.

• Proven experience as a Data or Database Engineer in a similar role.
• 5+ years of hands-on experience with Microsoft SSIS, SQL Server, and T-SQL (DDL, DQL, DML, DCL, TCL).
• Proficiency with .Net Framework and C# for SSIS Script Tasks.
• Experience with tools such as Bitbucket, Jira, Jenkins, RabbitMQ, and Git.
• Familiarity with test-driven development environments.
• Working knowledge of Agile and Kanban methodologies.
• Experience with Azure Data Factory and other Azure services is a plus.
• Strong problem-solving skills and the ability to make quick, effective decisions.
• Excellent communication skills and a strong attention to detail.