Systems Analyst 2 (Data Integration & Data Warehouse Support)
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Job Title: Systems Analyst 2 (Data Integration & Data Warehouse Support)
Location: 100% Remote (U.S.-based)
Duration:
3-month contract with possible extensionKey ResponsibilitiesSupport system integrations and enterprise data exchange interfacesAnalyze data from multiple source systems using SQLPerform data mapping and transformation across relational and dimensional environmentsConvert business requirements into technical specificationsDesign and document interface architecture and integration workflowsGather and define data visualization requirements for reporting environmentsDevelop detailed test cases and test scenariosSupport SIT and UAT planning and execution activitiesPerform end-to-end systems validation across integration pipelinesSupport XML, JSON, and API-based integrationsSupport secure data exchange using SFTP and certificate-based authenticationCollaborate with business, reporting, and integration stakeholdersRequired Qualifications4–7 years of experience with system integrations and data exchange interfaces4–7 years of experience using Microsoft Office Suite (Excel, Word, Visio)4–7 years of experience analyzing data from multiple source systems using SQL4–7 years of experience with data mapping and transformation4–7 years of experience with interface and architecture design documentation4–7 years of experience converting business requirements into technical specifications4–7 years of experience gathering, analyzing, and generating data visualization requirements for a data warehouse4–7 years of experience writing detailed test cases and test scenarios4–7 years of strong understanding of end-to-end systems validation4–7 years of experience writing SIT and UAT test plans4–7 years of experience working on a data warehouse team (relational and dimensional) using DB24–7 years of experience translating requirements into data visualization needs4–7 years of experience with XML/JSON/API integrations4–7 years of familiarity with REST/SOAP services and secure data exchange (SFTP, certificates)
Preferred Qualifications:
2+ years of experience supporting Unemployment Insurance (UI) or workforce systems 2+ years of experience working with SIDES modules (EVF, ADF, DD, BC, MPC)2+ years of experience with Natural programming language 2+ years of experience working in public-sector delivery environments 2+ years of experience supporting Texas Workforce Commission projectsAdditional Submission RequirementsResume must include Photo ID at the beginningMaximum of two candidate submissions allowed per vendorCandidate must be available to work remotely within U.S. business hours