Integration Analyst

Job: Integration Analyst

Duration: 9+ Months

Location: Roseville, CA, 95747

Pay Rate: $40.00/hr on W2

Job Description:

We are seeking a highly technical Integration Services contractor to support newly developed and evolving integration processes. These processes are currently under active development and review, and this role will play a key part in validating data integrity, documenting workflows, and ensuring clear communication across stakeholders.

Key Responsibilities

• Create, maintain, and continuously update documentation for newly established and evolving integration processes.

• Validate integration data within a new integrated environment, confirming that:

o Existing data is flowing correctly through the system.

o Newly introduced data can be accurately validated and proven.

• Perform detailed data analysis to isolate and validate specific data sets based on provided direction.

• Confidently report findings, identify anomalies, and propose practical improvements to integration processes and data flows.

• Produce clear, well-structured documentation at multiple levels of technical depth, including:

o Process flows

o Business and technical rules

o Assumptions and dependencies

o Data validation approaches

o Frequencies and timing of integration activities

• Ensure documentation clearly defines user roles, responsibilities, and expectations within each portion of the process to support effective communication and adoption.

Technical Expectations

• Create and use basic to intermediate T-SQL queries to validate, analyze, and substantiate integration results.

• Basic and working knowledge of AI tools including Copilot, Claude and ChatGPT.

• Analyze database-level data to support data integrity checks and root-cause investigations.

• The ability to create, review, and debug basic C# and/or Python code used within internal automation tasks, particularly those supporting data movement, validation, or reporting workflows.

• Develop lightweight internal Power BI reports or dashboards, as needed, to summarize findings, trends, and high-level activity metrics related to integration validation.

Required Qualifications

• Strong technical aptitude and the ability to quickly understand complex systems and data flows.

• Prior exposure to relational database schemas and data-driven systems.

• Ability to take direction efficiently and apply it to focused validation and analysis tasks.

• Demonstrated ability to clearly communicate technical findings to both technical and non-technical audiences.

• Proven experience producing clear, usable documentation that supports cross-functional understanding and collaboration.

Desired Attributes

• Familiarity with enterprise data integrations or analytics environments.

• Strong analytical mindset with attention to detail.

• Comfortable working in evolving environments with partially defined processes.