Reporting Analyst

Red Pulley, Inc.; Washington (District of Columbia); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

401(k) retirement plan

Health coverage

Life insurance

Paid time off

Tuition reimbursement

Job summary

Red Pulley Technology Solutions is seeking a Reporting Analyst 3 to support a federal Health IT modernization initiative for DHS/IHSC. The role involves creating and validating reports, dashboards, and scorecards, plus data analysis and documentation for government oversight.

The position requires a Bachelor's degree, 5+ years in reporting/BI, and a Public Trust or equivalent clearance. Location is Washington, DC metro area with remote option and occasional onsite work.

Qualifications

• Bachelor's degree in Information Systems, Data Analytics, Business Administration, or a related field.
• Minimum 5 years of demonstrated experience in reporting, dashboard development, business intelligence, data analysis, or related functions.
• Proficiency with reporting, visualization, spreadsheet, database-query, and business-intelligence technologies (e.g., SQL, Power BI, Tableau).
• Knowledge of reporting design, data validation, metrics development, and data-quality principles.
• Ability to translate reporting requirements into accurate and usable reports and dashboards.
• Strong analytical, documentation, troubleshooting, and communication skills.
• U.S. Citizen or Lawful Permanent Resident.
• Legal authorization to work in the U.S.

Responsibilities

• Develop, maintain, update, and validate recurring and ad hoc reports, dashboards, scorecards, and related reporting products.
• Gather and document reporting requirements, measures, calculations, definitions, filters, business rules, and data sources.
• Extract, analyze, reconcile, and validate data used in reports and dashboards.
• Conduct data-quality checks and investigate reporting discrepancies, anomalies, missing data, or inconsistencies.
• Develop and maintain report catalogs, report documentation, data definitions, calculation methodologies, and reporting procedures.
• Analyze reporting trends and variances and communicate significant findings to stakeholders.
• Automate or streamline approved reporting processes within authorized Government-managed environments.
• Document requirements and support testing, validation, and user feedback for Government-approved enhancements to reporting tools and processes.
• Coordinate with Data Analysts, Data Engineers, Data Scientists, Business Analysts, and other stakeholders to resolve data and reporting issues.
• Perform reporting-quality reviews and validate reports/dashboards for accuracy, completeness, consistency, and traceability before release.
• Compile and organize data and prepare draft supporting analyses for audits, reviews, and executive/external inquiries (Government officials retain responsibility for approving and issuing official responses).
• Maintain required reporting records and documentation in authorized Government repositories.

Skills

Analytical thinking

Documentation

Communication

Troubleshooting

Education

Bachelor's degree in Information Systems, Data Analytics, Business Administration, or related field

Tools

SQL

Power BI

Tableau

Job description

Description

Red Pulley Technology Solutions is seeking a Reporting Analyst 3 to support a federal Health IT modernization initiative for the Department of Homeland Security's Immigration and Customs Enforcement (ICE) Health Services Corps (IHSC). This role performs recurring and ad hoc reporting, dashboard development, report validation, data analysis, reporting-process management, and reporting documentation supporting IHSC's operational, clinical, program, and management information needs. All configuration and development activities are performed within authorized Government-managed platforms and environments, subject to Government oversight.

Location: Washington, DC Metro Area (Remote), with occasional onsite work required by Government

Clearance: Public Trust - Preliminary and Complete Fitness Determination Required

Employment Type: Full-Time

Status: Contingent Upon Contract Award

Minimum Qualifications:

• Bachelor's degree in Information Systems, Data Analytics, Business Administration, or a related field
• Minimum 5 years of demonstrated experience in reporting, dashboard development, business intelligence, data analysis, or related functions
• Proficiency with reporting, visualization, spreadsheet, database-query, and business-intelligence technologies (e.g., SQL, Power BI, Tableau)
• Knowledge of reporting design, data validation, metrics development, and data-quality principles
• Ability to translate reporting requirements into accurate and usable reports and dashboards
• Strong analytical, documentation, troubleshooting, and communication skills
• U.S. Citizen or Lawful Permanent Resident
• Legal authorization to work in the U.S.

Requirements

Key Responsibilities

• Develop, maintain, update, and validate recurring and ad hoc reports, dashboards, scorecards, and related reporting products
• Gather and document reporting requirements, measures, calculations, definitions, filters, business rules, and data sources
• Extract, analyze, reconcile, and validate data used in reports and dashboards
• Conduct data-quality checks and investigate reporting discrepancies, anomalies, missing data, or inconsistencies
• Develop and maintain report catalogs, report documentation, data definitions, calculation methodologies, and reporting procedures
• Analyze reporting trends and variances and communicate significant findings to stakeholders
• Automate or streamline approved reporting processes within authorized Government-managed environments
• Document requirements and support testing, validation, and user feedback for Government-approved enhancements to reporting tools and processes
• Coordinate with Data Analysts, Data Engineers, Data Scientists, Business Analysts, and other stakeholders to resolve data and reporting issues
• Perform reporting-quality reviews and validate reports/dashboards for accuracy, completeness, consistency, and traceability before release
• Compile and organize data and prepare draft supporting analyses for audits, reviews, and executive/external inquiries (Government officials retain responsibility for approving and issuing official responses)
• Maintain required reporting records and documentation in authorized Government repositories

Preferred Qualifications

• Experience with healthcare, Health IT, clinical, operational, or Federal reporting environments
• Existing federal security clearance or public trust determination
• Experience supporting EHR-generated data or federal health program reporting
• Familiarity with Government-managed reporting environments and change-control/approval workflows
• Existing federal security clearance or public trust determination

Benefits:

At Red Pulley Technology Solutions, we invest in our people so they can deliver exceptional results in support of critical missions. Our comprehensive benefits package includes:

• Competitive compensation aligned with experience and market conditions
• 401(k) retirement plan with company matching to support long-term financial security
• Comprehensive health coverage, including medical, dental, and vision insurance
• Health Savings Account (HSA) and Flexible Spending Account (FSA) options
• Life insurance coverage for added peace of mind
• Generous paid time off (PTO) to support work-life balance
• Parental leave for growing families
• Professional development assistance, including training and certification support
• Tuition reimbursement to encourage continued education and career advancement

Our benefits reflect Red Pulley’s commitment to workforce stability, professional growth, and creating an environment where mission-focused professionals can thrive.

Affirmative Action/EEO statement

Red Pulley is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunities regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status.