Business Intelligence Developer

4 days ago

Victoria, Canada City of Victoria BC Full time

Job Description

Competition #24/155

Internal/External Posting

Closing date: July 11, 2024

Business Intelligence Developer (Continuous)

Information Technology Department

Victoria is a vibrant, diverse and sustainably-focused capital city, renowned as a global tourist destination which hosts over 3.5 million visitors annually, and fosters an excellent quality of life. Located on the southern tip of Vancouver Island, Victoria is home to 92,000 people and is the economic and cultural hub for the region’s 350,000 residents.

The City of Victoria has launched an exciting digital transformation initiative to modernize and pivot to a cloud-based Software-as-a-Service (SaaS) delivery model for its enterprise business applications. As part of this transformative journey, we are looking for a Business Intelligence (BI) Developer to join our Information Technology Team.

Please note: this is not a DevOps Developer position and will not focus on automating and streamlining the software development process. Instead, our BI Developer plays a crucial role in leveraging data to create insights and drive informed decision-making across cross-functional departments.. If you are passionate about using data to create actionable insights, possess strong analytical skills, and want to contribute to the city's digital transformation journey, we invite you to be a part of our dynamic team. Your expertise will be pivotal in shaping the future of Victoria's data-driven decision-making landscape.

POSITION FUNCTION

Reporting to the Information Manager, the Business Intelligence (BI) Developer is responsible for collaborating closely with project teams and business units to ensure the effective implementation of BI tools and processes that enhance and support sound enterprise data analytics and architecture. This role will involve data modeling, analysis, visualization, and will act as a corporate resource for the design and development of reporting to strengthen the city's operational efficiency and strategic planning initiatives.

KEY DUTIES:

Provide subject matter expertise and guidance in the development and maintenance of a corporate data framework and centre of excellence. Provide advice, assistance, and guidance to City staff on data management best practices. Design, develop and maintain data models to ensure data accuracy, consistency, and reliability for reporting and analysis purposes. Design procedures and structures to effectively extract, transform, load, and clean data from diverse sources, ensuring data accuracy, integrity, and accessibility that meets established standards. Adhere to data governance policies and security protocols, maintaining data privacy and compliance with established requirements. Liaise with various City departments to translate their data requirements into actionable solutions that align with strategic goals. Analyze extensive datasets to identify trends, patterns, and anomalies, providing valuable insights for decision-makers. Generate and customize intuitive reports, dashboards, and visualizations tailored to specific business needs and objectives using business intelligence tools such as Power BI to facilitate data-driven decision-making. Train and support business champions ensuring best practices are used and corporate standards are adhered to. Conduct ad hoc analyses as needed to provide timely insights and support strategic initiatives. Perform related duties where qualified.

INDEPENDENCE 

Work is performed according to established policies or procedures or is assigned by Supervisor. Work is autonomously executed, incorporating independent decision-making, which is subject to review through discussions with the Supervisor. Issues of significance, such as major system changes, expenditures and recourse/ policy matters are discussed with Supervisor with recommendations that reflect independent judgment.

WORKING CONDITIONS

Physical Effort:

Sit with arms unsupported while keyboarding (often).

Mental Effort:

Long periods of intense concentration while working with large volumes of data. (Often) Meet multiple deadlines with conflicting priorities (often).

Visual/Auditory Effort:

Focus on a variety of source data and computer for long periods. (often)

Work Environment:

Office

KEY SKILLS AND ABILITIES

Proficiency in the use of business intelligence tools such as Power BI or Tableau and demonstrated ability to create compelling visualizations. In-depth understanding of data management systems, online analytical processing (OLAP), and Extract, Transform, Load (ETL) frameworks. Proficiency in SQL and other programming languages commonly used for data analysis, such as Python. Strong analytical mindset with a passion for problem-solving and attention to detail. Proven ability to take initiative, be innovative, and effectively communicate complex technical concepts to non-technical stakeholders. Ability to establish and maintain effective working relationships. Strong time management, prioritization, and organizational skills.

QUALIFICATIONS

Formal Education, Training and Occupational Certification:

Undergraduate degree in a relevant field such as Computer Science, Statistics, or Engineering.

Experience:

