DHHS - Programmer Analyst 6

Project Scope:

This Programmer Analyst 6 position will work as contract resource for the State of Michigan - Department of Technology, Management and Budget (DTMB) in a staff augmentation capacity supporting the Bureau of Audit and Long-Term Care divisions for the Department of Health and Human Services (DHHS).

Roles/Responsibilities:

• This position will be responsible for project analysis, and estimation, application design, coding, compiling, testing, and debugging, implementing, and maintain applications across multiple technologies.
• This position will be responsible for following processes needed to ensure required rules and regulations are implemented and maintained to meet the growing complexities associated with the Federal Medicaid programs.
• This position will act as the liaison between MDHHS, DTMB Customer Service, other departments within the State of Michigan and outside vendors and be responsible for Medicaid Reimbursement projects.
• The resource will act as a developer and analyst in an agile environment on a small development team to write and test code to implement the user stories and requirements for various ongoing new development and maintenance projects.
• Applications are developed using Angular, ASP.NET, C# 4.6 and/or.NET 6 CORE using REST/SOAP web services, XAML, HTML and, SQL Server.
• Write well-designed, testable code using Angular, ASP.NET, C#.NET, XAML, HTML, SQL Server.
• Develop business application components using Object Oriented with C#, and design principles.
• Develop and maintain SSRS reports.
• Design and develop RESTful Web Services using Web API framework.
• Execute full software development life cycle (SDLC) including experience in gathering requirements and writing functional/technical specifications for complex projects.
• Excellent knowledge in designing both logical and physical database model
• Develop database objects including stored procedures, functions
• Troubleshoots issues using TSQL Scripts
• Experience tuning SQL queries and scripts and Entity Framework model
• Hands on experience Integrating software components into a fully functional software system
• Extensive knowledge on source control tools such as GIT
• Experience on Build Frameworks like CICD pipeline and maintain source code using source control, and baseline software versions and build war files for deployments
• Experience developing with application servers AZURE, and IIS
• Develop software design documents and work with stakeholders for review and approval.
• Experience developing, prototypes, mockup for users review and approval.
• Experience creating flowcharts, screen layouts and documentation to ensure logical flow of the system requirements
• Experience working on large agile projects.
• Experience with ASP.Net identity server, Logging frameworks.
• Good to have knowledge of Azure web services
• Experience in Database Design in Oracle and SQL server.
• Nice to have - OpenShift/Kubernetes Container
• Lead 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.
• Ability to provide quality customer service, build trust through integrity of work, and build strategic relationships through teamwork are required.

Mandatory Skills:

1. 9+ years of Angular, HTML, C#.Net, SQL Server and Entity Framework.
2. 5+ years of experience of 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.
3. 5+ years of recent experience working with configuration, administration, and maintenance of the Microsoft IIS Platform.
4. Ability to gather and analyze facts, define problems, and devise solutions.
5. Ability to provide quality customer service, build trust through integrity of work, and build strategic relationships through teamwork are required.

Desirable Skills:

1. 5+ years of SSRS, XAML, ASP.Net, MVC Architecture and MVVM Architecture.
2. 5+ years of experience developing with SOAP, and REST web service interfaces.
3. 5+ years of experience with TSQL/SQL including writing and maintaining complex Select/Insert/Update statements.
4. 7+ years of experience with Agile / SCRUM processes and working an Sprint Development team.
5. 5+ years of experience working with Azure DevOps / TFS using boards and code repository.
6. 7+ years of experience working with GIT code repository software.
7. 7+ years of experience developing unit and regression tests.
8. 7+ years of experience developing secure websites using industry best practices (such as preventing cross site scripting or SQL injection attacks and coding security logging into software functionality).
9. Ability to prepare detailed written instructions and documentation.
10. Ability to effectively make oral and written reports and presentations and prepare clear and concise graphs and charts.
11. Ability to effectively work independently or with a software development team, make decisions related to assigned tasks, analyze business requirements, create design specifications, and construct and test computer systems.
12. Knowledge of fundamental Project Management Methodology (PMM) is desirable but not required.