Data Integration Analyst

ADP, Inc.; Brisbane (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

Automatic Data Processing, Inc. in Brisbane, CA is seeking a Data Integration Analyst to gather business and technical requirements, perform data analysis, and map client data into InfoIMAGE products.

You will ensure accuracy and consistency of client data integrations while supporting onboarding and solution delivery, with close collaboration across IS, Sales, Implementation, Product, and QA teams. The role requires strong analytical skills, experience with data mapping, and familiarity with

Qualifications

• Bachelor’s degree required in Information Systems or Computer Science related fields.
• 3+ years in an implementation, technical analyst, or similar role in SaaS, enterprise software, or technology services.
• Experience with SDLC and working in Agile or Scrum teams.

Responsibilities

• Elicit, analyze, and document business and functional requirements from stakeholders and clients.
• Translate client data requirements into integration specifications, including field mappings and transformation rules.
• Collaborate with Sales, Account Management, and Implementation to define project scope and feasibility.
• Document data integration resources, formats, mappings, and templates, and improve standards.
• Assist in user acceptance testing (UAT) and validation of features and solutions.

Skills

Unix/Linux

RDBMS

SFTP

Data analysis

Requirements gathering

SDLC understanding

Agile/Scrum

Cross-functional collaboration

Documentation

Education

Bachelor’s Degree in Information Systems or Computer Science related fields

Tools

Confluence

Jira

Microsoft Office Suite

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Integration Analyst

IS - Information Systems Full-time Regular Technical Brisbane, CA, US

3 days ago Requisition ID: 1127

Position: Data Integration Analyst

FLSA Status: Exempt

Department: IS - Information Systems

Summary of Position:

The Data Integration Analyst is responsible for gathering and documenting business and technical requirements, performing data analysis, and mapping client data into InfoIMAGE products. You will ensure accuracy, consistency, and alignment of client data integrations while supporting seamless onboarding and solution delivery.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Requirements Gathering & Analysis

• Elicit, analyze, and document business and functional requirements from internal and external stakeholders. – Gather job specifications, business rules, and technical deliverables through direct client interfacing to support integration activities.
• Ensure clear, consistent, and comprehensive requirements and documentation that supports development and QA efforts.

Manage overall technical analysis for client application setups and customizations.

• Perform data analysis, review files, and map fields between client data sources, document templates, and Statements of Work.
• Translate client data requirements into integration specifications, including field mappings, preliminary mock-ups, transformation rules, and validation criteria.
• Other duties as assigned.

Cross-Functional Collaboration

• Work with Sales and Account Management during pre-sales or early contract phases to define project scope and assess feasibility for preliminary analysis
• Initiate and facilitate feasibility meetings; review and document assessments with internal departments for prospective and/or existing clients.

Collaborate with Implementation Specialists to support and deliver new client projects, configurations and applications.

Coordinate closely with Product, Development, QA, and Operations teams to ensure accurate data ingestion and integration that aligns with client specifications.

• Assist in user acceptance testing (UAT) and validation of features and solutions.
• Other duties as assigned

Documentation

• Document and maintain resources related to data integration, including client system listings, data formats, mapping specifications, and templates.
• Contribute to continuous improvement of integration and documentation standards.
• Identify and document edge cases, risks, and technical dependencies.
• Other duties as assigned.

QUALIFICATION REQUIREMENTS:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Knowledge, Experience and Skill Requirements:

Education:

• Bachelor’s Degree required (Information Systems or computer science related fields)

Experience and Skills:

• 3+ years of experience in an implementation, technical analyst, or similar role in SaaS, enterprise software, or technology services.
• 3+ years of experience in a regulated industry such as financial services or healthcare (strongly preferred).
• Basic understanding of consumer banking products and services (preferred).
• Strong knowledge of Unix/Linux, RDBMS, and SFTP.
• Strong analytical skills for data inspection, cleansing, transformation, and modeling.
• Experience gathering requirements and translating into technical specifications.
• Experience with web-based application implementations (B2B and B2C).
• Ability to work cross-functionally with: Implementation, QA, Sales, Operations, Development, and Product.
• Understanding of implementation processes and Software Development Life Cycle (SDLC).
• Proficiency with documentation and tracking tools such as Confluence, Jira, and Microsoft Office Suite.
• Experience working within Agile or Scrum teams.

Physical Requirements:

• Multi-limb and eye-hand coordination
• Able to stand, bend, reach, stoop and lift boxes up to 10 lbs.
• Fast pace / multi-tasking with organization and efficiency
• Able to sit at a desk, working on a computer for extended periods.
• Able to communicate effectively in a collaborative, cross-functional environment.
• Able to manage multiple tasks and shifting priorities in a fast-paced setting.