Data Engineer

Apollo Technology Solutions LLC • Little Rock, AR, US • 5d ago

Title: Data Engineer
Location: Little Rock, AR
Duration: 7+ months

Job Description:

Stabilize and support an existing Microsoft Access database application used in daily accounting operations
Diagnose issues, implement bug fixes, ensure reliability of daily workflows, and create documentation
Troubleshoot and resolve defects in the existing Access front end and SQL Server back end
Ensure daily operational workflows function consistently and accurately
Document business logic, database relationships, and application workflows to enable internal support
Provide knowledge transfer to Office of Internet Technology (Client) staff
Collaborate professionally with business stakeholders to clarify issues and confirm successful resolutions
Coordinate with the modernization project team to ensure continued alignment, without performing modernization work

Skills:

5+ years of experience in Microsoft Access / VBA for debugging and maintenance of existing forms, queries, and modules
5+ years of experience SQL Server experience (queries, stored procedures, debugging)
5+ years of experience reverse-engineering and maintaining legacy systems without redesigning them
5+ years of experience MS Access SQL and Query design
4+ years of experience translating business logic from macros/modules/queries to SQL
4+ years of experience writing stored procedures, PL/SQL, and migrating tables from MS Access to SQL Server
4+ years of experience converting MS Access Forms/Reports to any web-based application
3+ years of experience splitting MS Access Databases into Front Ends and Back Ends
Ability to follow change control, documentation, and testing processes
Comfortable working within existing architecture and constraints

Preferred Skills:

Understanding of accounting or financial workflow systems
Prior experience stabilizing legacy applications during transition to new platforms
Strong written and verbal communication skills for documentation and knowledge transfer
QuickBase Rapid Application Development Platform