Teams at Trilogy Federal

Build and maintain workflow applications, relational data structures, data pipelines, SQL logic, REST integrations, dashboards, and reporting outputs for a federal health client. Translate user stories into functionality, perform testing and validation, support Agile delivery, documentation, code reviews, deployments, and compliance requirements. Collaborate with technical and business stakeholders in a remote environment, with occasional client travel.

Provides federal accounting and financial management support, including accounting research, policy and procedure development, process documentation, executive meeting documentation, dashboard design, presentations, training, and financial reporting materials. Collaborates with federal clients, program leadership, and subject matter experts to support compliance with SFFAS, Treasury policies, and reporting requirements. The role is fully remote and requires federal accounting or financial statement audit experience.

Build and implement SSAS environments, redesign reports, develop SQL queries and Power BI dashboards, and apply tabular, relational, and multidimensional data modeling. The role transforms and pre-aggregates data, documents logical and physical models, develops reporting solutions, and collaborates with federal client technical teams. Expertise in ETL, data pipelines, data warehousing, SQL, SSIS, SSAS, Power BI, and cloud environments is required.