Data Integration Specialist - #184008

On behalf of our client, Affinity is seeking a Data Integration Specialist on a full time permanent basis.

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

• Performs other related duties as needed.

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.

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 12008