Developer (Virtual, Canada)

SIRVA Inc.; United States; On-site; USD 65,000 - 76,000; Full time

Benefits offered by this job

Medical plans

Dental plans

RRSP match

Life Insurance

Job summary

SIRVA Inc. is seeking a data integration professional to design, develop, and maintain data pipelines that feed centralized warehouses for analytics. You will leverage SQL, Python, and ETL tools to integrate data across platforms and create scalable reporting solutions.

The role emphasizes building semantic models, complex SQL, and datasets for accurate insights, with collaboration across cloud architects and stakeholders in a global environment.

Qualifications

• Bachelor's degree in a computer science related field or equivalent work experience.
• Minimum 5 years experience with ETL design and data warehousing.
• Strong problem solving and ability to work in a global, distributed team.
• Proficient in SQL and Python; experience with Azure Data Factory, SSIS, and Databricks.
• Experience with Databricks, Azure, SQL Server, Microsoft Fabric, Git and Azure DevOps.

Responsibilities

• 75% Data Integration & ETL: build and maintain pipelines from source to data warehouse.
• 20% Modeling & Optimization: develop semantic models and complex SQL for performance.
• 5% Collaboration: work with Cloud Architects, Reporting Team and stakeholders.

Skills

SQL

Python

Azure Data Factory

Visual Studio SSIS

Databricks

Azure

SQL Server

Microsoft Fabric

Git

Azure DevOps

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Data Factory

Visual Studio SSIS

Databricks

Git

Azure DevOps

SQL Server

Job description

Job Overview

The person in this role will design, develop, and maintain systems that collect, transform, and load raw data from various sources into centralized warehouses for analysis. They will create data pipelines and optimize SQL-driven models. Key responsibilities include leveraging SQL, Python, ETL tools, and platforms like Databricks or SQL Server for data integration and reporting.

Essential Functions and Responsibilities

75% Data Integration & ETL: Building and maintaining data pipelines to move data from source systems to warehouses

20% Modeling & Optimization: Developing semantic models, complex SQL queries, and data sets for performance and accuracy

5% Collaboration: Working with Cloud Architects, Reporting Team and stakeholders to translate requirements into technical solutions

Qualifications and preferred skills (Qualifications, Skills, Education or Certification Requirements, etc.)

Education/Certification Requirements

• Bachelor's degree in a Computer Science related field or equivalent work experience

Qualifications and Experience Requirements

• Minimum 5 years experience with ETL Design, Data Warehousing, or developing Business Intelligence solutions
• Experience working in a global environment and with remote and distributed teams
• Strong problem solving and conflict resolution skills
• Ability to operate in a self-directed environment
• Minimum 5 years experience with:
  • Languages: SQL, Python
  • Data Transformation Tools: Azure Data Factory, Visual Studio SSIS, Databricks
  • Data Warehousing/Cloud Architecture: Databricks, Azure, SQL Server, Microsoft Fabric
  • Version Control: Git, Azure DevOps

Compensation and Benefits

• Position Title: Developer
• Salary Range: $92,000-$108,000 CAD
• Benefits: Comprehensive benefits package that includes choice of two Medical plans and two dental plans; Retirement plan, RRSP employer match (after 1 year), Life & Disability Insurance, and more. Benefits are based on employment status and may not be available for temporary or non full-time employees

Salary ranges may vary based on location, market conditions, and other factors such as experience and qualifications. The final compensation will be determined during the hiring process based on these considerations.

For positions available outside Canada, salaries will take into account local currency and market conditions, which may differ from the CAD salary range. If you have any questions about salary or benefits, we encourage you to ask during the hiring process.

• Artificial Intelligence Usage: Artificial intelligence tools may be used to assist with administrative tasks such as notetaking and advanced candidate searches during the recruitment process. All screening, assessment, and hiring decisions are made by human recruiters and hiring managers.
• Vacancy Status: This posting reflects an existing vacancy within our organization.

Sirva Worldwide Relocation and Moving is a global leader in moving and relocation services, offering solutions for mobility programs to companies of every size. With 75 owned locations and more than 1,000 franchised and agent locations in 177 countries, we offer unmatched global breadth supported by localized attention and innovative technology that strikes the right balance of self service and human support. From relocation and household goods to commercial moving and storage, our portfolio of Brands (Sirva, Team Relocations, Allied, & northAmerican) provides the only integrated moving/relocation solution in the industry. By leveraging our global network, we deliver a superior experience that only a "one-stop shop" can provide. We're a team that works globally to provide the best service locally - a company that is everything you need, everywhere you need it. For more information please visit www.sirva.com.

Sirva brings together strong, collaborative people in a dynamic culture of mutual respect, support, and passion for the brand and product. We believe innovation drives winning performance, and we constantly challenge ourselves to be the very best we can in every aspect of our business. You will be surrounded by some of the brightest and most driven people in the industry. At Sirva, you will be in great company!

Sirva is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, military status, genetic information or any other consideration made unlawful by applicable federal, state, or local laws. Sirva also prohibits harassment of applicants and employees based on any of these protected categories.

If you need a reasonable accommodation because of a disability of any part of the employment process, please send an email to Human Resources at [e-mail] and let us know the nature of your request and your contact information.