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

Application Systems Analysis/Programming Manager - Level 1 - (REMOTE Position)

In United States

Save this job

Application Systems Analysis/Programming Manager - Level 1 - (REMOTE Position)   

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

JOB TITLE:

Application Systems Analysis/Programming Manager - Level 1 - (REMOTE Position)

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Hartford, CT United States

JOB DESCRIPTION:

Position:  Application Systems Analysis/Programming Manager - Level 1
REQ ID:  58701
Direct Client: State of Connecticut - CT - DPH

Job Location: 410 Capitol Avenue, MS #11EPI Hartford, Connecticut 06134

Duration: 08/15/2022 - 07/31/2023

Time Frame: August 15, 2022 – Jul 2023

Hours Per Week: 40

Work Schedule: TBD

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

Skills Required Experiences 
Data Warehousing Proficient (4-6 Years)  
Microsoft SQL Server Proficient (4-6 Years)  
Business Intelligence Analyst Planner Proficient (4-6 Years)  
SQL Server Reporting Services (SSRS) Proficient (4-6 Years)  
 

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 

Position Details

POSTED:

Jan 17, 2023

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16619904324063096

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!

Application Systems Analysis/Programming Manager - Level 1 - (REMOTE Position)    Apply

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

<div style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif"><b><font color="#000000"><span style="text-align:justify">Position: </span> </font>Application Systems Analysis/Programming Manager - Level 1</b></font></span></span></span></span></span></span></span></span></span></span></span></div> <div style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif"><b><font color="#000000"><span style="text-align:justify">REQ ID: </span> </font>58701</b></font></span></span></span></span></span></span></span></span></span></span></span></div> <div style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif"><b><font color="#000000"><span style="text-align:justify">Direct Client: </span></font>State of Connecticut - CT <font color="#000000">-</font> DPH</b></font></span></span></span></span></span></span></span></span></span></span></span></div> <p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="vertical-align:baseline"><font face="verdana, sans-serif"><b><font color="#000000"><span lang="EN-US" style="line-height:13.91px"><span style="text-align:justify">Job Location: </span></span></font>410 Capitol Avenue, MS #11EPI Hartford, Connecticut 06134</b></font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <div style="text-align:start"> <div data-smartmail="gmail_signature" dir="ltr"> <div dir="ltr"> <div><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif"><b><span style="color:#333333">Duration: </span><span style="color:#333333">08/15/2022 - 07/31/2023</span></b></font></span></span></span></span></span></span></span></span></span></span></span></div> <div> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">Time Frame: August 15, 2022 – Jul 2023</font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">Hours Per Week: 40</font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">Work Schedule: TBD</font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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-size:12px"><span style="color:#333333"><span style="font-family:Helvetica, sans-serif"><b>CRequired Skills: </b> SQL Server (2016, 2019), SSIS, C#, PowerBI Data Modeling, PowerBI Reports</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <table style="border-collapse:collapse; width:531px" width="530"> <colgroup> <col style="width:201pt" width="268" /> <col style="width:116pt" width="154" /> <col style="width:81pt" width="108" /> </colgroup> <tbody> <tr> <td style="border-bottom:1px solid black; height:21px; width:268px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="font-weight:700"><span style="color:black">Skills</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:154px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="font-weight:700">Required</span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:108px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="font-weight:700"><span style="color:black">Experiences </span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; width:268px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="box-sizing:border-box"><span style="color:black">Data Warehousing</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:154px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="box-sizing:border-box"><span style="color:black">Proficient (4-6 Years)</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:108px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; width:268px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="box-sizing:border-box"><span style="color:black">Microsoft SQL Server</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:154px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="box-sizing:border-box"><span style="color:black">Proficient (4-6 Years)</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:108px; vertical-align:top; padding-top:1px; padding-right:1px; padding-left:1px; background-color:#f9f9f9; border-top:none; border-right:1px solid black; border-left:none"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:20px; width:268px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="box-sizing:border-box"><span style="color:black">Business Intelligence Analyst Planner</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:154px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="box-sizing:border-box"><span style="color:black">Proficient (4-6 Years)</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:108px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:20px; width:268px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="box-sizing:border-box"><span style="color:black">SQL Server Reporting Services (SSRS)</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:154px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="box-sizing:border-box"><span style="color:black">Proficient (4-6 Years)</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:108px; 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:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-size:13px"><span style="font-family:Verdana,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></span></span></span></span></span></span></td> </tr> </tbody> </table> </div> <div> </div> <div> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">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.</font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">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.</font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">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).</font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">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.</font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">5. Other DPH IT and/or ID Informatics data modeling support as needed</font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><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="color:#333333"><font face="verdana, sans-serif">6. Preferred skills: Data Modeling in PowerBi, SQL Server Query Development and Experience with fiscal data </font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> </div> </div> </div> </div>


Please wait..!!