Data Engineer
About the job
- Minimum of 8 years of overall professional experience and a bachelor's degree.
- Minimum of 6 years of experience with Java and JavaScript.
- Minimum of 3 years of experience with SQL.
- Ability to define and develop new reporting and data queries using SQL, SQL Server Analysis Services, and SQL Server Integration Services.
- Experience building both star and snowflake schemas.
- Working knowledge of tabular, relational, and multidimensional data models.
- Working knowledge of AWS and/or Azure cloud environments.
- Experience building complex dashboards and reports with Power BI.
- Expert-level understanding of extract, transform, and load (ETL), data pipeline, and data warehousing concepts.
- Ability to obtain a Public Trust clearance.
- Ability to work independently and within a team.
- Flexibility and ability to respond to changing requirements.
- Implement a functional SQL Server Analysis Services (SSAS) environment.
- Build and redesign reports for transition to an Analysis Services environment.
- Work with the customer's technical team to identify initial requirements.
- Apply tabular, relational, and multidimensional data modeling methodologies.
- Transform raw data into meaningful business decisions and pre-aggregate data for optimal results.
- Document logical and physical data models.
- Document and update the reporting environment data model.
- Develop new reports based on customer requirements.
- Experience generating financial data models and analytics, including budgeting, financial management, or personnel environments.
- Veterans Affairs (VA) experience is preferred but not required.
About the company
Trilogy Federal provides financial management and IT consulting services to the U.S. federal government as a verified SDVOSB. Its work covers assessing and optimizing financial management solutions, migrating or enhancing systems to meet new requirements, and delivering data-driven reporting through Business Intelligence (BI) and Business Performance Management (BPM) tools. The company distinguishes itself through deep federal financial management expertise from a leadership team with over 60 years of combined experience, a practical, data-focused approach, and end-to-end support that aims for fiscal compliance and audit readiness. Trilogy’s goal is to help agencies achieve timely, reliable, and value-added financial reporting across programs of all sizes.
Company Size
51-200
Company Stage
N/A
Total Funding
N/A
Headquarters
Arlington, West Virginia
Founded
2009
Get referred to Trilogy Federal
See people who can refer or advise you
Simplify's Take
What believers are saying
- March 12, 2026 hiring shows demand for Federal Financial and Momentum experts.
- July 2025 Vfmp Modernization Support Services awarded up to $4.6 million extends VA exposure.
- Broader VA modernization across OBO, VHA Finance, and Budget offices expands adjacent work.
What critics are saying
- VA concentration is brutal: one program shock can crush Trilogy Federal revenue in 2026.
- iFAMS commoditizes delivery work; Momentum integrators and prime contractors can displace Trilogy Federal.
- If VA pauses FMBT expansion, Trilogy Federal loses its clearest growth engine fast.
What makes Trilogy Federal unique
- VA iFAMS support gives Trilogy Federal a deep, defensible niche in federal ERP modernization.
- Jilee Rich joined as VP Growth on August 28, 2025, adding VA buying relationships.
- Seven successful iFAMS implementations anchor credibility with Veterans Affairs buyers.
Help us improve and share your feedback! Did you find this helpful?
Benefits
Health Insurance
Dental Insurance
Vision Insurance
401(k) Company Match
Paid Vacation
Paid Holidays
Pet Insurance
Phone/Internet Stipend
Tuition and Training Reimbursement
Company News
Jilee Rich joins Trilogy Federal as vice president of growth.