← back to jobs
> job detail
C
👽Other

Data Integration & Interface Analyst

CSCI Consulting · Remote
// classified as
Other (Adjacent or hard to classify.)
posted
1d ago
location
Remote
languages
sql
tools
azure, excel
> stack
sqlazureexcel
> education
master
> description
<h3><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Job Description</span></h3> <p><span style="color: rgb(0, 45, 64);">CSCI Consulting is seeking a <strong>Data Integration &amp; Interface Analyst</strong> to support its Department of War (DoW / DoD) client. This role is responsible for helping define, validate, test, and stabilize mission-critical data integrations across source systems, staging environments, transformation layers, and downstream reporting platforms.</span></p> <p><span style="color: rgb(0, 45, 64);">Working closely with technical developers, ERP owners, finance stakeholders, data teams, and PMO resources, the Data Integration &amp; Interface Analyst ensures data moves accurately, completely, and reliably across the implementation landscape. This position plays a key role in source-to-target validation, reconciliation activities, interface testing, cutover readiness, production stabilization, and issue resolution supporting federal financial reporting and decision-making processes.</span></p> <h3><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Responsibilities</span></h3> <ul> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Support definition of integration requirements, interface specifications, mapping rules, control points, and validation criteria for data movement across source and target systems</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Assist in designing, testing, and validating batch interfaces, APIs, file-based integrations, and transformation jobs supporting OneStream and reporting platforms</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Validate source-to-target data movement across source applications, staging environments, data warehouses, and reporting outputs</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Perform reconciliation activities, including three-way reconciliations between source systems, transformed datasets, and downstream reports</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Identify and troubleshoot interface failures, rejected records, mapping defects, schema issues, data quality problems, and processing exceptions</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Coordinate with developers, system owners, and business stakeholders to investigate root causes and implement corrective actions</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Validate reference data, master data, hierarchies, and key attributes required for accurate financial reporting and operational processing</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Support System Integration Testing (SIT), User Acceptance Testing (UAT), cutover validation, deployment readiness, and production monitoring activities</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Maintain interface documentation, mapping specifications, reconciliation procedures, operational runbooks, and issue management records</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Assist with post-production stabilization by triaging data integration issues and supporting restoration of reliable end-to-end data processing</span></li> </ul> <h3><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Minimum Requirements</span></h3> <ul> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Active Secret Clearance required</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Bachelor's degree in Information Systems, Computer Science, Data Analytics, Accounting, Finance, Business, or a related field; equivalent experience may be substituted</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">5+ years of experience supporting data integration, interface management, ETL processes, system remediation, or enterprise platform implementations</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience working with source-to-target mapping, data transformation, interface controls, and reconciliation methodologies</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Strong understanding of batch processing, file-based integrations, APIs, and data movement architectures</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Ability to analyze data flows across multiple systems and identify root causes of data quality, transformation, and interface issues</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience supporting testing activities including SIT, UAT, defect triage, regression testing, and production readiness validation</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Familiarity with documentation standards, traceability requirements, change control, and implementation governance processes</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Proficiency with SQL, data analysis tools, Microsoft Excel, and collaboration platforms used for implementation delivery</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Creativity and adaptability in problem-solving</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Ability to work with clients to understand their needs</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Strong organizational and time-management skills</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Excellent written and verbal communication skills</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Professional presence</span></li> </ul> <h3><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Preferred Skills</span></h3> <ul> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience supporting OneStream, ERP, financial management, budgeting, accounting, or enterprise performance management implementations</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Familiarity with federal accounting structures, General Ledger (GL) concepts, Treasury reporting, GTAS, or government financial data flows</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience supporting financial data interfaces, ERP feeder systems, historical and current-state data migration, or downstream reporting platforms</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Knowledge of data validation, reconciliation frameworks, and automated controls used in compliance-driven environments</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience supporting cutover planning, deployment readiness, and production stabilization efforts</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Exposure to Advana integrations, financial reporting platforms, or enterprise analytics environments</span></li> <li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience with Azure, SQL Server, ETL platforms, Power BI, or enterprise data integration technologies</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Ability to work in a team environment, as well as independently</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Strong customer and vendor relationship skills</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Demonstrated ability to comply with data standards and policies</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Motivation to learn new technologies and methodologies that demonstrate value</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);">Past experience working with a Federal agency</span></li> <li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);">Department of War experience is a plus!</span></li> </ul><div class="content-conclusion"><h2><span style="font-family: montserrat light, arial, sans-serif; color: #00aae7;" data-contrast="none">About CSCI</span></h2> <p><span style="font-family: merriweather, georgia, serif; color: #002d40;"><span data-contrast="none">CSCI is an award-winning information technology and financial management consulting firm founded on one simple philosophy: “Do what is right, always.” We apply this philosophy across all elements of our growing business, from delivering world-class s</span><span data-contrast="none">ervices for customers to providing an environment where associates thrive both personally and professionally. At CSCI, work and fun aren’t diametrically opposed!</span></span></p> <p><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">At CSCI, our goal is to hire people with proven track records and retain them with an energizing, diverse company culture. We value each associate’s natural drive to excel, and we provide them with the freedom to do things their way. CSCI seeks the best and brightest in the industry—those who are ready to move their lives and career forward. Join us today and get excited about Mondays again!</span></p> <h3><span style="font-family: merriweather, arial, sans-serif; color: #002d40;" data-contrast="none">Benefits of Working at CSCI</span></h3> <ul> <li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">Competitive salaries</span></li> <li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">Generous Paid Time Off (PTO) package</span></li> <li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">Paid holidays aligned to the Federal calendar</span></li> <li style="color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;"><span data-contrast="none">Full health benefits including medical, dental, vision, and life insurance</span><span data-ccp-props="{&quot;335551550&quot;:6,&quot;335551620&quot;:6}">&nbsp;</span></span></li> <li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">401(k) retirement plan</span></li> <li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">Team building events</span></li> <li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;"><span data-contrast="none">Professional development support</span><span data-ccp-props="{&quot;335551550&quot;:6,&quot;335551620&quot;:6}">&nbsp;</span></span></li> </ul> <p>&nbsp;</p> <hr> <h3><span style="font-family: montserrat light, arial, serif; color: #b4bebe;" data-contrast="none"><br>Legal</span></h3> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">CSCI complies with all applicable Federal, state, and local employment regulations. Please reach out to </span><a style="color: rgb(180, 190, 190);" href="mailto:HR@csciconsulting.com"><span data-contrast="none"><span data-ccp-charstyle="Hyperlink">HR@csciconsulting.com</span></span></a><span data-contrast="none"> with any questions.</span><span data-ccp-props="{&quot;335551550&quot;:6,&quot;335551620&quot;:6}">&nbsp;</span></span></p> <h4><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none"><br>Equal Employment Opportunity</span></h4> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;">All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. CSCI provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans’ Readjustment Assistance Act. </span></p> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;">If you require an accommodation, please contact CSCI Human Resources for further assistance. For questions regarding the qualifications listed above, please contact the CSCI Recruiting Team.</span></p> <h4><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none"><br>E-Verify</span></h4> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">CSCI participates in E-Verify to confirm the employment eligibility of all newly hired employees. For more information, please visit </span><a style="color: rgb(180, 190, 190);" href="http://www.dhs.gov/E-Verify"><span data-contrast="none"><span data-ccp-charstyle="Hyperlink">www.dhs.gov/E-Verify</span></span></a><span data-contrast="none">.</span><span data-ccp-props="{}">&nbsp;</span></span></p> <h4><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none"><br>California Consumer Privacy Act (CCPA) Notice</span></h4> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">As part of the application and recruitment process, CSCI Consulting, Inc. may collect personal information as described under the California Consumer Privacy Act (CCPA).&nbsp;</span></p> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">This information is collected solely for employment-related purposes, including evaluating your qualifications, processing your application, and complying with legal obligations.</span><span data-ccp-props="{}">&nbsp;</span></span></p> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">By applying to this position, you acknowledge that you have read and understand the following notice regarding the collection of your personal information as a job applicant:</span><span data-ccp-props="{}">&nbsp;</span></span></p> <ul> <li style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-leveltext="" data-font="Symbol" data-listid="41" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">Categories of Information Collected: Personal identifiers, employment history, educational information, and any other information provided in your application or as part of the interview process.</span></li> <li style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-leveltext="" data-font="Symbol" data-listid="41" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">Purposes for Collecting Information: To review your application, assess your qualifications, and manage the hiring process.</span></li> <li style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-leveltext="" data-font="Symbol" data-listid="41" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">Retention and Security: Information collected will be retained indefinitely and will be securely stored and handled in accordance with CCPA guidelines and CSCI Consulting, Inc. policies.</span></li> <li style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-leveltext="" data-font="Symbol" data-listid="41" data-list-defn-props="{&quot;134233528&quot;:true,&quot;335551500&quot;:0,&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">Rights of Applicants: Under CCPA, California residents have the right to request information about the personal data we collect, delete it, and request restrictions on certain uses. However, some information may be retained as required by law.</span><span data-ccp-props="{}">&nbsp;</span></span></li> </ul> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">For further information, or to exercise your rights under the CCPA, please contact CSCI’s HR team.</span><span data-ccp-props="{}">&nbsp;</span></span></p> <h3><span style="font-family: montserrat light, arial, sans-serif; color: #b4bebe;" data-contrast="none"><br>Disclaimer</span></h3> <p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">The above declarations are not intended to be an all-inclusive list of the duties and responsibilities of the job described, nor are they intended to be such a listing of the skills and abilities required to do the job. Rather, they are intended only to describe the general nature of the job.</span></p></div>