Data Analyst - Power Platform

LMI Consulting, LLC; United States; Remote; USD 70,000 - 118,000; Full time

Job summary

LMI is seeking a Data Analyst to support VA projects with data analysis, reporting, and Power Platform solutions. You will translate business questions into data requirements, develop dashboards, and provide decision-ready insights to improve processes and performance.

Responsibilities include building Power BI reports, writing SQL queries, data cleansing, and coordinating with VA stakeholders and internal teams. A strong Excel and Power Platform background is essential.

Qualifications

• Bachelor's degree in CS/DS/IS/Engineering/Math/Analytics or related field.
• 5+ years in data analysis, BI, reporting, or equivalent.
• Power BI hands-on: create/maintain reports and dashboards.
• SQL querying: filtering, joining, and relational keys.
• Excel proficiency with formulas, data manipulation, and quality checks.
• Ability to gather requirements and document processes.
• Comfort with data entry, documentation updates, ticket management.
• Strong communication and data-quality judgment.
• Eligibility for Public Trust clearance.

Responsibilities

• Build, update, and maintain Power BI reports, dashboards, and visualizations; connect to approved data sources and develop basic measures, calculations, and filters.
• Write and adapt SQL queries to extract, filter, join, and validate data across relevant sources; apply an understanding of relational tables, relationships, and keys to support accurate reporting.
• Perform hands-on data entry, cleansing, reconciliation, validation, and quality checks; identify discrepancies and coordinate their resolution.
• Translate stakeholder questions into data requirements, metrics, filters, business rules, validation checks, and reporting outputs; document processes, assumptions, and known limitations.
• Support the configuration and maintenance of simple Power Apps, Dataverse tables/forms, and Power Automate workflows such as notifications, approvals, and data movement.
• Assist with testing, user acceptance testing, issue reproduction, and documentation of defects, enhancements, and change requests.
• Create, update, prioritize with guidance, and track work items through the sprint or delivery cycle in Jira, Azure DevOps, Aha!, or comparable tools.
• Coordinate with client stakeholders and teammates to track requests, action items, status, dependencies, and follow-ups; communicate progress and elevate blockers.
• Use Excel, Power Query, and other approved tools for basic analysis, manipulation, and recurring reporting support.
• Maintain accurate process documentation, user guides, standard operating procedures, data definitions, and project/status materials.
• Own assigned analysis and reporting work through delivery; perform quality and reasonableness reviews, help improve team standards, and provide guidance or peer review as appropriate while following approved data-handling and Power Platform practices.

Skills

Data analysis

Power BI

SQL

Excel

Requirements gathering

Communication

Public Trust clearance

Education

Bachelor's degree in CS/DS/IS/Engineering/Math/Analytics or related field

Tools

Power BI

SQL

Excel

Power Apps

Dataverse

Power Automate

Jira

Azure DevOps

Aha!

Job description

Data Analyst - Power Platform

Job Locations

US-Remote

Overview

LMI is seeking a Data Analyst to support a major office at the U.S. Department of Veterans Affairs (VA) through data analysis, reporting, business process improvement, and Microsoft Power Platform solutions. This role provides hands‑on analytical and business support for operational improvement, digital modernization, workflow analysis, performance measurement, data quality, and decision support.

The analyst will translate business and mission questions into clear data and reporting requirements; identify data needs, assess source quality, prepare and validate information, and deliver accurate, decision‑ready dashboards, reports, and recurring analyses. The role combines independent ownership of moderately complex, multi‑source analysis and Power Platform work with practical delivery support, including documentation, testing, data maintenance, stakeholder coordination, and request tracking. Working with project managers, developers, technical teams, and VA stakeholders, the analyst will help shape analytical approaches, review outputs for quality, and communicate findings and limitations in plain language.

LMI is a new breed of digital solutions provider dedicated to accelerating government impact with innovation and speed. Investing in technology and prototypes ahead of need, LMI brings commercial‑grade platforms and mission‑ready AI to federal agencies at commercial speed.

Leveraging our mission‑ready technology and solutions, proven expertise in federal deployment, and strategic relationships, we enhance outcomes for the government, efficiently and effectively. With a focus on agility and collaboration, LMI serves the defense, space, healthcare, and energy sectors‑helping agencies navigate complexity and outpace change. Headquartered in Tysons, Virginia, LMI is committed to delivering impactful results that strengthen missions and drive lasting value.

