BI & Reporting Analyst (SQL) - Onsite/Remote

Paycom - ATS; Arlington (VA); On-site; USD 72,000 - 88,000; Full time

Benefits offered by this job

Competitive salary

Medical, Dental, Vision benefits

Paid Holidays

401(k) with up to 4% company match

Accrued Paid Time Off, up to three w e

Job summary

Capitol Bridge, LLC in Arlington, VA seeks a Reporting Analyst to produce reliable lane-level reporting and reconcile data so leaders can manage inventory, quality, deadlines, and financial controls.

You will build recurring reports and dashboards, reconcile counts and statuses, validate data before distribution, analyze aging and throughput, and support scorecards and ad hoc analysis, while maintaining data accuracy and clear documentation.

Qualifications

• Experience with operational reporting, spreadsheets, BI tools, and data quality checks.
• Strong SQL or equivalent data extraction skills preferred.
• Ability to explain data limitations and work with sensitive case information.

Responsibilities

• Build recurring reports and dashboards using approved metric definitions and source data.
• Reconcile CTS and CMS counts, statuses, dates, and exceptions; document discrepancies and their owners.
• Validate data before distribution and maintain a record of assumptions, refresh dates, and corrections.
• Analyze aging, throughput, quality, rework, and emerging operational risks with lane leaders.
• Support scorecards and ad hoc analysis without altering source case decisions.

Skills

Operational reporting

SQL/data extraction

Job description

Capitol Bridge, LLC in Arlington, VA seeks a Reporting Analyst to produce reliable lane-level reporting and reconcile data so leaders can manage inventory, quality, deadlines, and financial controls.

You will build recurring reports and dashboards, reconcile counts and statuses, validate data before distribution, analyze aging and throughput, and support scorecards and ad hoc analysis, while maintaining data accuracy and clear documentation.