5 years of related work experience or an equivalent combination of education and experience. Experience with MS SQL Server and Azure SQL database operations and optimization.

OTHER:

May be requested to substitute in a more senior position.

Work schedule: Monday to Friday, (35 hour work week)

$58.40 per hour, Pay Grade 18 (under review)

Job Code #4460

This is a CUPE Local 50 Position

  • Business Intelligence Engineer

    1 month ago

    Victoria, Canada BCI Full time

    Closing Date: Open Until FilledWant to play a critical role by leveraging your design and technical skills to turn data into insights which help drive business decisions? If you are looking for a Data & Analytics career in the investment management industry, BCI is looking for a Business Intelligence Engineer to join our growing Corporate Data & Operations...

  • Business Intelligence Engineer

    4 weeks ago

    Victoria, Canada BCI Full time

    Closing Date: Open Until FilledWant to play a critical role by leveraging your design and technical skills to turn data into insights which help drive business decisions? If you are looking for a Data & Analytics career in the investment management industry, BCI is looking for a Business Intelligence Engineer to join our growing Corporate Data & Operations...

  • Business Intelligence Engineer

    4 weeks ago

    Victoria, Canada BCI Full time

    Closing Date: Open Until FilledWant to play a critical role by leveraging your design and technical skills to turn data into insights which help drive business decisions? If you are looking for a Data & Analytics career in the investment management industry, BCI is looking for a Business Intelligence Engineer to join our growing Corporate Data & Operations...

  • Business Intelligence Advisor

    4 weeks ago

    Victoria, Canada NTT Data Services Full time

    We are currently seeking a Analytics Solution Architect to join our team in Victoria, BC, Canada. NTT Data is seeking a motivated and experienced **Analytics Solution Architect**. If you are passionate about technology, client interaction and all the challenges that go with being a consultant, you will want to be a part of our team. Our people have the...

  • Business Intelligence Analyst

    2 months ago

    Victoria, Canada Maximus Full time

    Company Profile: Maximus Canada is an industry leader in the provisioning of products and services to support the delivery of government services in North America and internationally. With operations across Canada and around the globe, Maximus provides innovative, practical and meaningful solutions to help government programs and services function more...

  • Business Intelligence Analyst

    1 week ago

    Victoria, British Columbia, Canada Maximus Full time

    Company Profile:Maximus Canada is an industry leader in the provisioning of products and services to support the delivery of government services in North America and internationally. With operations across Canada and around the globe, Maximus provides innovative, practical and meaningful solutions to help government programs and services function more...

  • Business Intelligence Advisor

    1 week ago

    Victoria, British Columbia, Canada NTT Data Services Full time

    We are currently seeking a Analytics Solution Architect to join our team in Victoria, BC, Canada.NTT Data is seeking a motivated and experienced Analytics Solution Architect. If you are passionate about technology, client interaction and all the challenges that go with being a consultant, you will want to be a part of our team. Our people have the skills and...

  • SAP Business Intelligence Analyst

    2 months ago

    Victoria, Canada Capital Regional District Full time

    **Capital Regional District** **SAP Business Intelligence Analyst**: **Job Summary** The SAP Business Intelligence Analyst works as a specialist in data analytics utilizing SAP Business Warehouse (BW) system with a focus on business intelligence and corporate reporting. The incumbent works closely with business areas and focuses on reviewing, designing,...

  • SAP Business Intelligence Analyst

    2 days ago

    Victoria, Canada Capital Regional District Full time

    **Capital Regional District** **SAP Business Intelligence Analyst**: **Job Summary** The SAP Business Intelligence Analyst works as a specialist in data analytics utilizing SAP Business Warehouse (BW) system with a focus on business intelligence and corporate reporting. The incumbent works closely with business areas and focuses on reviewing, designing,...

  • Business Intelligence Advisor

    4 weeks ago

    Victoria, Canada NTT DATA Full time

    We are currently seeking a Analytics Solution Architect to join our team in Victoria, BC, Canada. NTT Data is seeking a motivated and experienced **Analytics Solution Architect**. If you are passionate about technology, client interaction and all the challenges that go with being a consultant, you will want to be a part of our team.Our people have the...

  • Business Intelligence Advisor

    3 weeks ago

    Victoria, Canada NTT DATA Full time

    We are currently seeking a Analytics Solution Architect to join our team in Victoria, BC, Canada. NTT Data is seeking a motivated and experienced **Analytics Solution Architect**. If you are passionate about technology, client interaction and all the challenges that go with being a consultant, you will want to be a part of our team.Our people have the...

  • Business Intelligence Specialist

    3 weeks ago

    Victoria, Canada NTT Data Services Full time

    **Req ID**: 227139 We are currently seeking a Business Intelligence Specialist to join our team in Victoria, British Columbia (CA-BC), Canada (CA). In the role of Microsoft Data Analytics Consultant, you will provide industry best practices to support our Canadian clients with deliverables that are focused on the Microsoft Analytics technology stack. You...

  • SAP Business Intelligence Analyst

    1 week ago

    Victoria, British Columbia, Canada Capital Regional District Full time

    Capital Regional DistrictSAP Business Intelligence Analyst:Job SummaryThe SAP Business Intelligence Analyst works as a specialist in data analytics utilizing SAP Business Warehouse (BW) system with a focus on business intelligence and corporate reporting. The incumbent works closely with business areas and focuses on reviewing, designing, documenting, and...

  • Band 2 - Manager, Business Intelligence and Analysis

    2 weeks ago

    Victoria, Canada BC Public Service Full time

    Posting Title- BAND 2 - Manager, Business Intelligence and Analysis- Position Classification- Band 2- Union- N/A- Work Options- Hybrid- Location- Vancouver, BC V6B 0N8 CA - Victoria, BC V9B 6X2 CA (Primary)- Salary Range- $74,300.00 - $105,000.04 annually- Close Date- Job Type- Regular Full Time- Temporary End Date- Ministry/Organization- BC Public Service...

  • Business Intelligence Coordinator

    4 days ago

    Victoria, Canada Pilothouse Digital Ltd. Full time

    **_Remote in North America_** **We need you at Pilothouse!** **We're a fast-growing performance marketing agency that manages tens of millions per month in direct-response ad spending for awesome direct-to-consumer brands.** **We work with disruptive brands, and big budgets, and make crazy ideas come to life!** **Our model is built upon the core values...

  • Business Intelligence Engineer, AbeBooks Onsite Experience

    3 days ago

    Victoria, Canada Abebooks Inc. Full time

    AbeBooks, an Amazon subsidiary, is seeking a highly skilled and analytical Business Intelligence Engineer (BIE) to join our team. In this role, you will be responsible for designing and delivering end-to-end business intelligence solutions that empower our product, marketing, and business development teams. The ideal candidate will possess a combination of...

  • Business Development Coordinator

    4 weeks ago

    Victoria, Canada Ecofish Research Full time

    **WHO IS ECOFISH LOOKING FOR?** We are looking for a dedicated and hard-working **Business Development Coordinator** to join our accomplished team! We will provide an opportunity to join a team of experienced and skilled professionals who thrive on innovation, collaboration, and integrity. While working alongside Ecofish experts in your field, we will...

  • Business Development Coordinator

    1 week ago

    Victoria, British Columbia, Canada Ecofish Research Full time

    WHO IS ECOFISH LOOKING FOR?We are looking for a dedicated and hard-working Business Development Coordinator to join our accomplished team We will provide an opportunity to join a team of experienced and skilled professionals who thrive on innovation, collaboration, and integrity. While working alongside Ecofish experts in your field, we will support your...

  • Producer (Production Intelligence)

    3 weeks ago

    Victoria, Canada People Can Fly Full time

    Company Description Producer, Production Intelligence - Remote/Hybrid - Employees can work remotely - Full-time - Project: PCFF - Department: Production - Location: West Coast Time Zone People Can Fly is one of the leading independent AAA games development studios with an international team of hundreds of talented individuals working from offices located...

  • Business Development Executive

    3 weeks ago

    Victoria, Canada Driftwood Communications Ltd. Full time

    Driftwood Communications is actively recruiting for an experienced **Business Development Executive** to join our Team. This role reports directly to the CEO. Compensation Range: $65,000.00 - $120,000.00 **About Driftwood Communication** At Driftwood Communications Ltd., we are pioneers in the telecom industry, dedicated to designing, building, and...