Power BI Developer Data Analyst (SQL DAX & Data Modeling)
The Power BI Developer Data Analyst will design, build, and manage data models, interactive dashboards, and reports using Power BI to transform raw data into actionable business insights. This role involves collaborating with IT and business teams to develop enterprise-grade solutions leveraging Microsoft Power Platform, with responsibilities including data preparation, modeling, visualization, and translating business needs into technical specifications. The position requires strong proficiency in SQL, DAX, data modeling, and Power BI, and is based in a hybrid work model near Hartford, CT.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Government/Staffing.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
What You’ll Do
This is a hands-on Power BI Developer / Data Analyst role supporting a confidential client. You will turn raw data into clear, actionable business insights using Power BI, SQL, and DAX, and help deliver enterprise-grade reporting solutions across the Microsoft Power Platform.
- Build, maintain, and optimize Power BI reports and multi-page dashboards.
- Clean, transform, and shape datasets using Power Query and SQL for reliable reporting.
- Design and maintain relational data models (stars/snowflakes) with correct fact and dimension tables.
- Write robust DAX measures, calculated columns, and complex filters for analytical metrics.
- Collaborate with Business Analysts, QA, Trainers, and Production Support to translate requirements into technical report specs and KPIs.
- Integrate Power BI solutions with Power Apps, Power Automate, and Power Pages where appropriate.
- Support deployment and documentation; troubleshoot performance and data-quality issues.
Qualifications
- Bachelor’s degree in a quantitative field (required).
- 2+ years of hands-on experience in business intelligence, data analysis, or report development.
- Proven experience working with Power BI Desktop and Power BI Service.
- Strong SQL skills for querying and preparing data.
- Demonstrated ability to craft DAX expressions for business metrics.
- Familiarity with Power Query (M) for ETL tasks.
- Strong attention to data quality, model performance, and visualization best practices.
Required Skills & Tools
- Power BI Desktop & Service
- DAX (Data Analysis Expressions)
- SQL (T-SQL or similar)
- Power Query / ETL techniques
- Data modeling (star schema design, relationships)
- Excel for ad-hoc analysis
- Comfortable working in a Microsoft-centric environment (Power Platform, Azure AD)
Preferred (Nice-to-Have)
- Experience customizing Power Pages (forms, lists, permissions, authentication).
- HTML/CSS/JavaScript experience for Power Pages UI enhancements.
- Familiarity with Azure AD authentication and table permissions / web roles.
- Knowledge of Python or R for advanced data manipulation (supplementary).
Location & Work Model
- Authoritative work location: Hartford, CT (local candidates preferred).
- Work model: Hybrid — this role requires occasional onsite presence at 410 Capitol Avenue, Hartford. Only candidates located near Hartford, CT will be considered for onsite requirements.
Compensation & Duration
- Employment type: Temporary, Full-Time.
- Estimated duration: ~2 months (may be shortened or extended per client needs).
- Pay range: $65.00 – $70.00 per hour (hourly, USD). C2C is not available.
Additional Information
- Only candidates lawfully authorized to work in the United States will be considered.
- If you require accommodations during the application or interview process, please notify the client or Careertakes.
- Confidential client participates in E-Verify where applicable.
- This posting follows applicable state and federal hiring laws.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range