Senior Data Systems Developer

LMI Consulting, LLC; United States; On-site; USD 112,000 - 145,000; Full time

Job summary

LMI Consulting, LLC is seeking a Senior Data Systems Developer to lead the Power Platform-based interfaces and workflows for a VA/VHA contract. You will design canvas and model-driven Power Apps, implement Power Automate workflows, and ensure data is validated and pushed to SQL Server for reliable reporting.

You will collaborate with data engineers, data scientists, and front-end developers to optimize analytics readiness, enforce security (FISMA/508), and deliver scalable solutions for

Qualifications

• Bachelor's degree in computer science, information systems, data science, or a related field.
• 8+ years of experience in application/data systems development with Power Apps
• Strong experience designing workflow-driven interfaces using Power Apps and Power Automate
• Experience building Power Apps for Power BI reporting pipelines and data models
• Experience architecting Power Apps to write/push data into a SQL Server database; SQL knowledge
• Ability translate business workflows into functional app requirements for non-technical end users
• Familiarity with federal data governance, accessibility standards including FISMA and WCAG 2.0 AA

Responsibilities

• Lead Power Apps development for the program with canvas and/or model-driven apps
• Design workflow-driven screens for analysts, training coordinators, and approvers
• Architect data flow from Power Apps into SQL Server; ensure data is validated and stored
• Collaborate with Senior Data Engineer Lead on SQL Server schema and data model
• Build automated Power Automate workflows to connect Power Apps to SQL Server, SharePoint, and other sources
• Collaborate with Power BI team to support clean downstream reporting
• Implement role-based access and security within Power Apps/Dataverse/SharePoint
• Maintain and enhance existing Power Apps solutions; respond to ad hoc requests
• Lead UAT and validation; develop test cases and manage defects
• Document architecture, data flows, and change management for releases

Skills

Power Apps development

Power Automate workflows

SQL Server data modeling

Workflow-driven UI design

FISMA compliance

Education

Bachelor's degree in CS/IS/Data Science

Master's degree (preferred)

Tools

Power Apps

Power Automate

SharePoint

Dataverse

SQL Server

Job description

Senior Data Systems Developer

Job Locations

US-Remote

Overview

Team LMI is seeking a Senior Data Systems Developer specializing in Microsoft Power Platform Suite to support our contract with the Department of Veterans Affairs (VA), Veterans Health Administration (VHA). In this role, you will serve as the lead application developer on a small, integrated project team - responsible for building the interfaces and workflow tools that front-line staff and program stakeholders use to enter, validate, and manage large-scale training and workforce data. You will design and build Power Apps solutions (canvas and/or model-driven) that facilitate day-to-day data collection and approval workflows and push clean, structured data into the underlying SQL Server database. This is an app-building, workflow-first role: the team already has deep SQL and data engineering expertise, so you will spend the bulk of your time designing and developing the Power Apps interface and workflow layer rather than writing SQL.

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

• Serve as the primary Power Apps developer for the program, designing, building, and maintaining canvas and/or model-driven apps that serve as the front-line interface for data entry, workflow routing, and approvals
• Design intuitive, workflow-driven app screens and forms for a range of user roles (analysts, training coordinators, approvers), partnering with the HCD SME to ensure the app reflects real user needs and reduces manual effort
• Architect and build the data flow from Power Apps into the SQL Server backend, ensuring app-collected data is validated, structured, and pushed into the database cleanly and reliably for downstream reporting
• Collaborate closely with the Senior Data Engineer Lead on the underlying SQL Server schema and data model so that app inputs map cleanly to the database
• Build automated workflows in Power Automate that connect Power Apps to SQL Server, SharePoint, and other data sources - handling notifications, approvals, escalations, and status tracking with minimal manual intervention
• Collaborate with the Senior Data Scientist (Power BI) and Front-End Developer to ensure app-collected data is structured in a way that supports clean, reliable downstream Power BI reporting without rework
• Design and implement Power Apps interfaces and data input structures that cleanly support downstream Power BI reporting ensuring data captured via the app is well structured, validated, and optimized for analytics.
• Implement role-based access and security within Power Apps and Dataverse/SharePoint data sources, ensuring alignment with VA security, FISMA, and Section 508 accessibility requirements
• Maintain and enhance existing Power Apps solutions in response to stakeholder feedback, new workflow requirements, or changes to underlying data sources; respond to ad hoc requests for new forms or workflow features
• Lead User Acceptance Testing (UAT) and validation for new and updated apps and workflows, developing test cases and coordinating resolution of defects and change requests; assume Quality Assurance responsibilities as needed
• Document app architecture, data flows, and workflow logic; maintain version control and change management for all app releases, and support train-the-trainer sessions to drive stakeholder adoption
• Stay current on Power Platform capabilities and features, proactively identifying opportunities to streamline workflows, reduce manual data entry, and improve app performance and usability across the life of the contract

Qualifications

Required Qualifications:

• Bachelor's degree in computer science, information systems, data science, or a related field
• 8+ years of experience in application/data systems development, with deep, demonstrated expertise building enterprise-grade Power Apps solutions (canvas and/or model-driven) - this is an app-building, workflow-first role, and Power Apps mastery is the top hiring priority
• Strong experience designing and building workflow-driven interfaces that collect, validate, and route data -including forms, approval chains, notifications, and status tracking - using Power Apps and Power Automate
• Demonstrated experience building Power Apps (canvas or model-driven) specifically tailored to support Power BI reporting pipelines including structuring data models, designing clean input interfaces, and implementing best practices for refresh performance and data quality
• Experience architecting Power Apps solutions that write and push data into a SQL Server database; working knowledge of SQL is expected
• Demonstrated ability to translate business and program workflows into functional app requirements and intuitive, easy-to-use interfaces for non-technical end users
• Familiarity with federal data governance and accessibility standards, including FISMA compliance, data security requirements, and Section 508 (WCAG 2.0 AA) accessible design

Desired Qualifications:

• Experience supporting VA or VHA data and workflow systems, particularly in workforce development, training/learning management, or human capital administration
• Familiarity with VHA source systems such as the Talent Management System (TMS 2.0), HRSmart, or SharePoint Online, and how workflow data flows between them and a SQL Server backend
• Experience with Dataverse (or the Common Data Service) as a data source for Power Apps, including entity/table design and relationships
• Knowledge of Human-Centered Design (HCD), Human-Systems Integration (HSI), or User Experience (UX) methods as applied to workflow and application design
• Proficiency in Power FX and Power Automate expressions, and experience with custom JSON formatting for SharePoint list views to enhance workflow and reporting usability
• Master's degree in computer science, information systems, or a related field

Target salary range: $112,000 - $145,000. Final compensation will be determined by a variety of factors including but not limited to your skills, experience, education, and/or certifications.

Applicants must meet eligibility requirements for a U.S. Government security clearance. Only US Citizens are eligible for a security clearance. For this position, LMI will only consider applicants with security clearances or applicants who are eligible for security clearances, due to the nature of the work.

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.