Data Integration Analyst - Roseville, CA

Supporting the Federal Government, contractors, and subcontractors by delivering the industry’s best cleared talent and staffing resources. Data Integration Analyst is needed for a contract opportunity with SOC's client in Roseville, CA. Duration: 6-12 months with possibility of extension. Job Description Our Client is 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 existing data is flowing correctly through the system. Validate that newly introduced data can be accurately verified. 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, 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. 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. Employment Pre‑requisites Successful completion of a background investigation and drug urinalysis is required to be eligible for this position. SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, EOE AA M/F/Vet/Disability. Estimated Rate Estimated min rate: $42.00. Estimated max rate: $60.00. #J-18808-Ljbffr SOC LLC