Junior Data Engineer

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 Junior Data Engineer to support the design, development, and sustainment of enterprise workflow and case management applications for a federal health client. The Junior Data Engineer 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. The ideal candidate is a fast learner with strong fundamentals in Python and SQL who is eager to pick up low-code platforms and federal delivery practices under the mentorship of senior technical staff.
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.

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