Uncharted Talent Inc -
5 Jobs
Burlington, ON
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.
Key Responsibilities- 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.