Data Integration Specialist

1116875
View Saved Jobs
Save

  • Job type

    Permanent

  • Location

    Vancouver

  • Profession

    Data & Advanced Analytics

  • Industry

    Construction

  • Pay

    75,000 - 85,000
Share Job

Data Integration Specialist

Our client has an immediate opening for a Data Integration Specialist to join their team in Vancouver.

The organization has a rich 35 year history and they pride themselves on putting people first at the heart of their story and by attracting passionate people who enjoy long-term careers with the organization. Additionally, company offers a competitive compensation package including base salary, annual discretionary bonus, generous vacation package, Benefits from Day 1, RRSP match, fitness and transportation allowance and support continuous education.

The Data Integration Specialist is a key Developer role, responsible for systems integration and data administration of a variety of enterprise systems. In this role the Data Integration Specialist will work collaboratively with a variety of 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

  • 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
  • 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.
  • Supports effective sharing and utilization of data across applications, multiple platforms, and departments, which includes planning and execution of data migration processes
  • Utilizes data privacy and security protocols in designing solutions to ensure system and data integrity, including analyzing underlying causes of problems
  • Makes recommendations, develops processes, accesses resource and implements control mechanisms that will ensure quality, integrity and security of data
  • Supports, troubleshoots and analyzes business systems, applications and other databases, to resolve complex systems, data management, communication, and interoperating problems
  • Serves as a technical resource on the subject of database setup and integration best practices
  • Identifies and analyzes complex, ambiguous and/or conflicting development issues
  • Crosschecks and debugs information obtained by integration for use in reporting
  • Communicates with administrators, end users, vendors, service providers and other outside organizations to coordinate activities, programs, schedule work, resolve issues
  • Remains up to date on technology changes and trends

Required Knowledge & Skills

  • 2-5 years strong hands-on experience in Azure DevOps, Azure Data Factory, Azure Integration Services, Logic Apps, GitHub.
  • 2-5 years strong hands-on experience with SQL Servers and Microsoft tools such as SSIS, SSAS and SSRS.
  • 2-5 years’ experience design and development of data integration solutions.
  • Technical experience in the management and maintenance of data warehouse environments and ETL processes.
  • BSc Computer Science or equivalent education and work experience.
  • Excellent communication (written and verbal) and diplomacy skills, and able to facilitate discussions for a win/win solution
  • A hands-on natural problem solver, who has a passion for learning and is detail oriented
  • Good understanding of ITIL operational support processes; ITIL certification is an asset
  • Thrives in a fast-paced hands-on environment and possesses an entrepreneurial spirit with a focus on continuous innovation
  • Adept at working with a matrix style of leadership, highly flexible, and able to manage multiple priorities as needed
  • Knowledge and experience in the Real Estate industry and Yardi ERP is an asset.

#LI-DNI

Apply for this job

linkedinApply through LinkedIn

Talk to Oleg Myaskovsky, the specialist consultant managing this position

Located in Vancouver (FR), 450 – 1095 W. Pender street, VancouverTelephone:  604 648 1654