Note: The job is a remote job and is open to candidates in USA. Heartland Consulting supports federal and commercial contract opportunities involving data analytics, business intelligence, Microsoft Power Platform, and process automation. The Senior Data Analyst will develop dashboards, applications, automated workflows, and data solutions while analyzing data and translating stakeholder requirements into technical solutions.
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
Skills
- 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 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
Company Overview