Data Engineer

Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Data Engineer to play a key role within a high-impact technical services team. Work Location: 100% Remote Responsibilities The Worker(s) will provide the following services: Perform analyst work overseeing one or more projects concurrently. Complete evaluations of existing and future capabilities, conduct research into solution alternatives, enhance system capabilities, and provide advice to stakeholders. Participate in joint application design sessions with customers and IT staff to define business requirements and develop software systems requirements. Communicate effectively with users to determine requirements of new processes and applications or modifications to existing processes and applications. Perform system configuration, document business processes and prepare project documentation with a high level of attention to detail, strong organization skills and technical aptitude. Use standardized project management processes, tools and techniques to address project needs. Develop test artifacts and conduct testing to include User Acceptance Testing (UAT) and develop training documentation for various team projects. Work closely with developers to track defects and resolutions. Perform deep technical and analytical reviews to analyze system functionality with customers and resolve production issues. Assist with creating, maintaining and enforcing global standards. Perform other analysis and documentation tasks as required to facilitate and support team projects. Assist in the diagnosis of problems associated with applications and write detailed specifications for developing or correcting issues to improve system performance and/or accuracy. Perform other duties as assigned to maintain operations. Qualifications Minimum Requirements: 4-7 years of: • Experience with system integrations and data exchange interfaces • Microsoft Office Suite (Excel, Word, Visio) • Analyzing data from a variety of source systems and different database technologies using SQL • Experience with Data Mapping and Transformation • Experience with Interface/Architecture design and documentation • Converting business requirements into technical specifications • Gathering, analyzing, and generating data visualization requirements for a data warehouse • Experience writing detailed test cases and test scenarios • Strong understanding of end-to-end systems validation • Experience in writing SIT and UAT test plans • Experience in working on a data warehouse (both relational and dimensional) team (DB2) • Experience in translating requirements into data visualization needs • Experience with XML/JSON/API integrations • Familiarity with REST/SOAP services and Secure data exchange (SFTP, certificates) Preferred Qualifications: 2 years of: • Unemployment Insurance (UI) or workforce systems (highly preferred) • Experience working with SIDES modules (EVF, ADF, DD, BC, MPC) • Experience with Natural programming language • Experience in Public Sector delivery • Client experience Overview At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including: • Highly competitive pay rates • Local support staff for responsive, personal service • Comprehensive benefits package, including: • Medical insurance (with employer cost sharing) • Life insurance • A 401(K) plan with company match • Flexible spending through a cafeteria plan Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks. Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.