Position Description

ETL Developer (Microsoft SSIS)
Job Category Developer
Job Location Victoria, BC
Last Updated 16/05/18 1:06 PM
Apply Now

ETL Developer (Microsoft SSIS)
Reference: 2595

Victoria, BC

We are seeking an experienced ETL Developer in the Victoria BC area who is specialized in Microsoft development.  We are looking for individuals that are innovative and creative, demonstrate problem solving and judgment skills, be collaborative and can work well in a team environment. You must have excellent listening skills, be highly responsive and have a customer service orientation.  Only candidates that are currently and immediately eligible to work in Canada will be considered.

Key Areas of Responsibility

  • Responsible for developing ETL scripts.
  • Create ETL Integration packages used to build subject areas.
  • Implement business rules as part of ETL process.
  • Develop job schedule and scripting routines.
  • Perform Unit testing on ETL packages.
  • Index creation and Performance tuning.
  • Responsible for developing Semantic layer (Cubes).
  • Creation of Tabular Models and OLAP Cubes.
  • Unit testing of Tabular Models and OLAP Cubes.
  • Participate in Data Analysis, Requirements and Data Modelling activities. 

Professional Qualifications & Experience

  • 5+ years of Dimensional Data Warehouse development experience.
  • 5+ years’ experience with developing data extraction, transformation, and load program functionality on a wide-range of data repositories (relational and multi-dimensional).
  • 3+ years Data Analysis experience.
  • 3+ years SQL skills.
  • ETL Development experience with Microsoft SSIS.
  • Database Experience – SQL Server, Oracle.
  • Relational and dimensional data modeling and database design skills.
  • Experience with data model design principles, techniques, and standards.
  • Ability to work effectively in a team situation with developers and other personnel.
  • University or college degree.
  • Strong Business Analysis and Data Analysis skills.
  • Other systems development experience.
  • Technical background with proven trouble shooting skills.
  • Adept at delving into systems to find the true root cause for the issue at hand.
  • Strong organization and analytical skills with excellent attention to details.
  • Ability to work independently on multiple simultaneous tasks within a challenging fast paced team and customer oriented environment.

_______________________
Who we are

Headquartered in Vancouver, British Columbia and founded in 1966, Sierra Systems is a top tier IT services and management consulting firm offering a full range of advisory services, systems integration, and managed application services.

With approximately 800 professionals across Canada, Sierra Systems has developed deep expertise in its targeted industries and has earned a reputation for delivering superior solutions that strengthen organizations’ operational performance.

Our unwavering commitment to our clients’ needs has allowed us to build long-term, trusting, and loyal relationships. It has given us the ability to set ambitious objectives for client projects and meet them time and time again with unparalleled speed and precision.

We offer a full range of management consulting, systems integration and managed services tailored to the unique needs of each industry in which we have deep expertise – including: Canadian government, justice, health, energy, and the commercial sector. We focus on delivering a boutique experience backed by the resources, deep knowledge, and expertise our 50-year heritage provides to tackle large scale projects.

What to expect

Sierra Systems is committed to a working environment that fosters professional and personal progression, communication, and collaboration. We offer opportunities for personal growth and professional development at every career level.

We are regularly recognized as a Top Employer , in part due to the compensation and benefits packages we offer which are just one of the many great reasons to join Sierra Systems.

www.SierraSystems.com  |  Facebook  |  LinkedIn  |  Twitter | Glassdoor |

 

Back Apply Now