Reporting & Business Intelligence (BI) Analyst

PCI Professional Services
  • Washington DC
    2 days ago

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

    Numbers & Facts

    LocationWashington DC
    Websitehttps://www.pci-ps.com

    Skills

    • Accountingunmatched
    • Amazon Simple Storage Service (S3)unmatched
    • Amazon Web Services (AWS)unmatched
    • Analysis Skillsunmatched
    • Automationunmatched
    • Business Intelligenceunmatched
    • Cloud Computingunmatched
    • Credit Analysisunmatched
    • Credit Riskunmatched
    • Data Analysisunmatched
    • Data Managementunmatched
    • Data Qualityunmatched
    • Data Setsunmatched
    • Data Visualizationunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Decision Supportunmatched
    • Develop Methodologiesunmatched
    • Documentationunmatched
    • Economicsunmatched
    • Financeunmatched
    • Financial Reportingunmatched
    • Financial Servicesunmatched
    • Inventory Reportsunmatched
    • Investment Managementunmatched
    • Loan Servicingunmatched
    • Loansunmatched
    • Mathematicsunmatched
    • Microsoft Excelunmatched
    • Performance Analysisunmatched
    • Performance Metricsunmatched
    • Product Supportunmatched
    • Production Scheduleunmatched
    • Quality Managementunmatched
    • Reconciliationunmatched
    • Reporting Dashboardsunmatched
    • Reporting Skillsunmatched
    • Requirements Managementunmatched
    • Risk Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • Small Businessunmatched
    • Statisticsunmatched
    • Tableauunmatched
    • Trend Analysisunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder