You're using an older version of Internet Explorer that is no longer supported. Please update your browser.

Application Analyst 2 - Business Intelligence Developer

Surrey, BC
Full Time
3 days ago

As one of the fastest growing cities in Canada, City of Surrey is a globally recognized leader in building vibrant, sustainable communities through technology and innovation. City of Surrey employees are talented innovators, inspired by meaningful work and the opportunity to drive our city-and their careers-forward. Build a City. Build a Future at the City of Surrey.

Employment Status

Union - CUPE Local 402 - Term


To support the City's Data Driven Decision Making program (D3M), we are seeking an Application Analyst 2 with a focus on Business Intelligence development. This role is ideal for a technical person who participates in the design, development, and maintenance of our enterprise BI platform.


Under general supervision, the successful candidate:
    • Performs analysis, design, development, implementation, documentation and maintenance of custom software applications for both new and existing business and technical information systems; • Collaborates with stakeholders and IT management, studying data flow, recommending best tool sets, and work processes; • Is involved with all technical activities within the team - estimating, planning, code reviews, testing, research, deployments and document creation; • Works as part of project teams to enable the successful delivery of IT solutions that meet client and business requirements and are aligned with both enterprise architecture and City goals; • Researches and stays up-to-date on applicable business systems and industry requirements; • Provides troubleshooting assistance and end-user support to our clients; • Communicates on open items and issues to key stakeholders, including management; • Works exceptionally well in a team setting supporting our collaborative work environment; • Acts as a resource for more junior application analysts as required.


    • Degree in a related field from a recognized institution plus two years related experience or an acceptable equivalent combination of education and experience;

Related experience includes:
    • Experience working with Power BI, building reports, data flows and dashboards; • Experience with Azure Data Factory, Synapse, Data Bricks, Data Warehouse; • Experience using ETL tools such as FME to extract data from multiple enterprise applications and data sources; • Experience with Oracle databases and other query languages (PL/SQL, SQL, others); • Experience with Python and Scala programming languages; • Proven experience crafting reports, presentations and interpretations;

Conditions of Employment

This position requires completion of a Police Information Check. Successful applicants must provide proof of qualifications.

Closing Date

This job will be posted until filled.

Our Values

Integrity - Service - Teamwork - Innovation - Community

Information Technology