• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

SQL Server Application Developer - Level 3 (REMOTE)

In United States

Save this job

SQL Server Application Developer - Level 3 (REMOTE)   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

SQL Server Application Developer - Level 3 (REMOTE)

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Hartford, CT United States

JOB DESCRIPTION:

 

Requisition ID

58966

Requisition Name

Application Developer - Level 3

Customer

CT DDS

Address

Position Location Remote

Address

460 Capitol Avenue Hartford, Connecticut 06106

Comment

Candidate must be local or willing to commute or relocate. 

 

No preference

 
 

Additional Location Details (City, State) :

   

Estimated Duration

08/31/2022 - 06/30/2023

Description

The project supports an initiative to collect data from an Electronic Visit Verification (EVV) System, which is mandated by the federal government for certain services. The project work is divided into several distinct tasks:

Design, implement, and fully test a solution for reading in and validating attendance data downloaded from the EVV system.
Design, implement, and fully test a solution for transforming the downloaded EVV data into a format that could be imported into DDS's Attendance system (WebResDay)
Design, implement, and fully test code that imports the validated (clean) attendance data into WebResDay
Design and implement a solution for maintaining EVV-to-WebResDay mappings of service codes, provider IDs (etc.)
Design, implement and fully test code that
Identifies visit records that are relevant to vendor-hire situations
Identifies the appropriate Fiscal Intermediary (FI) for each record
Applies additional validation logic to ensure that Medicaid claims will be processed correctly
Sends all vendor-hire visit records to the appropriate FI (via secure FTP)
Design, implement, and fully test code that imports non-EVV-qualifying attendance (service tracking) data
Develop documentation for all solutions.
Provide technical assistance to FIs as needed.

Required Skills/Experience:

Considerable experience with SQL Server Development, including tables, views, stored procedures, user-defined
Experience with Microsoft SSIS functions, and complex SQL DML.
Significant experience in C#
Extensive experience with unit testing (including both unit and integration testing), preferably using Xunit.
Experience with Visual Studio for development, testing, debugging and deploying applications.
Considerable experience with project support activities including:
Designing applications and databases
Tracking issues
Coordinating user acceptance testing
Creating technical documentation

 

Client Skill Matrix

Type Category Qualification Description Competency Experiences
Skills Database Microsoft SQL Server Considerable experience with SQL Server Development, including tables, views, stored procedures, user-defined functions Advanced (7-9 Years)  
Skills Languages C# Significant experience in C# Proficient (4-6 Years)  
 

 

Position Details

POSTED:

Jan 17, 2023

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16619904337933348

LOCATION:

United States

CITY:

Hartford, CT

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

SQL Server Application Developer - Level 3 (REMOTE)    Apply

Click on the below icons to share this job to Linkedin, Twitter!

