Computer Programmer/Analyst

5 days ago


Vernon, Canada City of Vancouver Full time
Computer Programmer/Analyst (Integration Specialist) Requisition ID:41601

Organization
Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of the world’s most liveable cities and is working towards being the greenest city in the world. Named among Canada's Top 100 Employers, BC's Top Employers, and Canada's Greenest Employers, the City of Vancouver seeks colleagues who can help shape and embody our core commitments to sustainability, reconciliation, equity and outstanding quality of life for all residents.

Consider joining our committed team of staff and being part of an innovative, inclusive and rewarding workplace.

Main Purpose and Function
The Integration Specialist ensures the City’s Enterprise Integration platforms are operationally sound, delivered according to project design and requirements, and perform in accordance with the organization’s technical standards. The position is responsible for developing enterprise integration solutions using various integration platforms (traditional ESB, data integration, message and event brokering middleware, iPaaS, and API mediation) to connect cloud, on-premise, user-centric, and IoT systems in both real-time and scheduled batch scenarios using multiple communication protocols and message formats, orchestration logic, and complex data transformations.

Specific Duties and Responsibilities
  • Requires considerable independent judgement to recommend, design, implement and support enterprise application & data integration projects
  • Delivers application and data integration solutions by:
    • Integrating data shared across legacy, new development, and purchased package environments
    • Developing system modification specifications
    • Mapping data & establishing interfaces
    • Developing and modifying functions, programs, routines, and stored procedures to export, transform, and load data
    • Resolving and escalating integration issues
    • Coordinating actions among users, operations staff, and outside vendors
    • Documenting operational procedures, technical design, sequence diagrams, and integration connectio
  • Designs, develops, tests, and implements, application & data integration systems and REST API solutions including software code writing
  • Integrating application & data from disparate data sources
  • Assess middleware tools for application and data integration, data transformation and translation, and message routing
  • Validates data integration by developing and executing test plans and scenarios including integration data design & data extract/transform
  • Improves integration by designing and evaluating new data interchange formats; improving physical design; writing data integration policy, standards, and procedures
  • Establishes best practises and standards by deriving from work experience, and researching and introducing industry trends on new and emerging integration technologies, and API solutions.
  • Reviews and analyzes systems post implementation, to ensure the implementation did not introduce defects and/or performance issues
  • Resolves escalated issues and works in a professional manner when dealing with sensitive or controversial matters
  • Provides technical advice, guidance, assistance, and training to users and staff
  • Prepares and maintains user and operations documentation, and provides technical training for other members of Integration Services team

Qualifications
Education and Experience:
  • Degree or diploma in computer sciences, data management, analytics or a related area
  • Sound backend development experience with .NET, .NET Core and Azure platform or an equivalent combination of education, training and experience.
  • Experience with Enterprise iPaaS platforms and industry standard integration tools such as Azure Integration Services (Logic Apps, Service Bus, Event Grid, API Management, Azure Functions), SAP Integration Platform, Informatica, Boomi or Mulesoft
  • 2+ years of professional experience in developing enterprise integration solutions using middleware and data integration tools involving: both batch (ETL/ELT) and real-time data; message and service orchestrations; event brokering; multiple message formats, transport protocols, platforms, data sources and applications; and complex transformations
  • 2+ years of hands-on coding experience in, at least, one programming language such as C#, Java, JavaScript, and Python
  • Experience in managing, designing (OpenAPI, RAML) and developing REST APIs, and in working with SOAP Web Services in Service Oriented Architectures
  • Experience with database platforms, Oracle or SQL Server and good understanding of relational and dimensional database structures, theories, principles, and practices. Experience should include relational database programming and development with MS SQL Server T-SQL or Oracle PL/SQL, data modelling, and database design

