Hybrid BI & Reporting Analyst: Lender Performance & Risk

PCI Professional Services; Washington (District of Columbia); Hybrid; USD 90,000 - 140,000; Full time

Job summary

PCI Federal (PCIF) seeks a Reporting & BI Analyst to develop recurring and ad hoc analytical products for lender-performance monitoring, portfolio oversight, credit-risk analysis, and executive reporting. The role involves validating outputs, KPI development, and decision-support insights for stakeholders.

The position is hybrid and reports to the Program Manager, with responsibilities spanning data quality, analytics, and documentation across 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 required.

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 outputs.
• Prepare executive briefings and analytical summaries.
• Support data quality management, reconciliations, and performance monitoring.
• Coordinate with stakeholders to refine reporting requirements.
• Maintain reporting documentation, production schedules, and inventories.

Skills

SQL & data analysis

Tableau dashboards

Advanced Excel

Data warehousing/BI concepts

AWS Glue & ETL

AWS Cloud & S3

Statistical analysis

Data visualization automation

Structured/unstructured data

Education

Bachelor's degree in Finance/Economics/Statistics/Data Analytics/BI/Math/Accounting

Tools

Tableau

Excel

AWS Glue

ETL tools

AWS S3

Job description

PCI Federal (PCIF) seeks a Reporting & BI Analyst to develop recurring and ad hoc analytical products for lender-performance monitoring, portfolio oversight, credit-risk analysis, and executive reporting. The role involves validating outputs, KPI development, and decision-support insights for stakeholders.

The position is hybrid and reports to the Program Manager, with responsibilities spanning data quality, analytics, and documentation across reporting inventories.