Senior Data Analyst – Power Platform & Business Intelligence

Heartland Consulting; Washington (District of Columbia); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

Retirement savings options

Professional development opportunities

Career growth in federal/commercial**

Job summary

Heartland Consulting seeks an experienced Senior Data Analyst to support federal and commercial contract opportunities involving data analytics, BI, Power Platform, and automation.

You will build dashboards, apps, and automated workflows to improve reporting and operations, with data solutions across diverse sources and systems.

Qualifications

• Experience building production dashboards and data solutions.
• Ability to gather requirements from stakeholders and translate to technical specs.
• Experience with data from multiple systems and sources.

Responsibilities

• Collect, clean, transform, integrate, and analyze data from multiple sources.
• Design and develop dashboards, reports, and KPI tracking solutions.
• Build Power Apps to improve or replace manual processes.
• Develop Power Automate workflows for approvals and data collection.
• Maintain Power BI data models, measures, and reporting solutions.
• Integrate Power Platform with Microsoft 365 and other systems.
• Create technical and process documentation for solutions.

Skills

Power BI

Power Apps

Power Automate

SharePoint

Dataverse

Excel/Power Query

SQL

Tableau

Python

UiPath

Education

Bachelor's degree or equivalent

Tools

Power BI

Power Apps

Power Automate

Dataverse

SharePoint

SQL

Excel

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

• 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.

Benefits

• 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.

Equal Employment Opportunity

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.