Power BI Analyst

Spectraforce Technologies, Inc.; Hartford (CT); Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

Health insurance

Job summary

Spectraforce Technologies, Inc. in Hartford, CT, is seeking a Power BI Analyst for a 3-month hybrid role. You will design, build, and manage Power BI data models, dashboards, and reports to turn raw data into actionable insights for leadership.

Collaboration with IT, BI teammates, and business analysts is essential to success. The role emphasizes data preparation, modeling, and visualization, with emphasis on KPI development and cross-functional communication.

Qualifications

• A bachelor's degree in a quantitative field; 2+ years of data analysis experience; strong SQL, DAX, and data modeling.
• Generally 2+ years in business intelligence, data analysis, or report writing.
• Familiarity with Excel, Python, or R for advanced data manipulation.
• Experience with Power Query M transformation and building star schemas.

Responsibilities

• Data preparation: clean, transform, and shape raw datasets using Power Query and SQL.
• Data modeling: build relational models and write DAX for metrics and analyses.
• Visualization: create dynamic dashboards and scores for stakeholders.
• Collaboration: translate business needs into KPIs and technical report specs.
• Deliver enterprise-grade Power Platform solutions aligned with business strategy.

Skills

Power BI

DAX

Power Query

SQL

Excel

Visualization

Stakeholder communication

Education

Bachelor's degree in a quantitative field

Tools

Power BI

Power Pages

SQL

Excel

Python

R

HTML/CSS/JS

Job description

Power BI Analyst

Hartford, Connecticut 06134 (Hybrid)

3 Months

*Local candidates only*

• Occasionally, work may be performed onsite at 410 Capitol Avenue, Hartford; otherwise, the work will be remote (as determined by the Point of Contact).
• All work shall occur between the hours of 8:00 am and 5:00 pm on official workdays in the client or as otherwise approved by the Point of Contact.

Work Location & Hours

• Occasionally, work may be performed onsite at 410 Capitol Avenue, Hartford; otherwise, the work will be remote (as determined by the Point of Contact).
• All work shall occur between the hours of 8:00 am and 5:00 pm on official workdays in the client or as otherwise approved by the Point of Contact.

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.

Core Responsibilities:

• Data Preparation: Clean, transform, and shape raw datasets using Power Query and SQL.
• Data Modeling: Build stable relational data models and write custom DAX (Data Analysis Expressions) formulas for metrics, reporting, and analysis.
• Visualization: Create dynamic, multi-page dashboards and scorecards for stakeholders.
• Collaboration: Translate business needs into key performance indicators (KPIs) and technical report specs.
• Deliver enterprise-grade solutions leveraging Microsoft Power Platform (Power Apps, Power Automate, Power BI, and Power Pages), aligning technology capabilities with business strategy and operational priorities.

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.
• Supplementary tools: Familiarity with Excel, Python, or R for advanced data manipulation.
• Data preparation: Experience with Power Query M transformation and building star.