Job Title: Programmer Analyst 6
Location: Lansing, MI
Onsite/Remote/Hybrid: Hybrid
Duration : 1 year
Contract/Perm: Contract
Rate: $50 per hour
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:
- 9+ years of Angular, HTML, C#.Net, SQL Server and Entity Framework.
- 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.
- 5+ years of recent experience working with configuration, administration, and maintenance of the Microsoft IIS Platform.
- Ability to gather and analyze facts, define problems, and devise solutions.
- Ability to provide quality customer service, build trust through integrity of work, and build strategic relationships through teamwork are required.
Desirable Skills:
- 5+ years of SSRS, XAML, ASP.Net, MVC Architecture and MVVM Architecture.
- 5+ years of experience developing with SOAP, and REST web service interfaces.
- 5+ years of experience with TSQL/SQL including writing and maintaining complex Select/Insert/Update statements.
- 7+ years of experience with Agile / SCRUM processes and working an Sprint Development team.
- 5+ years of experience working with Azure DevOps / TFS using boards and code repository.
- 7+ years of experience working with GIT code repository software.
- 7+ years of experience developing unit and regression tests.
- 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).
- Ability to prepare detailed written instructions and documentation.
- Ability to effectively make oral and written reports and presentations and prepare clear and concise graphs and charts.
- 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.
- Knowledge of fundamental Project Management Methodology (PMM) is desirable but not required.