MIRACORP Inc. is looking to modernize, improve the reliability, and enhance the scalability of enterprise Excel-based compensation tools that support DoD organizations by converting legacy VBA solutions into secure, non-VBA macro reliant workbooks and integrating data flows with web platforms.
Requirements
- Advanced Microsoft Excel skills: dynamic arrays, named ranges, Power Query, PowerPivot, pivot tables/charts, data validation, and conditional formatting.
- Hands-on experience using Power Query for data shaping, merges, refresh workflows, and connectivity to multiple sources.
- Proven ability to replicate VBA logic using native Excel features (no-code/low-code approach).
- Experience designing structured test cases/parallel runs, documenting results, and managing defect resolution.
- Working knowledge of data interoperability between Excel and web systems (file formats, schema mapping, secure transfer).
- Strong technical writing for user documentation, testing logs, and implementation guides.
- Python, SQL, and other query or programming languages (preferred) for prototyping, data validation, or utility scripts.
Responsibilities
- Build, modernize, and sustain enterprise-grade, non-VBA reliant Excel tools using dynamic arrays, advanced formulas, Power Query, pivot models, and robust validation/controls.
- Define and manage import/export processes between Excel tools and web systems; collaborate with external dev teams to align formats, interfaces, and data requirements.
- Design parallel/validation tests to ensure parity with legacy outputs; document test results; track and resolve defects; maintain release notes and version control.
- Translate complex logic into accessible guidance; develop user manuals, SOPs, and quick-reference guides; deliver onboarding and training sessions.
- Gather feedback through surveys and support channels; analyze findings to prioritize enhancements and improve usability.
- Serve as the primary technical point of contact for spreadsheet issues; triage incidents, fix bugs, manage configurations, and ensure consistent performance at scale.
- Independently plan work across multiple timelines, aligning releases with compensation cycles and organizational priorities while upholding data security and compliance.
Other
- Bachelor degree in Business Information Technology, Information Systems, Computer Science, Data Analytics, or related field (or equivalent experience).
- 3+ years building/supporting enterprise or government Excel-based tools.
- Excellent communication with technical and non-technical audiences; critical thinking, ownership, attention to detail, and the ability to manage multiple projects in dynamic environments.
- Familiarity with CAS2Net or similar DoD compensation/HR systems and the AcqDemo environment.
- Experience in Agile/iterative collaboration (sprints, backlogs, user stories).
