DescriptionRole Overview:
Owns business-rule validation and exception reporting for every RSIS submission and drives the monthly RAIRS production cycle to publication. Sets the quality bar for the three Data Analysts.
Responsibilities:
- Perform 100 percent data element, cross-field, cross-form, and cross-database validation on submitted safety data.
- Produce exception, delinquency, and repeat-offender reporting, and notify reporting railroads of errors on time.
- Run the monthly RAIRS cycle against the Table 3 timeline (final data published on the last working day of the month).
- Track first-pass conformance, error rates, and processing lead times for the Monthly Performance and Processing Report.
- Work with FRA subject matter experts to define new validation criteria when anomalies are found.
Required Minimum Qualifications:
- Bachelor's degree in Information Systems, Statistics, Mathematics, or a related field.
- 8+ years in data validation, data quality assurance, and SQL-based exception reporting.
- Advanced Excel and SQL; experience with reporting tools (Power BI, Tableau, or similar).
- U.S. citizen or lawful permanent resident; able to pass a DOT background investigation.
Nice to Have Qualifications:
- Regulatory or compliance data experience (safety incident, inspection, claims, or enforcement data).
- DAMA CDMP or Microsoft Certified: Power BI Data Analyst Associate.
- Experience coordinating corrections with external data submitters.
This position is contingent upon contract award. Employment is not guaranteed and will proceed only if the associated contract is awarded and funded.
The compensation range for this position is $95,000 - $135,000. Compensation decisions depend on a wide range of factors, including but not limited to location, skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.
