Computer Programmer/Analyst (Integration Specialist)

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 connections
• 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)