• SQL Db Entity Framework Analyst

    COOLSOFT (Lansing, MI)


    SQL Db Entity Framework Analyst

     

    (Jobs in Lansing, MI)

     

    Requirement id 154131

     

    Job title Analyst

     

    Job location in Lansing, MI

     

    Skills required Angular Developer, HTML Development, C#, SQL Db Entity Framework

     

    Open Date 01-Jul-2025

     

    Close Date

     

    Job type Contract

     

    Duration 12 Months

     

    Compensation DOE

     

    Status requirement ---

     

    Job interview type ---

     

    Email Recruiter:coolsoft

     

    Job Description Analyst: Angular Developer, HTML Development, C#, SQL Db Entity Framework

     

    Start Date :8/4/2025

     

    End Date :1 Years from projected start date

     

    Submission Deadline :7/7/25 at 10:00 am EST

     

    Client Info : DHHS

    Note:

    * Interview Process: 1st round will be held via MS Teams. 2nd round may be held in-person, so candidates must be available for an in-person interview.

    * Duration: 1 year with possible extension.

    * Remote or On-site: Accepting local candidates ONLY (within 90-minute drive of Lansing). Position will be hybrid, in office 2 days a week (Mon/Tue) upon start and there is NO REMOTE ONLY option.

    Description:

    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). 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.

    Position Summary:

    • 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

     

    Call502-379-4456 Ext 100for more details. Please provide Requirement id: 154131 while calling.