Responsibilities

• Build, update, and maintain Power BI reports, dashboards, and visualizations; connect to approved data sources and develop basic measures, calculations, and filters.
• Write and adapt SQL queries to extract, filter, join, and validate data across relevant sources; apply an understanding of relational tables, relationships, and keys to support accurate reporting.
• Perform hands‑on data entry, cleansing, reconciliation, validation, and quality checks; identify discrepancies and coordinate their resolution.
• Translate stakeholder questions into data requirements, metrics, filters, business rules, validation checks, and reporting outputs; document processes, assumptions, and known limitations.
• Support the configuration and maintenance of simple Power Apps, Dataverse tables/forms, and Power Automate workflows such as notifications, approvals, and data movement.
• Assist with testing, user acceptance testing, issue reproduction, and documentation of defects, enhancements, and change requests.
• Create, update, prioritize with guidance, and track work items through the sprint or delivery cycle in Jira, Azure DevOps, Aha!, or comparable tools.
• Coordinate with client stakeholders and teammates to track requests, action items, status, dependencies, and follow‑ups; communicate progress and elevate blockers.
• Use Excel, Power Query, and other approved tools for basic analysis, manipulation, and recurring reporting support.
• Maintain accurate process documentation, user guides, standard operating procedures, data definitions, and project/status materials.
• Own assigned analysis and reporting work through delivery; perform quality and reasonableness reviews, help improve team standards, and provide guidance or peer review as appropriate while following approved data‑handling and Power Platform practices.

Qualifications

Required

• Bachelor's degree required (Computer Science, Data Science, Information Systems, Engineering, Mathematics, Business Analytics, or a related field preferred).
• 5+ years of relevant professional experience in data analysis, business intelligence, reporting, operational analytics, business analysis, or a comparable role, including independent ownership of complex analytical or reporting deliverables.
• Hands‑on experience with Power BI, including creating or maintaining reports and dashboards, connecting to data, and building basic visuals and calculations.
• Practical experience writing SQL queries, including filtering and joining data, and understanding relational tables, primary/foreign keys, and relationships.
• Proficiency in Microsoft Excel, including formulas, data manipulation, and data quality checks.
• Ability to gather requirements, document processes, and translate stakeholder needs into actionable reporting, data, and support tasks.
• Comfort with detailed operational support activities such as data entry, documentation updates, ticket management, and coordination of follow‑ups.
• Strong written and verbal communication, sound data‑quality judgment, attention to detail, collaboration, and the ability to independently manage competing priorities and communicate assumptions or limitations to stakeholders.
• Ability to obtain a Public Trust clearance.

Desired

• Experience creating simple Power Automate flows for notifications, approvals, or moving information between systems.
• Exposure to building or configuring basic Power Apps and working with Dataverse tables, fields, forms, and related data.
• Familiarity with Jira, Microsoft Azure DevOps, Aha!, or similar tools for documenting, updating, and tracking work items in Agile/Scrum delivery.
• Working knowledge of Power Query and basic data transformation or modeling concepts.
• Basic familiarity with HTML and JavaScript.
• Experience supporting federal or government clients, including VA stakeholders.
• Familiarity with healthcare, program management, or program evaluation data.
• Exposure to UI/UX or user‑centered design concepts and interest in relevant Microsoft certifications (e.g., PL-300).
• Master's degree in a relevant field; experience providing peer review, mentoring, or shaping complex analysis.

Target Salary Range: $70,000 - $118,000

Disclaimer

The salary range displayed represents the typical salary range for this position and is not a guarantee of compensation. Individual salaries are determined by various factors including, but not limited to location, internal equity, business considerations, client contract requirements, and candidate qualifications, such as education, experience, skills, and security clearances.

LMI is an Equal Opportunity Employer. LMI is committed to the fair treatment of all and to our policy of providing applicants and employees with equal employment opportunities. LMI recruits, hires, trains, and promotes people without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, pregnancy, disability, age, protected veteran status, citizenship status, genetic information, or any other characteristic protected by applicable federal, state, or local law. If you are a person with a disability needing assistance with the application process, please contact [e-mail].

Colorado Residents: In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.