What are the responsibilities and job description for the Data Cleanse Specialist position at Trilogy Federal?
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.
We are looking for a Data Cleanse Specialist with experience in federal financial management and data governance to support a high-impact modernization project for a large federal agency. This position is responsible for ensuring that financial data is accurate, complete, and in compliance with federal reporting, internal control, and system implementation requirements. The candidate will support the customer by leading and coordinating activities related to data cleanse execution, validation, and reconciliation. This includes identifying and resolving data anomalies, standardizing data structures, and ensuring all adjustments are traceable for audit purposes. The candidate will work collaboratively with technical, functional, and audit teams to help enforce consistent data standards to support audit readiness and data integrity.
We are seeking candidates for a full-time remote position, with potential opportunities for onsite work in the future. We are looking to staff this position in Q2 2026.
Primary Responsibilities: - Execute data cleanse and validation strategies against legacy financial data
- Collaborate with a variety of teams, including technical resources, end user groups, and stakeholders to review and confirm data cleanse requirements and methodologies
- Develop briefings, white papers and other materials to enhance leadership and field level understanding of data cleanse activities, status and/or issues
- Analyze, execute, and enhance data cleanse strategy to ensure financial data supports audit readiness and is prepared for transition to target financial system
- Design and develop metrics, reports, and/or dashboards for reporting data cleanse progress
- Perform analysis on financial data to identify additional opportunities for data cleansing
- Attend and play an active role in meetings with client stakeholders
- Demonstrate agility, flexibility, broad support, commitment to customer satisfaction, responsiveness to contract requirements and proactive qualities
- Conduct analysis on problems independently, research and recommend solutions, and execute resolution steps to address client issues
- Bachelor's degree
- 8 years' experience as a program analyst supporting system implementation and/or data cleanse/management efforts
- Strong understanding of federal financial reporting and accounting processes and expertise in managing or working with outstanding obligations, unliquidated obligations, and open financial system transactions
- Hands-on experience with Financial ERP systems, specifically with CGI's Federal Financial System (FFS) and Momentum
- Ability to effectively communicate and interact with senior level management and clients
- Expert in Microsoft Excel, including but not limited to application of formulas, macros, filtering, pivot tables, graphs and charts
- Strong analytical stills
- Strong written and oral communication skills
- An outstanding ability to establish priorities and meet deadlines
- Ability to obtain a Public Trust clearance
- VA or Federal experience preferred
- 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
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.
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.