ETL Developer



  • Information Technology
  • Job Code: 9D370334810
  • Posted: September 27, 2018
The Job has been filled
David Aplin Group, one of Canada's Best Managed Companies, has partnered with our client to recruit for an ETL Developer.

The Role:

  • Apply the Kimball Lifecycle methodology for developing data warehouses to new business areas identified by leadership.
  • Document the source system architecture, participate in the design of the dimensional model, and develop the data mapping and physical model.
  • Complete ETL development, validation and testing.
  • Provide ongoing maintenance and support of the existing SSIS workflows.
  • Troubleshoot, monitor and conduct performance improvement of the ETL.
  • Identify any data issues with the operational ETL and work with information technology services to resolve the issues.
  • Provide addition SSAS Tabular Model development and optimization.
The Ideal Candidate:

  • A minimum of three to five years of related experience.
  • Completion of a two or three year technical certificate or diploma in a related field.
  • A combination of education and experience may be considered.
  • Significant experience writing complex T-SQL queries.
  • An excellent understanding of the structure of relational databases, data warehouses and their implementation.
  • Proven ability to work effectively with large volumes of data, business lines and plans.
  • Strong working knowledge of Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS), data models, database design, SQL Server 2012 and up, SQL Server Analysis Services (SSAS), Visual Studio, PowerBI and other Microsoft programs. Experience with SAS, SPSS, R, or other statistical software is an asset.
  • Strong analytical and problem solving skills, attention to detail, and the ability to work both in a team and independently.
  • Flexibility, initiative, perseverance and integrity.
  • Effective time management skills with the ability to manage multiple projects over varying timelines.
  • Strong communication, presentation and interpersonal skills.
  • Ideally has significant experience writing complex T-SQL queries, with at least three to five years of related experience.

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 Deborah Dodd, Partner - 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



Deborah Dodd

Information Technology



  • 780.229.2013

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