Data Engineer

Trilogy Federal; Arlington (VA); Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health, dental, and vision plans

401(k) with employer match

Paid time off

11 paid holidays

Tuition and training reimbursement

Job summary

Trilogy Federal is seeking a motivated Power Platform/SharePoint Developer to design, develop, and sustain enterprise workflow and case management applications for a federal health client. You will work with senior developers, data engineers, and business analysts to build components, data models, integrations, and reporting outputs that support multi-level clinical review and approval workflows.

The role spans application development and data engineering, including intake forms, dashboards,

Qualifications

• Bachelor's degree in computer science, data science, information systems, software engineering, or similar.
• 8+ years of experience in software development, data engineering, or a closely related technical role.
• Experience designing enterprise level applications.
• Experience with the Microsoft Power Platform (Power Apps, Power Automate, Dataverse) and SharePoint Online.
• Experience building dashboards or visualizations in Power BI, Grafana, or a similar tool.
• Proficiency in SQL, including working knowledge of relational database design and data modeling.
• Ability to read and work from written requirements, user stories, and acceptance criteria.
• Ability to produce clear technical documentation and explain technical concepts to non-technical stakeholders.
• Willingness to learn new platforms and tools quickly, including low-code development environments.
• Capacity to work independently or collaboratively with a cross-functional team in a remote or hybrid setting.
• Detail-oriented with the ability to manage multiple tasks and requests.
• Strong written and verbal communication skills.
• Ability to obtain a Public Trust Clearance.

Responsibilities

• Develop, configure, and maintain application components including intake forms, role-based dashboards, workflow routing, notifications, and audit logging.
• Design, build, and maintain relational and list-based data structures that support workflow routing, threshold logic, versioning, and historical reporting.
• Build and maintain data pipelines to ingest, validate, transform, and load data from Excel, CSV, form submissions, and upstream enterprise systems into the application data layer.
• Write, optimize, and troubleshoot SQL queries and stored logic supporting application functionality, reporting, and data quality checks.
• Support REST API integrations and structured data exchanges (JSON) between the application and other enterprise systems and services.
• Build reporting views, dashboards, and automated document or summary outputs that present request status, SLA compliance, and enterprise performance metrics.
• Translate business epics, user stories, and acceptance criteria into working functionality, and participate in backlog refinement, estimation, sprint planning, and daily stand-ups.
• Perform data validation, create and maintain test data, support unit and regression testing, and assist with defect triage and resolution.
• Produce and maintain clear technical documentation, including data dictionaries, schema and configuration documentation, and runbooks.

Skills

Agile / Scrum

SQL

Technical documentation

Data modeling

REST APIs

Education

Bachelor's degree in CS / software engineering / related field

Tools

Power Platform

SharePoint Online

Power BI

Grafana

PostgreSQL

TypeScript / JavaScript

React

Docker

GitHub Actions

Python

Job description

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our collaborative, client-first service approach, combined with our commitment to the rapid implementation of pragmatic solutions, has earned Trilogy an unparalleled reputation for delivering transformative results.

Trilogy Federal is seeking a motivated Power Platform/SharePoint Developer to support the design, development, and sustainment of enterprise workflow and case management applications for a federal health client. The Power Platform/SharePoint Developer will work alongside senior developers, data engineers, and business analysts to build application components, structured data models, integrations, and reporting outputs that support a multi-level clinical review and approval workflow. Day-to-day work spans both application development and data engineering: implementing intake forms and role-based dashboards, designing and maintaining the underlying data structures that drive routing and threshold logic, building and validating data pipelines, and producing reporting views and executive summary outputs used by leadership. This is a hands-on, growth-oriented role for an early-career engineer who is comfortable working from user stories and acceptance criteria, asking clarifying questions, and delivering incremental work in an Agile environment.

Please note, this position is remote, but may require occasional ad hoc travel to client locations.

Primary Responsibilities

