Job Description :

Job Title : Power BI Developer

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

Location: Hartford, CT 06134

Required Skills:

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

Initial Projects:

  • Fiscal Data Modeling generate PowerBI data models based on extracts from the client 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.
  • PowerBI Report Generation develop and publish fiscal reports in PowerBI that can be used by Client Business Office staff, Principal Investigators of grants and cooperative agreements, and Client Leadership.
  • 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).
  • Develop Production ETL for Fiscal Data Model coordinate with Client 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.
  • Other Client IT and/or ID Informatics data modeling support as needed.

Preferred skills:

Data Modeling in PowerBi, SQL Server Query Development and Experience with fiscal data


Data Warehousing

Proficient (4-6 Years) No

Microsoft SQL Server

Proficient (4-6 Years)


Business Intelligence Analyst Planner

Proficient (4-6 Years)


SQL Server Reporting Services (SSRS)

Proficient (4-6 Years)



Similar Jobs you may be interested in ..