Power BI Developer :: Hartford, CT (Hybrid)

Power BI Developer - Hybrid at Hartford, CT

Duration: 3 months

Seeking for a Power BI Developer will collaborate with our Information Technology (IT) development team, Business Analysts, Quality Assurance Testers, Trainers, and the Production Support IT team.

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 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, aligning technology capabilities with business strategy and operational priorities.

Core Technical Skills:

• Power BI proficiency: Use Power BI Desktop and Service to clean, transform, and model data.
• DAX: 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.

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.
• 2 years of prior experience in business intelligence, data analysis, 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 schemas.