Knowledge, Skills, and Abilities
  • Familiarity with Enterprise BI Tools such as Microsoft PowerBI
  • Working knowledge of Agile Software Development, SDLC processes, DevOps (CI/CD), and version control with Git
  • Ability to work effectively in a changing environment and perform under pressure, organize multiple priorities and meet deadlines, articulate risks and make clear recommendations, and identify ways to improve service delivery.
  • Demonstrated ability to work both independently and as a member of a team
  • Excellent oral, written and presentation skills with ability to communicate to all levels of the organization
  • Ability to establish and maintain effective working relationships both internally and externally with technical and non-technical staff
  • Ability to handle business critical and sensitive information
  • Constantly drive innovation by staying current with technology, trends, and new ideas for data integration solutions and process improvements
  • Strong detail-oriented, analytical, and problem solving skills
  • Ability to quickly learn and apply new knowledge
  • Ability to focus on details and quality while delivering on commitments

Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work remotely 1 – 4 days a week from locations that are a daily commutable distance from their work at a City worksite. At this time this position is eligible to be part of the Flexible Work Program.

Business Unit/Department:IT, Digital Strategy & 311 (1070)

Affiliation:CUPE 15 Non Pks

Employment Type:Regular Full Time

Position Start Date:August, 2024

Salary Information: Pay Grade GR-027: $47.62to $56.27per hour

Number of Vacancies: 2

Application Close: July 5, 2024

At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. Indigenous peoples, people of colour, 2SLGBTQ+ persons including all gendersand persons with disabilities are encouraged to apply.Accommodations will be provided upon request during the selection process. Learn more aboutour commitment to diversity and inclusion.

Before you click Apply now

Once you start your application you can save your work and leave the applications page, however please remember to submit your profile to the specific job requisition before the posting closing date.

In addition to uploading your cover letter and resume, part of the application process may include answering application questions related to the preferred requirements of the role which may take approx. 5-10 minutes. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a summary of skills and experience related to the position.

Apply here #J-18808-Ljbffr

  • Vernon, Canada City of Vancouver Full time

    Computer Programmer/Analyst (Integration Specialist) Requisition ID:41601 Organization Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of...


  • Vernon, Canada Winnipeg Regional Health Authority Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Select how often (in days) to receive an alert: Already a Manitoba health-care employee?If you are a current Manitoba health-care employee looking for new opportunities, please click on the button below. Employer: Winnipeg Regional Health Authority...


  • Vernon, Canada Winnipeg Regional Health Authority Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Select how often (in days) to receive an alert: Already a Manitoba health-care employee?If you are a current Manitoba health-care employee looking for new opportunities, please click on the button below. Employer: Winnipeg Regional Health Authority...


  • Vernon, Canada Kal Tire Full time

    **Tech** **nical Support** **Analyst** **Role Description** The Technical Support Analyst is responsible for supporting Team Member technology solutions for Kal Tire operations. To be successful in this position, the Technical Support Analyst must be passionate about providing exceptional customer service experience. They must also have a strong desire to...


  • Vernon, British Columbia, Canada Kal Tire Full time

    Technical SupportAnalystRole DescriptionThe Technical Support Analyst is responsible for supporting Team Member technology solutions for Kal Tire operations.To be successful in this position, the Technical Support Analyst must be passionate about providing exceptional customer service experience. They must also have a strong desire to be constantly...


  • Vernon, British Columbia, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Taylor Ryan Executive Search Partners Full time

    Arrowleaf Real Estate Holdings has retained Taylor Ryan to assist with the search for a Senior Real Estate Analyst. Headquartered in Vernon, British Columbia, Arrowleaf is a rapidly growing real estate investment and development company with an established portfolio of multi-family, industrial, retail and office assets across Canada. They take a long-term...


  • Vernon, Canada Kal Tire Full time

    Technical Support AnalystVernon BCRole DescriptionThe Technical Support Analyst is responsible for defining Team Member facing hardware standards, and for working with team members, vendors and suppliers to ensure hardware, applications and related technologies options are appropriate. The Technical Support Analyst is also responsible for managing the...


  • Vernon, Canada Kal Tire Full time

    Description Technical Support Analyst Vernon BC Role Description The Technical Support Analyst is responsible for defining Team Member facing hardware standards, and for working with team members, vendors and suppliers to ensure hardware, applications and related technologies options are appropriate. The Technical Support Analyst is also...


  • Vernon, Canada Kal Tire Full time

    Technical Support AnalystVernon BCRole DescriptionThe Technical Support Analyst is responsible for defining Team Member facing hardware standards, and for working with team members, vendors and suppliers to ensure hardware, applications and related technologies options are appropriate. The Technical Support Analyst is also responsible for managing the...