Imperial PFS · 7 hours ago
Data Analyst II
Kansas City, MO
Full-time
Onsite
Entry, Mid Level
2+ years expImperial PFS is seeking a skilled Data Analyst II to join their Data Analytics team. The role involves analyzing loan portfolios and financial performance metrics to support lending operations and drive business decisions through analytics solutions.
FinanceFinancial ServicesInsurTechPayments
Responsibilities
Design, develop, and maintain interactive dashboards and reports in Power BI to monitor loan portfolio performance, payment trends, delinquency rates, and key financial metrics
Write SQL queries to extract, transform, and analyze large datasets from Snowflake
Conduct in-depth analysis of loan performance metrics including funded volume, outstanding balances, loss rates, and portfolio aging
Analyze collection effectiveness, payment patterns, and delinquency trends to support risk management
Collaborate collections, operations, and finance teams to understand reporting requirements and translate them into analytical solutions
Develop financial models and forecasts to support business planning initiatives
Ensure data accuracy and integrity by performing quality assurance checks
Identify opportunities for process improvements and operational efficiencies through data-driven insights
Document analytics processes, data definitions, and reporting methodologies to maintain institutional knowledge
Support ad-hoc data requests from executive leadership and provide timely responses to analytical inquiries
Qualification
Required
SQL: Advanced proficiency in writing queries
Power BI: Strong experience creating interactive dashboards, reports, and visualizations using DAX and Power Query
Excel: Advanced skills including pivot tables, INDEX/MATCH, financial formulas, and data analysis tools
Mathematical & Statistical Analysis: Solid understanding of statistical concepts, financial metrics, data modeling, and analytical problem-solving
Financial Knowledge: Understanding of financial statements, lending operations, and key performance indicators in the finance industry or insurance industry
Communication: Excellent ability to translate complex financial data and analytics into clear, actionable insights for both technical and non-technical audiences
Attention to Detail: Strong commitment to data accuracy and quality, particularly critical for financial reporting and regulatory compliance
Problem-Solving: Demonstrated ability to break down complex business problems and develop data-driven solutions for financial operations
Time Management: Proven ability to manage multiple priorities, meet reporting deadlines, and deliver results
Bachelor's degree in Data Analytics, Finance, Computer Science, Statistics, Mathematics, Information Systems, Business Analytics, Economics, or a related field
2-4 years of professional experience in data analysis, business intelligence, or financial analytics role
Experience in financial services, lending, or premium finance industry is highly desirable
Preferred
Experience working with Snowflake data warehouse platform, including knowledge of Snowflake-specific features
Proficiency in Python for data analysis
Previous experience in premium finance, insurance finance, lending, or financial services industry
Knowledge of lending operations, underwriting processes, and collections management
Familiarity with loan portfolio analytics and credit risk metrics
Experience with financial modeling and forecasting techniques
Familiarity with data visualization best practices and principles
Experience with version control systems (Git)
Knowledge of ETL processes and data pipeline concepts
Company
Imperial PFS
Imperial PFS® offers premium financing solutions for the commercial insurance industry.
501-1000 employees
H1B Sponsorship
Imperial PFS has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (2)
2021 (2)
2020 (2)
Funding
Current Stage
Late StageLeadership Team
Bryan Andres
Executive Vice President / CFO
Brian Fugere
Chief Growth Officer
Recent News
Company data provided by crunchbase