• Develop, configure, and maintain application components including intake forms, role-based dashboards, workflow routing, notifications, and audit logging, under the direction of senior developers.
• Design, build, and maintain relational and list-based data structures that support workflow routing, threshold logic, versioning, and historical reporting.
• Build and maintain data pipelines to ingest, validate, transform, and load data from Excel, CSV, form submissions, and upstream enterprise systems into the application data layer.
• Write, optimize, and troubleshoot SQL queries and stored logic supporting application functionality, reporting, and data quality checks.
• Support REST API integrations and structured data exchanges (JSON) between the application and other enterprise systems and services.
• Build reporting views, dashboards, and automated document or summary outputs that present request status, service level agreement (SLA) compliance, and enterprise performance metrics to client stakeholders.
• Translate business epics, user stories, and acceptance criteria into working functionality, and participate in backlog refinement, estimation, sprint planning, and daily stand-ups.
• Perform data validation, create and maintain test data, support unit and regression testing, and assist with defect triage and resolution.
• Produce and maintain clear technical documentation, including data dictionaries, schema and configuration documentation, and runbooks that support onboarding, handoff, and future feature integration.
• Support compliance with federal security, privacy, records management, and Section 508 accessibility requirements in all delivered work.
• Collaborate with business analysts, product owners, testers, and client subject matter experts to clarify requirements and confirm that delivered functionality meets user needs.
• Communicate progress, risks, and blockers proactively to the technical lead and project manager.
• Stay current with relevant development, data engineering, and platform capabilities to ensure delivered solutions remain maintainable and relevant.

Minimum Requirements

• Bachelor's degree in computer science, data science, information systems, software engineering, or similar.
• 8+ years of experience in software development, data engineering, or a closely related technical role. Internship, co-op, research, and substantive academic or personal project experience will be considered.
• Experience designing enterprise level applications.
• Experience with the Microsoft Power Platform (Power Apps, Power Automate, Dataverse) and SharePoint Online.
• Experience building dashboards or visualizations in Power BI, Grafana, or a similar tool.
• Proficiency in SQL, including working knowledge of relational database design and data modeling.
• Ability to read and work from written requirements, user stories, and acceptance criteria.
• Ability to produce clear technical documentation and explain technical concepts to non-technical stakeholders.
• Willingness and demonstrated ability to learn new platforms and tools quickly, including low-code development environments.
• Capacity to work independently or collaboratively with a cross-functional team in a remote or hybrid setting.
• Detail-oriented with the ability to manage multiple tasks and requests.
• Strong written and verbal communication skills
• Ability to obtain a Public Trust Clearance.

Preferred Qualifications

• VA or federal health IT experience preferred.
• Advanced degree in computer science, data science, or similar.
• Experience with PostgreSQL or a comparable relational database, including schema design and migrations.
• Experience with TypeScript or JavaScript and a modern front-end framework such as React.
• Familiarity with containerization and CI/CD tooling such as Docker and GitHub Actions.
• Experience working in Agile or Scrum delivery teams, including sprint-based delivery and code review.
• Proficiency in Python.
• Experience building or consuming REST APIs and working with structured data formats such as JSON.
• Experience with Git-based version control and collaborative development workflows.
• Familiarity with data quality, validation, audit logging, and version control concepts in a regulated or compliance-driven environment.
• Familiarity with Section 508 accessibility standards.

Benefits (including but not limited to)

• Health, dental, and vision plans
• Optional FSA
• Paid parental leave
• Safe Harbor 401(k) with employer contributions 100% vested from day 1
• Paid time off and 11 paid holidays
• No cost group term life/AD&DD plan, and optional supplemental coverage
• Pet insurance
• Monthly phone and internet stipend
• Tuition and training reimbursement

To cut down on falsified applications and to avoid subjecting real candidates to screening by AI assistants, phone interviews at Trilogy require either a landline or a cellphone number backed by a physical SIM. We cannot conduct interviews with candidates who provide VOIP contact numbers (including Google Voice).

Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

This range is not a guarantee of compensation or salary, as Trilogy Federal conducts an individual equity review for every candidate based on experience, location, education, industry experience, and comparisons to internal pay bands. In addition to salary, Trilogy offers robust benefits including medical/dental/vision insurance coverage, 401(k) match, paid holidays, paid time off, tuition reimbursement, and a very supportive work/life balance.