Senior Data Analyst

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)
50% Travel
Able to Provide Sponsorship

Skills

Analytical Skill
Analytics
Attention To Detail
Business Planning
Collaboration
Collections
Collections Management
Communication
Conflict Resolution
Credit Risk
DAX
Dashboard
Data Analysis
Data Modeling
Data Visualization
Data Warehouse
Extract, Transform, Load
Finance
Financial Modeling
Financial Reporting
Financial Services
Financial Statements
Forecasting
Git
Insurance
Leadership
Management
Microsoft Excel
Microsoft Power BI
Performance Metrics
Pivot Table
Problem Solving
Process Improvement
Python
Quality Assurance
Regulatory Compliance
Reporting
Risk Management
SQL
Snow Flake Schema
Statistics
Underwriting
Version Control
Writing

Job Details

Position:  Senior Data Analyst

Location: Charlotte, NC

Required 10+ years of experience candidate.

 

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

Required Skills

  • 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.
  • 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.