Database Architect

1 month ago

Burlington, Canada Altis Technology Full time

One of our clients is looking to hire a Senior SSIS Software architect who loves to solve the types of problems that will scale, optimize, and extend our current data warehouse, analysis, and reporting solution. This role is integral to our commitment to delivering high-quality software solutions using Agile methodologies.


Key Responsibilities:

• Prioritize and profile non-functional projects for scalability and optimization.

• Collaborate with the product team to enhance solution capabilities based on customer needs.

• Develop and maintain SSIS packages using Visual Studio SQL Server Integration projects.

• Design and implement data transformation processes, including cleansing, aggregation, and

validation.

• Ensure data quality and reliability through effective error handling and logging.

• Work cross-functionally to deliver customer-centric outcomes.

• Extract data from various sources, including databases, flat files, APIs, and web services.

• Conduct data mapping and define conversion rules for system compatibility.

• Drive architectural and design improvements for enhanced customer experience.

• Break down projects into stories and deliver code that adheres to requirements and quality

standards.

• Uphold product quality through best practices and technical excellence.

• Address and resolve production incidents as necessary.

• Create and maintain essential technical documentation.

Experience and Skills:

• Proven experience in a similar role as a Software or Database Developer


Qualifications:

• 5+ years experience and proven skills in Microsoft SSIS and SQL Server T-SQL including DDL,

DQL, DML, DCL, TCL.

• Competence in .Net Framework and C# for SSIS Script Tasks.

• Bitbucket, Jira, Jenkins, RabbitMQ, Git.

• Experience in test-driven development environments.

• Working knowledge of Agile and Kanban methodologies preferred.

• Familiarity with Azure Data Factory and other Azure features is advantageous.

• Problem-solving ability and agility in decision-making.

• Strong communication skills and attention to detail.

Benefits:

• Dynamic and diverse environment.

• Opportunities for professional growth and cross-department collaboration.

• Competitive salary, generous vacation package, and work-life balance.

• Commitment to continuous communication and a fun, outgoing team culture

As a pandemic- resilient company, our client offers a flexible, remote-friendly work environment and foster a culture of respect, collaboration, and trust.


Note - For the right candidate this role could be 100% remote

  • Database Architect

    1 week ago

    Burlington, Ontario, Canada Altis Technology Full time

    One of our clients is in search of a Senior SSIS Software architect who excels in tackling challenges related to scaling, optimizing, and expanding the current data warehouse, analysis, and reporting solution. This role plays a crucial part in our dedication to delivering top-notch software solutions using Agile methodologies.Key Responsibilities:Prioritize...

  • Database Architect

    1 week ago

    Burlington, Ontario, Canada Altis Technology Full time

    Project Overview:The client needs a Senior SQL/SSIS Developer/Architect to manage and optimize existing SSIS packages on SQL Server and VMs. The goal is to move the enterprise-scale infrastructure to smaller VMs, ensuring efficient execution.Key Objectives:Architecture and Strategy Development:Create a detailed plan to migrate SSIS packages to smaller...

  • Database Administrator

    3 weeks ago

    Burlington, Canada Pearle Hospitality Full time

    _**As a member of the Pearle Hospitality team, you are a part of the Pearle Hospitality family.**_ Pearle Hospitality’s mission and focus is to enrich each moment through genuine and thoughtful actions. Each of Pearle Hospitality’s restaurants, event venues, hotels, and spas are focused on creating happiness and elevating each experience through the...

  • Database Architect

    4 weeks ago

    Burlington, Canada Altis Technology Full time

    Project Overview: The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and op

  • Database Architect

    3 weeks ago

    Burlington, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Database Architect

    4 weeks ago

    Burlington, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Database Architect

    4 weeks ago

    Burlington, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Database Architect

    4 weeks ago

    Burlington, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Database Architect

    4 weeks ago

    Burlington, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Database Administrator

    1 week ago

    Burlington, Ontario, Canada Pearle Hospitality Full time

    _As a member of the Pearle Hospitality team, you are a part of the Pearle Hospitality family._Pearle Hospitality's mission and focus is to enrich each moment through genuine and thoughtful actions. Each of Pearle Hospitality's restaurants, event venues, hotels, and spas are focused on creating happiness and elevating each experience through the care and...

  • Solutions Architect

    1 week ago

    Burlington, Ontario, Canada SRA Staffing Full time

    Our client is currently looking for a Solutions Architect resource to support the development and implementation of the EMS Electronic Patient Care Reporting project. The Solution Architect's responsibilities include gathering requirements and functional specifications; ability to create technical documentation and topology diagrams; ability to work with...

  • Database Architect

    4 weeks ago

    Burlington, ON, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Database Architect

    4 weeks ago

    Burlington, ON, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Database Architect

    4 weeks ago

    Burlington, ON, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Database Architect

    4 weeks ago

    Burlington, ON, Canada Altis Technology Full time

    Project Overview:The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment.Key...

  • Solutions Architect

    3 weeks ago

    Burlington, Canada SRA Staffing Full time

    Our client is currently looking for a Solutions Architect resource to support the development and implementation of the EMS Electronic Patient Care Reporting project. The Solution Architect's responsibilities include gathering requirements and functional specifications; ability to create technical documentation and topology diagrams; ability to work with...

  • Senior Data Engineer Remote From Eu H/F

    1 week ago

    Burlington, Ontario, Canada Altis Technology Full time

    One of our clients is looking to hire a Senior SSIS Software architect who loves to solve the types of problems that will scale, optimize, and extend our current data warehouse, analysis, and reporting solution. This role is integral to our commitment to delivering high-quality software solutions using Agile methodologies. Prioritize and profile...

  • Data Engineer Senior

    3 weeks ago

    Burlington, ON, Canada Altis Technology Full time

    One of our clients is looking to hire a Senior SSIS Software architect who loves to solve the types of problems that will scale, optimize, and extend our current data warehouse, analysis, and reporting solution. This role is integral to our commitment to delivering high-quality software solutions using Agile methodologies. Prioritize and profile...

  • Data Engineer Senior

    3 weeks ago

    Burlington, ON, Canada Altis Technology Full time

    One of our clients is looking to hire a Senior SSIS Software architect who loves to solve the types of problems that will scale, optimize, and extend our current data warehouse, analysis, and reporting solution. This role is integral to our commitment to delivering high-quality software solutions using Agile methodologies. Prioritize and profile...

  • Data Engineer Senior

    4 weeks ago

    Burlington, ON, Canada Altis Technology Full time

    One of our clients is looking to hire a Senior SSIS Software architect who loves to solve the types of problems that will scale, optimize, and extend our current data warehouse, analysis, and reporting solution. This role is integral to our commitment to delivering high-quality software solutions using Agile methodologies. Prioritize and profile...