Data Engineer

Summary

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries through a collaborative, client-first approach. The Data Engineer will design, develop, and sustain enterprise workflow and case management applications for a federal health client, including data models, pipelines, integrations, dashboards, and reporting outputs. This hands-on role collaborates with senior technical staff and cross-functional teams in an Agile environment.

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
• Develop and 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
• Use Git-based version control and participate in peer code reviews, branching and merge practices, and supported deployment and release activities across development, test, and production environments
• 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

Skills

• - 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
• - Proficiency in Python
• - Experience with the Microsoft Power Platform (Power Apps, Power Automate, Dataverse) and SharePoint Online
• - Proficiency in SQL, including working knowledge of relational database design and data modeling
• - 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
• - 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
• - Strong written and verbal communication skills
• - Detail-oriented with the ability to manage multiple tasks and requests
• - Ability to obtain a Public Trust Clearance
• - 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
• - Experience building dashboards or visualizations in Power BI, Grafana, or a similar tool
• - 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
• - Familiarity with data quality, validation, audit logging, and version control concepts in a regulated or compliance-driven environment
• - Familiarity with Section 508 accessibility standards
• - VA or federal health IT experience preferred

Qualifications

Must Haves

• - 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
• - Proficiency in Python
• - Experience with the Microsoft Power Platform (Power Apps, Power Automate, Dataverse) and SharePoint Online
• - Proficiency in SQL, including working knowledge of relational database design and data modeling
• - 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
• - 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
• - Strong written and verbal communication skills
• - Detail-oriented with the ability to manage multiple tasks and requests
• - Ability to obtain a Public Trust Clearance
• - 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
• - Experience building dashboards or visualizations in Power BI, Grafana, or a similar tool
• - 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
• - Familiarity with data quality, validation, audit logging, and version control concepts in a regulated or compliance-driven environment
• - Familiarity with Section 508 accessibility standards

Nice to Haves

• - VA or federal health IT experience preferred

Benefits

• 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&D plan, and optional supplemental coverage
• Pet insurance
• Monthly phone and internet stipend
• Tuition and training reimbursement