Job Title: Application Developer / Power BI Analyst
Location: Hartford, CT(Hybrid)
Job Type: Contract W2
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.