*****Direct Client Requirement*****
Title : Power BI Developer
Location : Hartford, CT (Remote, Locals Only)
Rate : DOE /If your experience and skills match call us immediately for submission
Duration : 12 Months
Interview Type : Skype or Phone
Job Type : C2C,C2H,W2
Experience : 6 Years
Job Description :
- Statement of Work for DPH ID and Fiscal (COVID) Grants Management Reporting
- SQL Server (2016, 2019), SSIS, C#, PowerBI Data Modeling, PowerBI Reports
- 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.
- 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.
- 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 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.
- Other DPH IT and/or ID Informatics data modeling support as needed
- Data Modeling in PowerBi, SQL Server Query Development and Experience with fiscal data
- Data Warehousing
- Microsoft SQL Server
- Business Intelligence Analyst Planner
- SQL Server Reporting Services (SSRS)
******Referral Bonus Available: Refer your friends or colleagues, get referral bonus******
PH: 470-410-5810 EX 113/470-480-2412 EX 103
Apply here or please send to firstname.lastname@example.org
Follow us on LinkedIn and Twitter for daily active requirements
Position Keywords: SQL Server, SSRS, SSIS, C#, MS Power BI, PowerBI Reports
Pay Rate: DOE /If your experience and skills match call us immediately for submission
Job Duration: 12 Months
% Travel Required: None
Job Posted by: Consulting Services
Job ID: 2022-4494