Data Integration Analyst



  • Information Technology
  • Job Code: 9E91809796
  • Posted: September 11, 2018
David Aplin Group, one of Canada's Best Managed Companies, has partnered with our client to recruit for a Data Integration Analyst.

Our client, one of Alberta's top 70 employers, is looking for a Data Integration Analyst to join their growing team. This role is responsible for all data integration activities including both  Real-Time and ETL data transfers. The successful applicant will maintain or convert legacy integrations as well as work on new data migration and integration projects, including exporting, cleansing and validating data in a SQL and PaaS environment.

If you want to work for an incredible company that offers free onsite parking, an extensive rewards program, and an onsite gym, you should apply now!

The Role:

  • Ensure communication among business units to obtain requirements to validate data mapping rules by meeting with appropriate stakeholders and understanding the business use for data. 
  • Provide direct support and coaching to the organization on best-practice uses of data and analytics and assist users in finding the right information.
  • Ensure continual development of data/system integrations using the Dell Boomi Integration Platform and developing automated scripts. Monitor the ongoing operation of all Integration and ETL activities to ensure proper operation. Document and communicate the integration operations using tools like MS Visio diagrams.
  • Act as subject matter expert with technical and business knowledge of business applications and related integrations and is responsible for translating business integration requirements into technical solutions.
  • Provide data source management (DBA Support) for BI Data Repository using on premise and/or platform as a service tools.
  • Improve processes to increase the efficiency and effectiveness of the development and support of information systems integrations between Corporate and Airport IT business systems.
The Ideal Candidate:

  • BSc in Computer Science/Software Engineering considered an asset.
  • Minimum 5 years’ experience in the IT Field including MS certifications required.
  • Minimum 3 years’ experience in database development including MS certifications required.
  • At least 2-3 years' experience with Microsoft SQL Server required.
  • At least 2-3 years T-SQL experience (Stored procedures, triggers, views, etc.) required.
  • Strong SSIS skills creating ETL solutions.
  • Strong experience with the Dell Boomi Integrations Platform.
  • Must secure and maintain appropriate airport security clearance and acceptable criminal record check as conditions of employment.
If you are interested in this position and meet the above criteria, please click the Apply button to send your resume in confidence directly to Jade Murphy, Recruiter, Aplin Information Technology. We thank all applicants; however, only those selected for an interview will be contacted.  #LI-EDM


If this is your first introduction to us, we invite you to become one of our satisfied candidates. David Aplin Group has been Canadian owned since 1975. Our professional consultants are passionate about helping you find a fulfilling job or career and ensuring your complete satisfaction with our process. Our proven track record, nearly 4 decades long, is largely due to our team of highly skilled and successful specialists. Through superior service and a commitment to long-term relationships, we provide deep specialization in core areas for complete recruiting and HR solutions across Canada - all from one source. We look forward to exceeding your expectations!

Learn more about David Aplin Group and view all of our current job opportunities, career tips, and tools at



Jade Murphy

Information Technology



  • 780.229.2030

By clicking ‘Apply’, you agree to David Aplin Group Terms and Conditions of Use.