Senior Data Quality Analyst

BDR Solutions, LLC; Washington (District of Columbia); On-site; USD 95,000 - 135,000; Full time

Job summary

BDR Solutions, LLC in Washington, DC seeks an experienced Data Validation Analyst to own validation, exception reporting, and RAIRS production cycles. You will drive quality across data elements and collaborate with FRA SMEs to refine validation criteria.

The role requires 8+ years in data validation, strong Excel/SQL skills, and experience with Power BI or Tableau. U.S. citizenship or lawful residency and ability to pass a DOT background check are required.

Qualifications

• Bachelor's degree in Information Systems, Statistics, Mathematics, or 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.
• Regulatory or compliance data experience and relevant certifications are a plus.
• Experience coordinating corrections with external data submitters may be beneficial.

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.

Skills

Advanced Excel

SQL

Power BI

Tableau

Data validation

Education

Bachelor's degree in Information Systems/Statistics/Mathematics

Tools

Power BI

Tableau

Job description

Description

About us:

BDR Solutions, LLC, (BDR) supports the U.S. Federal Government in successfully achieving its mission and goals. Our service and solution delivery starts with understanding each client’s end-state, and then seamlessly integrating within each Agency’s organization to improve and enhance business and technical operations and deployments.

(Military Veterans are highly encouraged to apply)

Role 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.

In addition, U.S Citizenship is required. Select applicants will be subject to a government security investigation and must meet eligibility requirements for access to classified information and be able to obtain a government‑granted security clearance. Individuals may also be subject to a background investigation including, but not limited to criminal history, employment and education verification, drug testing, and creditworthiness.

BDR Solutions is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation. For individuals with disabilities who would like to request an accommodation, please contact [e-mail].

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.