Data Integration Analyst
Niktor LLC
Roseville, United States of America
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
EnglishJob location
Roseville, United States of America
Tech stack
Artificial Intelligence
Data analysis
C Sharp (Programming Language)
Databases
Data Validation
Data Integration
Data Integrity
ETL
Relational Databases
Software Debugging
Python
Power BI
Data Streaming
T-SQL
Data Analytics
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, 1. esCreate, maintain, and continuously update documentation for newly established and evolving integration processe
- s.Validate integration data within a new integrated environment, confirming tha
- t:Existing data is flowing correctly through the syste
- m.Newly introduced data can be accurately validated and prove
- n.Perform detailed data analysis to isolate and validate specific data sets based on provided directio
- n.Confidently report findings, identify anomalies, and propose practical improvements to integration processes and data flow
- s.Produce clear, well-structured documentation at multiple levels of technical depth, includin
- g:Process flo
- wsBusiness and technical rul
- esAssumptions and dependenci
- esData validation approach
- esFrequencies and timing of integration activiti
- esEnsure documentation clearly defines user roles, responsibilities, and expectations within each portion of the process to support effective communication and adoptio
n. Technical Expectati
- onsCreate and use basic to intermediate T-SQL queries to validate, analyze, and substantiate integration resul
- ts.Basic and working knowledge of AI tools including Copilot, Claude and ChatG
- PT.Analyze database-level data to support data integrity checks and root-cause investigatio
- ns.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 workflo
- ws.Develop lightweight internal Power BI reports or dashboards, as needed, to summarize findings, trends, and high-level activity metrics related to integration validati
Requirements
- ionsStrong technical aptitude and the ability to quickly understand complex systems and data fl
- ows.Prior exposure to relational database schemas and data-driven syst
- ems.Ability to take direction efficiently and apply it to focused validation and analysis ta
- sks.Demonstrated ability to clearly communicate technical findings to both technical and non-technical audien
- ces.Proven experience producing clear, usable documentation that supports cross-functional understanding and collaborat
ion. Desired Attri
- butesFamiliarity with enterprise data integrations or analytics environm
- ents.Strong analytical mindset with attention to de
- tail.Comfortable working in evolving environments with partially defined proce