Senior Integration Analyst

Description

Under general supervision, to support and perform analysis of business and clinical systems integrations and interfaces; to perform data mapping, data translations and transformations; ensure system integrity, compatibility, standardization and security; and to coordinate the development, implementation and maintenance of data interfaces to the various participant application systems.

Join a Culture of Growth and Well-Being at IT.sccgov.org

Technology Services and Solutions (TSS) is the County of Santa Clara’s primary information technology solutions provider. Working with other County departments and local government customers, TSS develops innovative, cost-effective technology solutions that aim to enhance the quality of life for the residents of Santa Clara County. TSS is where technical creativity thrives. Our employees are our most valuable asset, and the success of our organization depends on each one. We believe that happy employees are the most creative and productive, so it’s essential that our employees find fulfillment in what they do. To encourage growth, we provide learning and development opportunities. We also understand the significance of work-life balance and offer a hybrid work schedule. This culture of growth and well-being makes TSS a great place to work. Learn more about us by visiting our website.

Typical Tasks

• Collaborates with vendors, administrators and owners of third-party databases to establish data mapping plans and methods, enabling the sharing of data;
• Collects, analyzes and reports project status to stakeholders;
• Develops computer testing and audit policies and assists end users in implementing auditing controls to ensure that defined, mission-critical interfaces are passing data accurately;
• Oversees and ensures that interface build and configuration activities are on track and meet scope requirements;
• Provides integration and interface design (data mapping, translation and transformation specifications) and architectural services for new and existing projects;
• Analyzes requirements from a technical standpoint and translates them into potential integration points, thereby defining the interface topology for the project;
• Coordinates and maintains electronic interface security;
• Develops data mapping, translation and transformation routines and methods utilizing interface engine toolset and standard query and database tools;
• Evaluates and tests emerging integration technologies and tools;
• Mentors and trains more junior-level staff;
• Provides technical leadership to a team;
• Analyzes requirements and helps define integration and interface specifications;
• Builds, configures and maintains interfaces;
• Conducts testing of all mapping, translation and transformation routines prior to moving interfaces into production;
• Creates, manages, completes and closes relevant change management requests;
• Maintains technical artifacts, interface documentation, and topology diagrams;
• Performs analysis and troubleshooting of integration related issues;
• Maintains a library of all required standard vocabularies and nomenclatures used in normalizing inbound and outbound data feeds;
• Maintains test and production libraries of interfaces and applies appropriate methods, procedures and safeguards to protect the integrity of the interfaces and to ensure their recoverability;
• May be assigned as a Disaster Service Worker, as required;
• Performs other related duties as required.

Employment Standards

Sufficient education, training, and experience to demonstrate the possession and direct application of the following knowledge and abilities:

Training and Experience Note:
Possession of a Bachelor's degree from an accredited college in Computer Science, Information Technology, Mathematics, Engineering, or a related field;

• Ability to travel to alternate locations in the course of work. If driving, possession of a valid California Driver's License prior to appointment and the ability to qualify for and maintain a County driver authorization.
• Depending on the position, other related certifications may be required or desirable.

• Industry-specific systems, data manipulation and data transport mechanisms, standards, and protocols;
• Interface standards and protocols, including but not limited to HTML, ASCII;
• Inbound and outbound data integration involving XML, JSON and other structured data being transmitted via FTP, API or web services;
• Electronic interface security;
• Data mapping, translation and transformation routines and methods;
• Emerging integration technologies and tools;
• Staff coaching and mentoring;
• Interface engines and building interfaces on interface engines;
• Interface engines and platforms (i.e. Software AG WebMethods, NextGen Mirth, Corepoint, Orion, Infor, etc.);
• Requirements that define interface specifications;
• Building, configuring and maintaining interfaces;
• Interface testing;
• Change management requests;
• Technical artifacts, interface documentation, and topology diagrams;
• Analysis and troubleshooting of integration related issues;
• Standard vocabularies and nomenclatures used in normalizing inbound and outbound data feeds;
• Methods, procedures and safeguards to protect the integrity of the interfaces and to ensure their recoverability.

• Lead the requirements definition process;
• Provide technical leadership to train and mentor staff;
• Coordinate and maintain electronic interface security;
• Conduct testing of mapping, translation and transformation routines prior to moving interfaces into production;
• Develop data mapping, translation and transformation routines;
• Evaluate and test emerging integration technologies and tools;
• Coach and mentor lower-level or less experienced staff;
• Perform export, transform, and load (ETL) processes;
• Translate and documents complex clinical and/or business workflows;
• Design, develop, test and maintain interfaces Interface Tools;
• Communicate effectively both orally and in writing;
• Interact effectively with end user staff;
• Perform effectively in a large, complex organization;
• Analyze requirements and define interface specifications;
• Build, configure and maintain interfaces;
• Create, manage, complete and close change management requests;
• Maintain technical artifacts, interface documentation, and topology diagrams;
• Perform analysis and troubleshooting of integration related issues;
• Maintain test and production libraries of interfaces and apply appropriate procedures and safeguards to protect the integrity of the interfaces and to ensure their recoverability.