Job Description:

Essential Duties and Responsibilities:

• Lead the development of software solutions that will meet or exceed business requirements; the development effort includes designing and implementing modules to the system specifications, conducting unit testing, troubleshooting issues, and producing detailed proposals to resolve issues.
• May evaluate new coding techniques, tools, modules, and implementation as appropriate.
• Consult on requirements elicitation and definition.
• Perform data analysis and data migration.
• Document data interfaces and data mappings; analyze and interpret data, and conduct data sourcing activities.
• Develop data mapping, data validation, and data reports, and support existing applications using SQL Server programming such as stored procedures, functions, triggers, and writing complex queries.
• Produce efficient and optimized queries.
• Perform ETL (Extract, Transform and Load) using SQL Server Integration Services (SSIS) packages.
• Work with developers and supervisors to assure specifications are understood and followed.
• Work with existing systems developed using technologies like SP.NET C# and use reverse engineering techniques to extract business rules and validations.
• Document business rules and requirements, and design and execute Data Quality checks.
• Work with business users and other peers for testing, debugging, remediating defects, and providing testing results documentation.

• Minimum of eight years developing web applications in C#, SP.NET using MVC architecture with at least one year using .NET Core.
• Minimum 8 years of advanced technical skills in creating and modifying SQL procedures, stored procedures, triggers, and database technologies using MS SQL Server.
• Experience in designing and developing SQL Server Integration Services (SSIS) ETL packages.
• Experience in designing and developing REST APIs.
• Experience in implementing enterprise application patterns using Object Oriented Programming.
• Knowledgeable in unit testing of software.
• Working with State government clients is a plus.
• Working with Medicaid and MMIS systems is a plus.
• DOTNET certification preferred.

• Requires a minimum of 8 years of related experience with a Bachelors degree; 6 years and a Masters degree; or equivalent experience.
• bility to perform complex tasks with minimal supervision and guidance.
• Good verbal and written communication skills.