<p> </p> <table style="border:none"> <tbody> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:1px solid black; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Requisition ID</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:1px solid black; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">58966</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Requisition Name</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Application Developer - Level 3</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Customer</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">CT DDS</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif">Address</span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Position Location Remote</span></span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Address</span></span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">460 Capitol Avenue Hartford, Connecticut 06106</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Comment</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <table style="background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-origin:initial; background-clip:initial"> <tbody> <tr> <td style="width:25%; padding:0in"> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Candidate must be local or willing to commute or relocate. </span></span></span></span></span></span></p> </td> <td style="width:2%; padding:0in"> </td> <td style="padding:0in"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">No preference</span></span></span></span></span></span></p> </td> <td style="padding:0in"> </td> </tr> <tr> <td style="padding:0in"> </td> <td style="width:25%; padding:0in"> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Additional Location Details (City, State) :</span></span></span></span></span></span></p> </td> <td style="padding:1px"> </td> <td style="padding:1px"> </td> </tr> </tbody> </table> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Estimated Duration</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">08/31/2022 - 06/30/2023</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; height:142px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Description</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; height:142px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p style="margin-bottom:9px"><span style="font-size:12pt"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:"Times New Roman", serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The project supports an initiative to collect data from an Electronic Visit Verification (EVV) System, which is mandated by the federal government for certain services. The project work is divided into several distinct tasks:</span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:12pt"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:"Times New Roman", serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Design, implement, and fully test a solution for reading in and validating attendance data downloaded from the EVV system.<br /> Design, implement, and fully test a solution for transforming the downloaded EVV data into a format that could be imported into DDS's Attendance system (WebResDay)<br /> Design, implement, and fully test code that imports the validated (clean) attendance data into WebResDay<br /> Design and implement a solution for maintaining EVV-to-WebResDay mappings of service codes, provider IDs (etc.)<br /> Design, implement and fully test code that<br /> Identifies visit records that are relevant to vendor-hire situations<br /> Identifies the appropriate Fiscal Intermediary (FI) for each record<br /> Applies additional validation logic to ensure that Medicaid claims will be processed correctly<br /> Sends all vendor-hire visit records to the appropriate FI (via secure FTP)<br /> Design, implement, and fully test code that imports non-EVV-qualifying attendance (service tracking) data<br /> Develop documentation for all solutions.<br /> Provide technical assistance to FIs as needed.</span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:12pt"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:"Times New Roman", serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333"><b>Required Skills/Experience:</b></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:12pt"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:"Times New Roman", serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Considerable experience with SQL Server Development, including tables, views, stored procedures, user-defined<br /> Experience with Microsoft SSIS functions, and complex SQL DML.<br /> Significant experience in C#<br /> Extensive experience with unit testing (including both unit and integration testing), preferably using Xunit.<br /> Experience with Visual Studio for development, testing, debugging and deploying applications.<br /> Considerable experience with project support activities including:<br /> Designing applications and databases<br /> Tracking issues<br /> Coordinating user acceptance testing<br /> Creating technical documentation</span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> </tbody> </table> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"> </span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><b>Client Skill Matrix</b></span></span></span></span></span></span></span></span></span></p> <table style="width:883px" width="882"> <colgroup> <col style="width:48pt" width="64" /> <col style="width:74pt" width="99" /> <col style="width:123pt" width="164" /> <col style="width:218pt" width="290" /> <col style="width:113pt" width="150" /> <col style="width:86pt" width="115" /> </colgroup> <tbody> <tr> <td class="gmail-xl64" style="border-bottom:1px solid black; height:20px; width:64px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:1px solid black; border-right:1px solid black; border-left:1px solid black"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black"><a name="RANGE!I13">Type</a></span></span></span></td> <td class="gmail-xl64" style="border-bottom:1px solid black; width:99px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:1px solid black; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black"><a name="RANGE!J13">Category</a></span></span></span></td> <td class="gmail-xl64" style="border-bottom:1px solid black; width:164px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:1px solid black; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black"><a name="RANGE!K13">Qualification</a></span></span></span></td> <td class="gmail-xl64" style="border-bottom:1px solid black; width:290px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:1px solid black; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black"><a name="RANGE!L13">Description</a></span></span></span></td> <td class="gmail-xl64" style="border-bottom:1px solid black; width:150px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:1px solid black; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black"><a name="RANGE!M13">Competency</a></span></span></span></td> <td class="gmail-xl64" style="border-bottom:1px solid black; width:115px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:1px solid black; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Experiences</span></span></span></td> </tr> <tr> <td class="gmail-xl65" style="border-bottom:1px solid black; height:57px; width:64px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Skills</span></span></span></td> <td class="gmail-xl65" style="border-bottom:1px solid black; width:99px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Database</span></span></span></td> <td class="gmail-xl65" style="border-bottom:1px solid black; width:164px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Microsoft SQL Server</span></span></span></td> <td class="gmail-xl65" style="border-bottom:1px solid black; width:290px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Considerable experience with SQL Server Development, including tables, views, stored procedures, user-defined functions</span></span></span></td> <td class="gmail-xl65" style="border-bottom:1px solid black; width:150px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Advanced (7-9 Years)</span></span></span></td> <td class="gmail-xl65" style="border-bottom:1px solid black; width:115px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black"> </span></span></span></td> </tr> <tr> <td class="gmail-xl66" style="border-bottom:1px solid black; height:20px; width:64px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:whitesmoke; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Skills</span></span></span></td> <td class="gmail-xl66" style="border-bottom:1px solid black; width:99px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:whitesmoke; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Languages</span></span></span></td> <td class="gmail-xl66" style="border-bottom:1px solid black; width:164px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:whitesmoke; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">C#</span></span></span></td> <td class="gmail-xl66" style="border-bottom:1px solid black; width:290px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:whitesmoke; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Significant experience in C#</span></span></span></td> <td class="gmail-xl66" style="border-bottom:1px solid black; width:150px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:whitesmoke; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black">Proficient (4-6 Years)</span></span></span></td> <td class="gmail-xl66" style="border-bottom:1px solid black; width:115px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:whitesmoke; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:15px"><span style="font-family:Helvetica,sans-serif"><span style="color:black"> </span></span></span> <div> <div dir="ltr"> </div> </div> </td> </tr> </tbody> </table> <p style="margin-bottom:11px"> </p>


Please wait..!!