Job Title - Integration Services Analyst / Data Validation Specialist
Location - Roseville, CA (Onsite)
Employment Type: Contract 7+ months
Job Description:
About the Role
We are seeking a highly analytical and technically skilled Integration Services Analyst to support the validation, documentation, and optimization of enterprise integration processes within a rapidly evolving environment.
This role is ideal for a professional who enjoys working with data, validating system integrations, documenting technical workflows, and collaborating across teams to ensure data integrity and process effectiveness. You will play a critical role in supporting newly developed integration solutions by performing detailed analysis, troubleshooting data issues, and producing high-quality documentation that enables successful adoption across the organization.
Key Responsibilities
- Create, maintain, and continuously improve documentation for integration processes and workflows.
- Validate data accuracy and integrity within newly integrated systems and environments.
- Analyze data flows and identify anomalies, inconsistencies, and improvement opportunities.
- Perform detailed data analysis and validation using SQL queries and database tools.
- Document business rules, technical rules, assumptions, dependencies, and process requirements.
- Communicate technical findings clearly to both technical and non-technical stakeholders.
- Support root-cause analysis and troubleshooting efforts related to integration processes.
- Develop lightweight Power BI dashboards and reports to track validation activities and trends.
- Ensure documentation clearly outlines roles, responsibilities, frequencies, and process expectations.
- Collaborate with cross-functional teams to support evolving integration initiatives.
Required Qualifications
- Experience working with data-driven systems and relational databases.
- Strong analytical and problem-solving abilities.
- Experience creating technical and process documentation.
- Ability to write and execute basic to intermediate T-SQL queries.
- Experience analyzing and validating data across multiple systems.
- Strong written and verbal communication skills.
- Ability to work independently in evolving and fast-paced environments.
Technical Skills
Data & Analytics
- T-SQL
- Data Validation
- Data Analysis
- Relational Databases
- Data Integrity Testing
Development & Automation
- C#
- Python
- Code Review
- Debugging
- Automation Support
Reporting & Visualization
- Power BI
- Dashboard Development
- Data Reporting
AI Tools
- Microsoft Copilot
- ChatGPT
- Claude
Preferred Qualifications
- Experience with enterprise integrations or data integration platforms.
- Exposure to analytics and reporting environments.
- Understanding of database schemas and data movement processes.
- Experience supporting data validation, reconciliation, or quality assurance initiatives.
- Ability to thrive in environments with evolving requirements and processes.
Never miss an opportunity! Create an alert based on the job you applied for.
