Application developer

Job title: Application Developer

Location:Hartford, Connecticut

Duration: 3 Months

Description:

Core 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 (Data Analysis Expressions) 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 (Power Apps, Power Automate, Power BI, and Power Pages), aligning technology capabilities with business strategy and operational priorities.

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.