Data Analyst – Power Platform

LMI is hiring a Data Analyst to support a major office at the U.S. Department of Veterans Affairs. The role delivers data analysis, reporting, business process improvement, and Microsoft Power Platform solutions, while translating stakeholder needs into decision-ready outputs and supporting operational improvement and digital modernization.

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 escalate 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

Requirements:

• Bachelor's degree required
• 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
• Computer Science, Data Science, Information Systems, Engineering, Mathematics, Business Analytics, or a related field preferred
• 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