Programmer Analyst

Location:

Lansing, MI (Hybrid Locals Only) Duration: 12 Months Position Justification

This Programmer Analyst position will work as a contract resource for the State of Michigan - Department of Technology, Management and Budget (DTMB) in a staff augmentation capacity supporting the Bureau of Audit’s and Long Term Care Reimbursement (LTCR) and Office of Audit (OA) divisions for the Department of Health and Human Services (DHHS). This position will act as a senior developer in a hybrid waterfall/agile environment on a small development team to write and test code to implement the user stories and requirements for the Long Term Care Reimbursement project.

• Large projects involving the Bureau of Audit’s (BOA) Long Term Care Reimbursement (LTCR) and Office of Audit (OA) divisions.
• Following SUITE processes to ensure required rules and regulations are implemented and maintained to meet the growing complexities associated with the Federal Medicaid programs.
• Project analysis, estimation, application design, coding, compiling, testing, debugging, and implementing applications across multiple technologies.
• A resource filling this position must have deep and broad knowledge of the inner workings of, as well as the business use of, the applications supporting the business processes of the Long Term Care Reimbursement (LTCR) and Office of Audit (OA) divisions within the MDHHS Bureau of Audit.

• Lead application development efforts for large-scale systems within a State of Michigan environment, following DTMB SUITE methodology and Agile frameworks.
• Design, Develop and maintain applications using C#.Net and Angular.
• Writing user acceptance test plans, creating required test data, and assisting users with running tests.
• Participating in requirements gathering session to document scoping, definition, analysis, business design, and technical design phases
• Coordinating application development and scheduling interfaces with cross-functional teams
• Assisting with debugging complex coding issues.
• Author technical standards, choose technology, and create technical solutions.
• Develop and maintain SSRS reports.
• Extensive knowledge on source control tools such as GIT
• Participate in artifact reviews with peers, system specialists, Enterprise Security and other DTMB entities to ensure IT solutions and applications adhere to DTMB and agency policies, standards, and guidelines.
• Coordinate with security resources to ensure systems are properly designed on DTMB and Agency security requirements and standards.
• Participate in Solutions Design Team (SDT) meetings and assist in the creation of Enterprise Architecture Solution Assessments (EASA), infrastructure Service Requests (ISR), Hosting documents, and Firewall Rules as needed.
• Develop database objects including stored procedures, functions, triggers, and packages using SQL and PL/SQL.
• Troubleshoot issues using SQL, PL/SQL scripts
• Hands‑on experience Integrating software components into a fully functional software system
• Ensure proper change management is followed and documented for all changes to system designs and prod changes.
• Development training content and facilitate training.
• Actively participate in the development and implementation of assigned client agency’s strategic direction/plan.
• Serve as technical resource to the Project Manager and liaison to the PMO to assist with resolving project issues.

• 10+ years’ experience of developing complex systems using C#/.NET and Java (Eclipse IDE).
• 10+ years of advanced experience in SQL and PL/SQL development.
• 5+ years of recent experience writing, compiling, modifying, and debugging complex SQL Server database configuration items, including, but not limited to, Stored Procedures, Functions, Triggers, Views, Tables, and linked servers.
• 5+ years of experience using Azure Dev Ops (ADO) for backlog management, sprint planning, task tracking, and Agile progress reporting.
  7+ years of experience working with GIT code repository software.
• 5+ years of experience working with Git for version control and source code management.
• 5+ years of experience developing and executing unit and regression tests to ensure application reliability and stability.
• Strong experience developing secure web applications, implementing industry best practices to prevent vulnerabilities such as cross-site scripting (XSS) and SQL injection, including secure logging practices.
• Exposure to Dev Ops practices and cloud platforms including AWS and Microsoft Azure.
• Hands‑on experience using Git Hub Copilot to accelerate daily coding tasks, including code generation, refactoring and documentation.
• Proven ability to integrate Git Hub Copilot into development workflows to enhance productivity, code quality, and team collaboration.