> Markdown version of [/jobs/ext/3401741-local-power-bi-analyst-power-platform-specialist](https://www.wearedevelopers.com/jobs/ext/3401741-local-power-bi-analyst-power-platform-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # local Power BI Analyst & Power Platform Specialist - **Company:** Stellar Professionals - **Location:** Hartford, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Web Interfaces, ASP.NET, HTML, JavaScript (Programming Language), Microsoft Excel, Data Analysis, Cascading Style Sheets (CSS), Information Systems, Data Cleansing, Extract Transform Load (ETL), Data Transformation, Relational Databases, Database Queries, Executive Information Systems, Python (Programming Language), Raw Data, Power BI, Azure Active Directory, SQL Databases, Microsoft Power Automate, Powerquery, Information Technology, Data Analytics, Web Technologies, Powerapps - **Published:** September 24, 2026 - **Apply:** https://www.dice.com/job-detail/f3254491-0c14-473b-ad81-f0687f35f90e ## About the Role * Local Residency: Candidate must currently reside locally in Connecticut to attend occasional on-site meetings at 410 Capitol Ave, Hartford. * Data Analysis & BI Experience: 2+ years of professional experience in business intelligence, data analysis, or technical report authoring. * Power BI & DAX Mastery: Hands-on proficiency with Power BI Desktop and Service, including complex DAX expressions, custom filters, and data transformations. * Data Modeling & SQL: Demonstrated experience designing star-schema data models, setting up table relationships, and writing queries in SQL. * Power Pages & Web Technologies: Experience building and securing Power Pages portals utilizing HTML, CSS, JavaScript, Web Roles, and Table Permissions. * Education: Bachelor's degree in a quantitative field (e.g., Computer Science, Data Analytics, Information Systems, Mathematics)., * Prior experience working within public sector environments, public health agencies, or state government IT programs. * Familiarity with grant management systems, state contracting processes, or financial workflow portals. * Exposure to advanced data analysis tools (Python, R) or extended Power Platform components (Power Apps, Power Automate). ## Description We are seeking a local Power BI Analyst & Power Platform Specialist to support the Connecticut Department of Public Health (CT-DPH) Data Modernization Initiative (DMI). This role will focus on transitioning manual, paper/Excel-based workflows into a unified, modern Microsoft Power Platform ecosystem-specifically supporting the Contracts, Grants, Management System (CGMS). The position is responsible for designing relational data models, writing complex DAX measures, building interactive dashboards, running ETL pipelines in Power Query, and configuring web interfaces using Power Pages., * ETL & Data Preparation: Extract, clean, transform, and shape multi-source datasets using SQL, Power Query (M), and Excel to prepare raw data for analytics. * Data Modeling & DAX Development: Architect star schemas with fact and dimension tables; author custom DAX formulas, measures, calculated columns, and time-intelligence calculations. * Power BI Dashboard Development: Design and publish interactive, multi-page Power BI reports, executive dashboards, and scorecards tracking grant/contract KPIs. * Power Platform & Power Pages Integration: Configure, customize, and deliver solutions across the Microsoft Power Platform suite-including designing responsive Power Pages portals, web forms, table permissions, Web Roles, and Azure AD authentication. * Requirements & Stakeholder Collaboration: Partner with Business Analysts, QA testers, and program leadership to gather reporting requirements, define business KPIs, and present data-driven insights. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [The Resilience of the World Wide Web](https://www.wearedevelopers.com/videos/1281-the-resilience-of-the-world-wide-web) - [Building Multi-Tenant ASP.NET Core Applications: Best Practices and Real-World Solutions](https://www.wearedevelopers.com/videos/1552-building-multi-tenant-asp-net-core-applications-best-practices-and-real-world-solutions) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)