Technical Analyst (MS Access DB SME)

Job Title: Technical Analyst (MS Access DB SME)

Job Location: Reston,VA

Job Duration: 12 Months

Note : Hybrid role. Mainly remote, but must be in DC/MD/VA (DMV) .. Will be required to come onsite to Reston, VA or DC office 1-2x per month. Could be more, could be less. Wants DMV based candidates to avoid any onsite issues.

Job Description

We are seeking a Technical Analyst to spearhead the modernizing of our data architecture by sunsetting a critical, legacy MS Access database and designing its modern replacement. This database was custom-built 5-6 years ago to bridge reporting between SAP Ariba and Oracle, but it is now hitting its technical limits.

In this role, you will lead the comprehensive technical assessment of the current state database, map out its complex data dependencies, and architect a future-state roadmap. You will act as the Subject Matter Expert (SME) who bridges the gap between legacy systems and modern database technology, ensuring zero business disruption during the transition.

Key Responsibilities
- Database Assessment: Dive deep into a complex, homegrown MS Access database to reverse-engineer its structure, queries, macros, and logic.
- Architecture & Future State Design: Evaluate modern database technologies and provide definitive guidance/recommendations on the optimal future-state platform to replace MS Access.
- Integration Mapping: Ensure the new technical solution seamlessly maintains and improves live data connections into SAP Ariba and Oracle databases.
- Roadmapping & Strategy: Formulate technical milestones, project roadmaps, and transition plans alongside change managers and executive stakeholders.
- Data Extraction: Write advanced SQL queries to analyze data structures, validate data integrity, and ensure smooth future migrations.
- Reporting Optimization: Design the future-state infrastructure to significantly enhance overall enterprise reporting capabilities.

This position requires onsite visits to our clients Reston VA or Washington DC office 2x per month and also requires a final round onsite interview in Reston VA.

< class="font-size-5 text-black-2 font-weight-semibold mb-6">Required Skills

Required Skills & Experience

Info is coming from SAP Ariba/Oracle - both would be great but SAP is a must
- MS Access Subject Matter Expert: Deep, hands-on technical knowledge of Microsoft Access database navigation, design, backend logic, and limitations.
- Enterprise ERP Experience: Proven experience working with data flowing out of SAP Ariba (Required) and Oracle DB (Strong Plus). A diverse enterprise tech stack can substitute for Oracle, but SAP knowledge is required.
- Advanced SQL: Strong, hands-on SQL querying skills to extract, manipulate, and analyze complex datasets.
- Technical Leadership: Ability to collaborate with technical stakeholders, map out project roadmaps, and track technical milestones.
- Local to DMV: Must reside in the Washington D.C., Maryland, or Virginia area to attend the office in Reston or D.C. 1-2 times per month.

** Preferred (Nice-to-Have) Qualifications **
- ServiceNow: Experience with ServiceNow is a major advantage as the organization is actively undergoing an enterprise implementation.
- Healthcare Payor Industry: Prior experience working within the healthcare payor space.
- Project Management: A PMP background or strong project-tracking/milestone management experience.