Reporting & Business Intelligence (BI) Analyst

PCI Professional Services LLC; Washington (District of Columbia); Hybrid; USD 110,000 - 160,000; Full time

Job summary

PCI Professional Services LLC invites applications for the Reporting & BI Analyst role in Washington DC. The position develops recurring and ad hoc analytical products supporting lender-performance monitoring, portfolio oversight, credit-risk analysis, and executive reporting.

You will perform data analysis, validate outputs, develop KPIs, and provide decision-support insights to stakeholders. The role is hybrid and reports to the Program Manager.

Qualifications

• Bachelor's degree required in Finance, Economics, Statistics, Data Analytics, BI, 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 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.

Skills

SQL

Advanced Excel

Data warehousing

ETL processing

AWS Glue

AWS S3

Statistics

Data visualization

Structured data

Unstructured data

Education

Bachelor's degree in Finance/Economics/Statistics

Job description

Position: Reporting & Business Intelligence (BI) Analyst

Location: Washington DC, DC

Remote Status: Hybrid

Job Id:193-SBA LLMS

# of Openings:1

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

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.