• Edmonton, AB, CAN
  • Contract

Full-Time 12-Month Contract - Competition #18-53

Position Summary

We are seeking an Extract, Transform, Load (ETL) Developer to join our business intelligence team in Edmonton. The ETL Developer is responsible for end-to-end ETL design, development, testing and maintenance, and ongoing support of ASEBP's data warehouse. The successful candidate will work closely with other members of the business intelligence team on various reporting projects, acting as the expert in ETL processes.

The ideal candidate has significant experience writing complex T-SQL queries, with at least three to five years of related experience.

Your Key Responsibilities

  • 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.

Your Education and Experience

  • 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.

Your Abilities

  • 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

No phone calls please. We thank all interested individuals, but only those candidates being considered for an interview will be contacted. ASEBP is an equal opportunity employer.

Please note that an account will automatically be created for you during the application process if you do not have an ApplicantPro account set up already.

  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

    I agree to ApplicantPro's Applicant Information Use Policy.*
  • Sign Up For Job Alerts!

  • Share This Page
  • Facebook Twitter LinkedIn Email
Logo My Benefits Using My Plan Forms About Contact News My ASEBP Login