Senior Data Analyst – Power Platform & Business Intelligence

Heartland Consulting; United States; Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Retirement savings options

Professional development and training

Job summary

Heartland Consulting is seeking Senior Data Analysts to support data analytics, BI, Power Platform, and process automation across federal and commercial contracts.

You will build dashboards, automate workflows, and create data solutions to enhance reporting and operations. This role emphasizes hands-on development and stakeholder collaboration across multiple sources and systems.

Qualifications

• Experience designing and building data analytics solutions for business decisions.
• Proven ability to develop dashboards, reports, and KPI tracking.
• Strong collaboration with business stakeholders to translate needs into technical solutions.

Responsibilities

• Collect, clean, transform, and analyze data from multiple sources.
• Design and develop interactive dashboards, reports, and KPI tracking solutions.
• Build Canvas and Model-Driven Power Apps to automate processes.
• Develop Power Automate workflows for approvals, notifications, and data collection.
• Create and maintain Power BI data models, measures, and dashboards.
• Integrate Power Platform with Microsoft 365 and other systems.
• Perform trend analysis, reconciliation, and variance analysis.
• Gather requirements from stakeholders and translate into technical specs.
• Produce technical and process documentation for developed solutions.

Skills

Data analytics

Business intelligence

Stakeholder communication

Education

Bachelor's degree in related field

Tools

Power BI

Power Apps

Power Automate

SharePoint

Dataverse

Excel/Power Query

SQL

Tableau

Python

UiPath

Job description

Company: Heartland Consulting
Employment Type: Full-Time / Anticipated Future Opportunities
Location: Remote, Hybrid, or On-Site depending on contract requirements

Position Summary

Heartland Consulting is seeking experienced Senior Data Analysts to support anticipated federal and commercial contract opportunities involving data analytics, business intelligence, Microsoft Power Platform, and process automation.

This position is ideal for candidates who have hands-on experience developing dashboards, applications, automated workflows, and data solutions that improve reporting and business operations.

Key Responsibilities

Collect, clean, transform, integrate, and analyze data from multiple sources.

Design and develop interactive dashboards, reports, scorecards, and KPI tracking solutions.

Build Canvas and Model-Driven Power Apps to improve or replace manual business processes.

Develop Power Automate workflows for approvals, notifications, data collection, file processing, and recurring tasks.

Develop and maintain Power BI data models, measures, dashboards, and reporting solutions.

Build and maintain data solutions using Dataverse, SharePoint Lists, document libraries, Excel, and other approved data sources.

Integrate Power Platform solutions with Microsoft 365 applications and other business systems.

Perform trend analysis, data reconciliation, variance analysis, and KPI development.

Gather requirements from stakeholders and translate business needs into technical solutions.

Create technical documentation, process documentation, and user guidance for developed solutions.

Desired Software & Technical Experience

Candidates should have hands-on experience with several of the following:

Microsoft Power BI - dashboards, data modeling, DAX, and reporting

Microsoft Power Apps - Canvas and/or Model-Driven applications

Microsoft Power Automate - automated workflows, approvals, and notifications

Microsoft SharePoint - Lists, Libraries, and Power Platform integration

Microsoft Dataverse - tables, relationships, and application integration

Microsoft Excel / Power Query - data transformation, analysis, and reporting

SQL - querying and working with structured data

Experience with Tableau, Python, or UiPath is a plus but not required.

Preferred Qualifications

Experience developing production dashboards, applications, or automated workflows.

Experience integrating and analyzing data from multiple systems or sources.

Strong analytical, troubleshooting, and problem-solving skills.

Experience gathering requirements and working directly with business stakeholders.

Federal government, DoD, or regulated-environment experience is a plus.

Bachelor's degree in a related field or equivalent professional experience preferred.

Heartland Consulting offers a competitive benefits package for eligible employees, which may include:

Medical, dental, and vision insurance

Retirement savings options

Professional development and training opportunities

Career growth opportunities across federal and commercial programs

Specific benefits and eligibility may vary based on position, employment status, and contract requirements.

Heartland Consulting is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.