Job Posting 64885

BI Data Integration Developer
BC Housing
Vancouver & Lower Mainland, Burnaby
closes in 53 days (Mon, 16 Nov)
full time


Job ID:  3573


Location:  BURNABY, BC







Reporting to the Manager, Business Applications Development, the BI and Data Integration Developer is responsible for designing and developing data analytics and integration solutions for both internal and external audiences. The position manages all aspects of the development life cycle and ensures all data analytics applications and data integration solutions meet integrity and quality control standards. The position provides 2nd level support in tuning production reports for optimal performance, develops SQL queries for complex data requests, and facilitates integration issues between source and target applications. The position runs and manipulates various data including confidential HR, payroll and other business data.




The successful candidate will have the following:




Degree/diploma in Information Technology or Computer Science from a recognized post-secondary institution.

Minimum four years’ experience in small to medium project experience interacting with project managers, business analysts, and technical resources such as application development team members and users, and operational reporting application design and development as well as experience in complete lifecycle data warehouse development projects. Some experience in enterprise reporting, BI toolsets, data integration and Azure platform is preferred.

Or an equivalent combination of education, training and experience acceptable to the employer.


Good understanding of BI architecture, and full lifecycle BI and integration development.

  • Working knowledge and familiarity with the following software and languages:

Software components:

  • BI Tools - Power BI (cloud and on-prem), SSAS, Azure Analysis Services, WebFOCUS, InfoAssist
  • Windows
  • Integration Tools - SSIS, SSMS, DataMigrator, Oracle SOA Suite, iWay Service Manager, BPEL, Web Services, SOAP UI
  • Azure Platform tools – Power Platform, Azure SQL DB, Azure Blob Storage, Azure Data Factory, Azure Data Lake


  • Database, e.g. DDL. DML. SQL, PL/SQL
  • Web Standards/Specifications, e.g. XML, XSD, SOAP, REST, WSDL


  • Ability to translate business requirements into user-friendly analytic models;
  • Ability to work effectively both independently as well as part of a larger team of business users and analysts;
  • Ability to take ownership of tasks and drive them through to completion
  • Ability and experience in working under pressure to meet changing deadlines due to shifting priorities.
  • Ability to identify, describe and resolve technical issues
  • Ability to present information effectively during presentations, demonstrations and project meetings
  • Ability to deal with confidential information using judgment and discretion.
  • Good BI design and development skills, and data modelling and data analysis skills;
  • Strong systems analysis, troubleshooting and problem-solving skills;
  • Excellent verbal communication skills
  • Excellent technical writing skills to effectively complete requirements, design and operational documents
  • Good interpersonal, organizational and project leadership skills
  • Strong analytical and problem-solving skills


How to Apply:

Please review the attached job description for a complete list of duties, qualifications and competencies.  To be considered for this competition, applicants must submit a cover letter and resume clearly identifying how they meet the qualifications necessary for this position.  This information will be used as part of the selection process.


Your cover letter and resume should be submitted as one document in your profile when applying for this position. Please add your cover letter to your resume and submit both documents as your resume.


Please review the Job Description prior to applying

 (When there is a pop up asking if you wish to view only secure items, press no)


As part of the application process, you will be prompted to fill out a questionnaire which must be completed in order for your application to be considered. Please allot up to 5 minutes to fill it out after submitting your resume and cover letter as one single document.


Only applications submitted using the Online Recruitment System at will be accepted


If you are passionate about what you do and want to use your expertise to engage in a meaningful and challenging work, please apply to join our team today at


At BC Housing, we're committed to providing a healthy, safe and inclusive workplace where respect and diversity are recognized assets. We welcome applications from women, visible minorities, Indigenous Peoples, individuals with disabilities, persons of any sexual orientation or gender identity, and all people committed to meaningful work that makes a difference.  If you require accommodations at any point during the application and hiring process, please contact .


We didn’t become one of BC’s Top Employers and one of Canada’s Greenest Employers without a lot of thought, care and consideration for our team and environment. Our supportive and collaborative workplace balances engaging and challenging work with personal development and wellness initiatives.




Have questions/issues about the application process? Please see our FAQ’s for some useful information.


Please Note: is not affiliated with and in no way endorses or vets the organization that posted this job. Any links posted within the job will take you to their external site where the same disclaimer applies.

Thanks for looking on and good luck with your job search!