Login | Register

Intermediate Business Analyst with ETL integration experience and business intelligence

Job Type: Contract
Positions to fill: 1
Start Date: Oct 17, 2022
Job End Date: Apr 28, 2023
Pay Rate: Hourly: Negotiable
Job ID: 123701
Location: Vancouver

Our public sector client is looking for a Business Analyst to support ongoing data analytics and data integration projects. These projects include the development of data models, KPI dashboards and ETL integrations. The successful candidate would also help support ongoing sustainment efforts and system upgrade activities.

  • Data model and reporting requirements
  • Program/Application gap analysis
  • Identification of data entities and definitions
  • Dashboard requirements analysis and prototyping
  • Business process mapping and data governance
  • Analysis of security requirements and data segregation needs
  • Data profiling and quality assessments
  • Develop and execute test plans
  • Project and sustainment documentation

  • A recognized degree or certificate in Business Administration, Computer Science or MIS
  • 2-5 years of business analysis, particularly in reporting/analytic areas
  • 1-2 years of writing SQL queries
  • 1-2 years of SSAS and/or Power BI
  • Intermediate MS Excel skills
  • Experience with business intelligence tools and reporting
  • Experience with master data management
  • Experience with dashboard development
  • Experience working with Power BI DAX
  • Experience working with Oracle SQL
  • Ability to work well under pressure and able to manage simultaneous priorities, pressures, and deadlines
  • Experience working with customer, financial, or property systems/applications
  • Experience working for public agencies and/or social service organizations