Reporting & Business Intelligence (BI) Analyst

PCI Professional Services LLC Washington, District of Columbia, United States · $100K–$125K/yr

Government Administration · 501-1,000 employees

7 h ago

Senior (5-10 yrs) Full-time United States

Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Reporting & BI Analyst develops recurring and ad hoc analytical products to support lender-performance monitoring, portfolio oversight, and credit-risk analysis. They are responsible for validating reporting outputs, developing KPIs, and providing actionable decision-support insights to stakeholders.

What they look for

SQL Tableau Microsoft Excel Data Analysis Business Intelligence AWS Glue ETL Data Warehousing Statistical Analysis Trend Modeling Data Visualization Reporting Automation Credit-risk Analysis Portfolio Management Financial Analysis Data Quality Management

Requirements

Candidates must hold a bachelor's degree in a quantitative or business-related field and possess 6-9 years of applicable experience. Proficiency in SQL, Tableau, and advanced data analysis techniques is required, along with experience in AWS cloud environments.

Full description

Position Summary

The Reporting & BI Analyst develops recurring and ad hoc analytical products supporting lender-performance monitoring, portfolio oversight, credit-risk analysis, and executive reporting. This position performs data analysis, validates reporting outputs, develops KPIs, and provides decision-support insights to stakeholders.

This position is hybrid and reports to the Program Manager.

Key Responsibilities

Produce recurring and ad hoc reporting products.

Analyze lender performance, portfolio trends, peer-group comparisons, and emerging risks.

Develop reporting methodologies, KPIs, and analytical frameworks.

Validate calculations, transformations, business rules, and reporting outputs.

Prepare executive briefings and analytical summaries.

Support data quality management, reconciliations, and performance monitoring.

Coordinate with stakeholders to refine reporting requirements and analytical products.

Maintain reporting documentation, production schedules, and reporting inventories.

Qualifications:

Bachelor's degree in Finance, Economics, Statistics, Data Analytics, Business Intelligence, Mathematics, Accounting, or related field.

6-9 Years of applicable experience is required

Technical Skills

SQL and advanced data analysis.

Tableau dashboard development and reporting.

Advanced Microsoft Excel.

Data warehousing and business intelligence concepts.

AWS Glue and ETL processing.

AWS Cloud and Amazon S3 data environments.

Statistical analysis and trend modeling.

Data visualization and reporting automation tools.

Experience working with structured and unstructured datasets.

Preferred Experience

SBA 7(a), 504, lender oversight, or loan-servicing programs.

Credit-risk analysis, lender monitoring, and portfolio management.

ETRAN, ELIPS, CAFS, Experian, S&P financial datasets, or comparable financial-services data environments.

PCI Federal (PCIF) and its subsidiaries are an equal-opportunity employer. PCIF does not discriminate on the basis of age, sex, race, national origin, religion, marital status, sexual orientation or identity, Veterans or Disability status.

Preference may be extended to qualified Native American Indian candidates in accordance with applicable federal law.