Integration Services Analyst/ Integration Data Analyst

American IT Systems • Roseville, CA

4d • Onsite

About The Position

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.

Requirements

• 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.
• 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.

Nice To Haves

• Familiarity with enterprise data integrations or analytics environments.
• Strong analytical mindset with attention to detail.
• Comfortable working in evolving environments with partially defined processes.

Responsibilities

• Create, maintain, and continuously update documentation for newly established and evolving integration processes.
• Validate integration data within a new integrated environment, confirming that existing data is flowing correctly through the system and 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 process flows, business and technical rules, assumptions and dependencies, data validation approaches, and 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed