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
Qualifications:
Data Warehousing
Proficient (4-6 Years) No
Microsoft SQL Server
Proficient (4-6 Years)
No
Business Intelligence Analyst Planner
Proficient (4-6 Years)
No
SQL Server Reporting Services (SSRS)
Proficient (4-6 Years)
No