Power BI Analyst(Hybrid Onsite)

Job Title

Power BI Analyst (Hybrid Onsite)

Location

Hartford, CT

Duration

3 Months

Pay Rate

$70/hr on C2C / 1099 all inclusive OR $65/hr on W2

Coverage (NOP)

1

Interview Type

Virtual / In-Person

Note

Candidate Must Be Local

Description

(Data Modernization Initiative (DMI) Program Overview  

Various sections and programs currently track and manage critical information through disparate Excel files and Word documents. This manual, unstructured approach creates compliance risks, missed deadlines, and limited data visibility. Transitioning from a paper-based workflow to an automated Microsoft Power BI ecosystem through a Data Submissions and CGMS Portal has been a comprehensive, modernized, and successful strategy.  The core program goals focus on eliminating manual data entry, enforcing data governance, and providing stakeholders with real-time decision-support capabilities and data analytics.

Workstream Overview – (CGMS) Contracts, Grants, Management SystemThe (CGMS) Contracting process manages the full lifecycle of contract development and execution, progressing through the following key stages.  The current environment combines manual and system-assisted processes that support the full lifecycle of grants, contracting, financial reporting, and payment/refund activities. The process begins with the Contractor Information Intake process and moves through the below steps/phases, ending with the routing, approval, and execution phase.

·     Contractor Information Intake: Program initiates the process by providing contractor details and required supporting documentation.

·       Electronic Department Agreement Request (EDAR) Checklist Preparation: Program compiles and validates all required documentation, approvals, and data elements necessary for contract routing.

·       Electronic Department Agreement Request (EDAR) Submission: The formal contract request is submitted through the EDAR system, including fiscal data, contract type, and supporting materials for CMS review.

·       Legal Review & Contract Language: Contract language is reviewed and revised collaboratively by Legal, Program, and CMS.

·       Contract Development & Initiation: CMS prepares the appropriate contract template and ensures readiness for execution.

·       Routing, Approval & Execution: The Contract Specialist manages approvals, signatures, and final contract execution and distribution.

About the Role

We are seeking (1) skilled Power BI Analyst.  The Power BI Analyst will work with the Information Technology (IT) development team, in collaboration with Business Analysts, Quality Assurance Testers, Trainers, and the Production Support Information Technology team. 

The Power BI Analyst will design, build, and manage data models, interactive dashboards, and reports in Power BI to turn raw data into clear business insights and analyses that support leadership in evaluating key performance metrics, modeling behaviors, and data.  

Top Skills

Core Technical Skills

·       Power BI proficiency: Ability to use Power BI Desktop and Service to clean, transform, and model data.

·       DAX (Data Analysis Expressions): Master this formula language to build custom calculated columns, measures, totals, and complex filters.

·       Power Query & ETL: Use Power Query to extract, transform, and clean raw data from multiple sources before loading it into your model.  

·       Data Modeling: Design relational schemas, connect data sources, and configure star schemas with proper fact and dimension tables.  

·       SQL & Excel: Write database queries in SQL and leverage Excel for preliminary data manipulation and fast ad hoc analysis.

Knowledge: Power Pages Development 

• Design, configure, and customize Power Pages websites, including forms, lists, security, permissions, and user authentication.

• Develop responsive, accessible, and user-friendly web interfaces using Power Pages design studio, HTML, CSS, and JavaScript.

• Implement Web Roles, Table Permissions, and authentication methods (Azure AD).

Visualization & Reporting

• Dashboard Design: Build clear, interactive, and user-friendly reports using core visuals like bar charts, matrices, and maps.

• Business Acumen: Understand key performance indicators (KPIs) and operational goals specific to our industry.

• Stakeholder Communication: Gather requirements effectively from business users and explain technical findings in simple terms.  This may be a partnership role with the workstream-appointed Business Analyst on our team.

Education and Experience

·    A bachelor’s degree in a quantitative field; 2 or more years of data analysis experience, and strong technical proficiency in SQL, DAX, and data modeling.

·       Generally, 2+ years of prior experience in business intelligence, data analys8is or report writing.

·

Recruiter

Contact: Praveen - - Eight three two - Nine Nine Zero - Two four two seven