Search for Similar jobs

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.

Let me know if you have any questions.

Application Systems Analysis/Programming Manager - Level 1 (SQL server)--58701

In United States

Save this job

Apply Here Save this job

Application Systems Analysis/Programming Manager - Level 1 (SQL server)--58701

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

JOB TITLE:

Application Systems Analysis/Programming Manager - Level 1 (SQL server)--58701

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Hartford, CT United States

JOB DESCRIPTION:

Requisition ID

58701

Requisition Name

Application Systems Analysis/Programming Manager - Level 1

Customer

CT DPH

Address

Position Location Remote

Address

410 Capitol Avenue, MS #11EPI Hartford, Connecticut 06134

Comment

Candidates must be local or willing to commute or relocate.		Candidate Must Be Local
	Additional Location Details (City, State) :

Estimated Duration

08/15/2022 - 07/31/2023

Description

Statement of Work for DPH ID and Fiscal (COVID) Grants Management Reporting

Job Title: Application Systems Analyst/Programmer

Required Skills: SQL Server (2016, 2019), SSIS, C#, PowerBI Data Modeling, PowerBI Reports

Time Frame: August 15, 2022 – Jul 2023

Hours Per Week: 40

Work Schedule: TBD

Initial Projects:

1. Fiscal Data Modeling – generate PowerBI data models based on extracts from the State of Connecticut's fiscal management system. Initial work will be to utilize manual extracts of data and develop the process within PowerBI to generate a Star Data Model that can be used as an operational prototype.

2. PowerBI Report Generation – develop and publish fiscal reports in PowerBI that can be used by DPH Business Office staff, Principal Investigators of grants and cooperative agreements, and DPH Leadership.

