Hybrid Power BI Analyst — Enterprise Dashboards & Insights

Smart IMS Inc; Hartford (CT); Hybrid; USD 55,000 - 110,000; Full time

Job summary

cyberThink is seeking a Power BI Analyst to design, develop, and maintain data models and enterprise dashboards. You will collaborate with developers, business analysts, QA, and production support to deliver analytics and reporting capabilities that enable data-driven decisions.

The role requires strong Power BI expertise, SQL, DAX, and ETL skills, with experience in Power Query and data modeling. Hybrid work in Hartford, CT, with a 3-month contract.

Qualifications

• Bachelor's degree in a quantitative field.
• 2+ years of experience in business intelligence, data analysis, reporting, or analytics roles.
• Strong proficiency in Power BI Desktop and Power BI Service.
• Advanced experience developing reports, dashboards, scorecards, and data visualizations using Power BI.
• Strong expertise in DAX (Data Analysis Expressions) for developing calculated columns, measures, KPIs, and advanced reporting metrics.
• Hands‑on experience using Power Query and ETL processes for data extraction, transformation, and cleansing.
• Strong SQL skills with the ability to query, analyze, and manipulate data from relational databases.
• Experience designing relational data models, star schemas, fact tables, and dimension tables.
• Experience translating business requirements into reporting and analytics solutions.
• Strong understanding of business metrics, KPI development, and performance reporting.
• Knowledge of Microsoft Power Platform technologies including Power Apps, Power Automate, Power BI, and Power Pages.
• Experience designing and supporting Power Pages websites, including security, permissions, authentication, forms, and user interfaces.
• Familiarity with Azure Active Directory authentication and access control concepts.
• Experience using HTML, CSS, and JavaScript to support reporting and portal solutions.
• Strong data analysis, analytical thinking, and problem‑solving skills.
• Experience communicating technical findings and recommendations to both technical and non‑technical stakeholders.
• Familiarity with Excel and additional analytical tools such as Python or R for data analysis and manipulation is preferred.
• Ability to work independently while collaborating effectively within cross‑functional project teams.

Responsibilities

• Design, build, and maintain interactive Power BI dashboards, reports, scorecards, and data visualizations.
• Transform raw data into meaningful business insights through effective data modeling and analytics.
• Clean, transform, and prepare data using Power Query, SQL, and ETL processes.
• Develop and maintain relational data models, star schemas, fact tables, and dimension tables.
• Create advanced DAX measures, calculated columns, KPIs, and business metrics.
• Collaborate with stakeholders to gather reporting requirements and translate business needs into technical solutions.
• Develop enterprise reporting solutions utilizing Power BI and other Microsoft Power Platform technologies.
• Support data integration and reporting initiatives across multiple business functions and operational areas.
• Design accessible, responsive, and user-friendly reports and dashboards for executive and operational users.
• Create and maintain technical documentation for reporting solutions, data sources, and business logic.
• Analyze performance metrics and provide insights that support strategic and operational decision‑making.
• Participate in requirements discussions, report validation, testing, and deployment activities.
• Support knowledge transfer and end‑user adoption through demonstrations and reporting walkthroughs.

Skills

Power BI

Power BI Service

DAX

SQL

ETL processes

Data modeling

KPI development

Analytical thinking

Excel

Python

R

HTML/CSS/JS

Education

Bachelor's degree in a quantitative field

Tools

Azure Active Directory

Power Apps

Power Automate

Power Pages

Python

R

Excel

Job description

cyberThink is seeking a Power BI Analyst to design, develop, and maintain data models and enterprise dashboards. You will collaborate with developers, business analysts, QA, and production support to deliver analytics and reporting capabilities that enable data-driven decisions.

The role requires strong Power BI expertise, SQL, DAX, and ETL skills, with experience in Power Query and data modeling. Hybrid work in Hartford, CT, with a 3-month contract.