Data Integration Specialist

Concert Properties Ltd.; Vancouver; On-site; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Data Integration Specialist to enhance systems integration and data administration. This vital role involves collaborating with various teams to design and develop integration and reporting solutions using advanced tools. Ideal candidates will possess strong SQL skills and experience with Microsoft technologies, ensuring data integrity and security. Join a company that values a people-first approach and fosters a collaborative culture, offering competitive pay and comprehensive benefits. This is a fantastic opportunity to contribute to building sustainable communities while advancing your career in a supportive environment.

Benefits

Comprehensive benefits

Employee health and wellness programs

Competitive pay

Diversity and inclusion initiatives

Qualifications

• 2-5 years of experience with SQL Servers and Microsoft tools.
• Experience in designing and developing data integration solutions.

Responsibilities

• Design and implement ETL, system, and API integrations.
• Support data sharing and utilization across applications and platforms.

Skills

SQL Server

SSIS

SSAS

SSRS

Data Integration

Communication Skills

Problem Solving

Education

Bachelor's in Computer Science

Tools

Azure DevOps

Azure Data Factory

Azure Integration Services

Logic Apps

Job description

Posted Tuesday, March 25, 2025 at 10:00 AM

About Concert Properties

Putting people first is at the heart of the Concert Properties story. We are deeply invested in improving the lives of the people who live and work in our communities, acknowledging that communities are more than just buildings. We focus on quality, consistency, and sustainability, and our business is driven by warm, passionate people who embody a desire to help each of us feel more connected to one another.

Since 1989, our real estate portfolio has grown to an asset value of $9 billion and includes condominiums, rentals, industrial and commercial properties, and public infrastructure projects across Canada.

Position Summary

The Data Integration Specialist is a key developer role, responsible for systems integration and data administration of a variety of enterprise systems. This role reports into the Vice President, Information Systems Technology.

In this role, the Data Integration Specialist will work collaboratively with a variety of IST teams and the business to support, design, and develop industry-standard integration, business intelligence, and reporting solutions.

As a key member of the technology team, the Data Integration Specialist will possess excellent communication, technical, and teamwork skills. At ease when communicating with both business leads and technical teams, and able to quickly adapt his/her communication skills.

Key Responsibilities

1. Working closely with the Enterprise Architecture and Information Security teams, designs, develops, tests, debugs, and implements ETL, system, and API integrations built using Azure DevOps, Azure Data Factory, Azure Integration Services, and Logic Apps for gathering and maintaining database information between various data sources. Also ensures that automated operational error handling and data monitoring is in place.
2. Working closely with business partners and internal application SMEs in analyzing functional requirements to make recommendations for efficiency, database management and connections, and technology solutions. Develops data application queries and reports as needed.
3. Supports effective sharing and utilization of data across applications, multiple platforms, and departments, which includes planning and execution of data migration processes.
4. Utilizes data privacy and security protocols in designing solutions to ensure system and data integrity, including analyzing underlying causes of problems.
5. Makes recommendations, develops processes, accesses resources, and implements control mechanisms that will ensure quality, integrity, and security of data.
6. Supports, troubleshoots, and analyzes business systems, applications, and other databases, to resolve complex systems, data management, communication, and interoperability problems.
7. Serves as a technical resource on the subject of database setup and integration best practices.
8. Identifies and analyzes complex, ambiguous, and/or conflicting development issues.
9. Crosschecks and debugs information obtained by integration for use in reporting.
10. Communicates with administrators, end users, vendors, service providers, and other outside organizations to coordinate activities, programs, schedule work, and resolve issues.
11. Remains up to date on technology changes and trends.
12. Performs other related duties as needed.

Required Knowledge & Skills

1. 2-5 years strong hands-on experience with SQL Servers and Microsoft tools such as SSIS, SSAS, and SSRS.
2. 2-5 years’ experience in design and development of data integration solutions.
3. Technical experience in the management and maintenance of data warehouse environments and ETL processes.
4. BSc in Computer Science or equivalent education and work experience.
5. Excellent communication (written and verbal) and diplomacy skills, and able to facilitate discussions for a win/win solution.
6. A hands-on natural problem solver, who has a passion for learning and is detail-oriented.

Join the Concert Team in building a people-first future.

Concert Properties is proud to have been named one of BC’s Top Employers for the fifth year in a row!

We are a proud Canadian company, providing quality employment across the country and working together with the people we serve to realize our vision – building resilient, inclusive, sustainable communities. Our success is based on our employees – on a passionate, talented team who value a collaborative culture, a desire for excellence, and a willingness to give back. We truly value our team members and offer competitive pay, and comprehensive benefits and perk programs that support and promote employee health and wellness.

At Concert Properties, we value diversity, equity, and inclusion and are committed to building a team that represents a variety of backgrounds, perspectives, and skills. We welcome applications from all qualified job seekers. The posted salary range is reflective of the qualifications and experience we are looking for in a candidate to fill this opportunity; however, applicants with all levels of experience are welcome to submit their applications. Please be advised that only short-listed candidates will be contacted.

Thank you for your interest in Concert Properties.