3. Document Modeling Processes - Develop the documentation that provides detailed information on the steps taken to generate the Fiscal Data Model (star data model developed in #1).

4. Develop Production ETL for Fiscal Data Model – coordinate with DPH IT to create a robust automated ETL (Extract Transform and Load) process that consumes fiscal data from the fiscal management system and publishes that data to a SQL Server based Fiscal Data Model.

5. Other DPH IT and/or ID Informatics data modeling support as needed

6. Preferred skills: Data Modeling in PowerBi, SQL Server Query Development and Experience with fiscal data

Please fill the below Skill Matrix:

Qualifications

Type	Category	Qualification	Competency
Skills	Database	Data Warehousing	Proficient (4-6 Years)
Skills	Database	Microsoft SQL Server	Proficient (4-6 Years)
Skills	Others	Business Intelligence Analyst Planner	Proficient (4-6 Years)
Skills	Tools	SQL Server Reporting Services (SSRS)	Proficient (4-6 Years)

Position Details

POSTED:

Jan 17, 2023

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16619904324343102

LOCATION:

United States

CITY:

Hartford, CT

Job Origin:

OORWIN_ORGANIC_FEED

Application Systems Analysis/Programming Manager - Level 1 (SQL server)--58701 Apply

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

<table style="color:#222222; font-family:Arial, Helvetica, sans-serif; font-size:small; font-style:normal; font-variant-ligatures:normal; font-weight:400; text-align:start; white-space:normal; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; border-collapse:collapse; 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"> Requisition ID </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"> 58701 </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"> Requisition Name </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"> Application Systems Analysis/Programming Manager - Level 1 </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"> Customer </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"> CT DPH </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"> Address </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"> Position Location Remote Address 410 Capitol Avenue, MS #11EPI Hartford, Connecticut 06134 </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"> </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"> </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"> Comment </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; border-collapse:collapse"> <tbody> <tr> <td style="width:25%; padding:0in"> Candidates must be local or willing to commute or relocate. </td> <td style="width:2%; padding:0in"> </td> <td style="padding:0in"> Candidate Must Be Local </td> <td style="padding:0in"> </td> </tr> <tr> <td style="padding:0in"> </td> <td style="width:25%; padding:0in"> Additional Location Details (City, State) : </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"> Estimated Duration </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"> 08/15/2022 - 07/31/2023 </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"> Description </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"> Statement of Work for DPH ID and Fiscal (COVID) Grants Management Reporting Job Title: Application Systems Analyst/Programmer Required Skills: SQL Server (2016, 2019), SSIS, C#, PowerBI Data Modeling, PowerBI Reports Time Frame: August 15, 2022 – Jul 2023 Hours Per Week: 40 Work Schedule: TBD Initial Projects: 1. Fiscal Data Modeling – generate PowerBI data models based on extracts from the State of Connecticut's fiscal management system. Initial work will be to utilize manual extracts of data and develop the process within PowerBI to generate a Star Data Model that can be used as an operational prototype. 2. PowerBI Report Generation – develop and publish fiscal reports in PowerBI that can be used by DPH Business Office staff, Principal Investigators of grants and cooperative agreements, and DPH Leadership. 3. Document Modeling Processes - Develop the documentation that provides detailed information on the steps taken to generate the Fiscal Data Model (star data model developed in #1). 4. Develop Production ETL for Fiscal Data Model – coordinate with DPH IT to create a robust automated ETL (Extract Transform and Load) process that consumes fiscal data from the fiscal management system and publishes that data to a SQL Server based Fiscal Data Model. 5. Other DPH IT and/or ID Informatics data modeling support as needed 6. Preferred skills: Data Modeling in PowerBi, SQL Server Query Development and Experience with fiscal data </td> </tr> </tbody> </table> Please fill the below Skill Matrix: <div id="gmail-m_3331104341492825907gmail-covSection-10" style="text-align:start"> </div> <div id="gmail-m_3331104341492825907gmail-covSection-11" style="text-align:start"> </div> <div id="gmail-m_3331104341492825907gmail-covSection-12" style="text-align:start"> <div name="divQual1"><a aria-expanded="true" href="https://secure.covendis.com/uWorkd/SupplierAppBoot/#divtogsupnegskills" name="m_3331104341492825907_divtogsupnegskills" style="color:#277ba7; box-sizing:border-box; text-decoration-line:none; font-weight:bold" target="_blank">Qualifications</a> <div style="border:1px solid #dddddd; margin-bottom:17px; border-radius:4px"> <div aria-expanded="true" id="gmail-m_3331104341492825907gmail-divtogsupnegskills" name="divtogsupnegskills" style="border:0px"> <table name="tblT2qryJsePosSkills" style="border-collapse:collapse; border-spacing:0px; font-size:inherit; font-weight:inherit; font-style:inherit; font-variant:inherit; width:1287px; max-width:100%; border-top-right-radius:3px; border-top-left-radius:3px"> <tbody style="box-sizing:border-box"> <tr> <th style="box-sizing:border-box; padding:8px 3px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd; border-top-left-radius:3px"> </th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"><a name="m_3331104341492825907_rtv_id" style="color:#222222; box-sizing:border-box">Type</a></th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"><a name="m_3331104341492825907_rsc_name" style="color:#222222; box-sizing:border-box">Category</a></th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"><a name="m_3331104341492825907_psk_search_value" style="color:#222222; box-sizing:border-box">Qualification</a></th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"><a name="m_3331104341492825907_srPSK_DESCRIPTION" style="color:#222222; box-sizing:border-box">Description</a></th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"><a name="m_3331104341492825907_sel_slf_id" style="color:#222222; box-sizing:border-box">Competency</a></th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Consultant years of experience</th> <th style="box-sizing:border-box; padding:8px 1px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </th> <th style="box-sizing:border-box; padding:8px 3px; text-align:left; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd; border-top-right-radius:3px"> </th> </tr> <tr> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Skills</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Database</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Data Warehousing</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Proficient (4-6 Years)</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> </tr> <tr> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Skills</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Database</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Microsoft SQL Server</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Proficient (4-6 Years)</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> </tr> <tr> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Skills</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Others</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Business Intelligence Analyst Planner</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Proficient (4-6 Years)</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> </tr> <tr> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Skills</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Tools</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">SQL Server Reporting Services (SSRS)</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd">Proficient (4-6 Years)</td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> <td style="padding:8px 1px; line-height:1.42857; vertical-align:top; border-top:1px solid #dddddd"> </td> </tr> </tbody> </table> </div> </div> </div> </div> <font style="font-family:Arial, Helvetica, sans-serif; font-size:small; font-style:normal; font-variant-ligatures:normal; font-weight:400; text-align:start; white-space:normal; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial">

Please wait..!!

Chat with the recruiter

Application Systems Analysis/Programming Manager - Level 1 (SQL server)--58701

In United States

Apply Here Save this job

Application Systems Analysis/Programming Manager - Level 1 (SQL server)--58701

JOB TITLE:

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

JOB DESCRIPTION:

Position Details

POSTED:

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

LOCATION:

CITY:

Job Origin:

Download mobile appsJust Swipe to apply for jobs. Try it out !

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit

Download mobile appsJust Swipe to apply for jobs. Try it out !

Application Systems Analysis/Programming Manager - Level 1 (SQL server)--58701 Apply

Please input your account's email

Chat with the recruiter

Application Systems Analysis/Programming Manager - Level 1 (SQL server)--58701

In United States

Apply Here Save this job

JOB TITLE:

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

JOB DESCRIPTION:

POSTED:

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

LOCATION:

CITY:

Job Origin:

Share this job

Share this job on linkedin

Share on Twitter

Download mobile appsJust Swipe to apply for jobs. Try it out !

Download mobile appsJust Swipe to apply for jobs. Try it out !