Job Description
One of Airetel Staffing's valued clients is looking for a Sr. Data Analyst located in Chicago, IL.
Senior Data Analyst, Data Solutions
Location: Chicago, IL (or willing to relocate)
Employment Type: Contract, Contract to Hire
Purpose and Role Summary
The Senior Data Analyst will play a key role in delivering data engineering, integration, and analytics capabilities supporting the client's direct lending platform. This role sits at the intersection of technology and business, enabling data-driven decision-making across originations, loan servicing, portfolio monitoring, and investor reporting.
The position requires a hands-on technical leader with strong domain expertise in commercial lending and private credit, combined with the ability to collaborate cross-functionally and deliver scalable, automated data solutions.
This role is ideal for a candidate who can translate complex business requirements into high-quality data pipelines, curated datasets, and reporting solutions while contributing to broader platform modernization efforts.
Essential Duties and Responsibilities
Data Engineering & Delivery
Data Quality, Controls, and Governance
Business Partnership & Domain Alignment
Reporting & Analytics Enablement
Project Delivery & Execution
Team Collaboration & Leadership
Required Qualifications
Technical Skills
Domain Expertise
Core Competencies
Senior Data Analyst, Data Solutions
Location: Chicago, IL (or willing to relocate)
Employment Type: Contract, Contract to Hire
The Senior Data Analyst will play a key role in delivering data engineering, integration, and analytics capabilities supporting the client's direct lending platform. This role sits at the intersection of technology and business, enabling data-driven decision-making across originations, loan servicing, portfolio monitoring, and investor reporting.
The position requires a hands-on technical leader with strong domain expertise in commercial lending and private credit, combined with the ability to collaborate cross-functionally and deliver scalable, automated data solutions.
This role is ideal for a candidate who can translate complex business requirements into high-quality data pipelines, curated datasets, and reporting solutions while contributing to broader platform modernization efforts.
Data Engineering & Delivery
- Design, develop, and maintain SQL-based data models, ETL/ELT pipelines, and integrated data solutions leveraging the Microsoft Stack (Platforms and Tools)
- Build and optimize data pipelines using:
- Microsoft SQL Server
- SSIS and/or Azure Data Factory
- Azure Data Lake / Synapse Analytics
- Leverage modern data processing frameworks (e.g., Databricks / Spark) where applicable
- Develop and maintain curated datasets and data models to support enterprise reporting and analytics
- Ensure scalability, performance, and maintainability of data solutions
- Implement and enforce data quality checks, validation rules, and reconciliation processes
- Ensure consistency and integrity across data assets used for reporting and analytics
- Maintain documentation for data pipelines, business logic, and data models
- Support adoption of standardized data governance practices and controls
- Partner with stakeholders across:
- Portfolio Management
- Investor Reporting
- Finance & Accounting
- Originations and Underwriting
- Translate private credit and lending requirements into scalable data solutions
- Support use cases across the lending lifecycle, including:
- Deal origination and underwriting
- Loan servicing and borrower monitoring
- Portfolio performance tracking
- Investor reporting and fund analytics
- Provide insights and analysis using loan-level and portfolio-level datasets
- Develop and support Power BI datasets, dashboards, and reporting solutions
- Enable self-service analytics through well-structured, governed datasets
- Support business-critical reporting, including:
- Portfolio monitoring
- Investor reporting
- Operational and performance analytics
- Ensure clear data lineage, transparency, and usability of enterprise data assets
- Support delivery of multiple concurrent initiatives across:
- Data engineering
- Reporting enhancements
- Platform modernization
- Collaborate with cross-functional global teams to manage:
- Requirements gathering
- Development and testing
- Deployment and post-production support
- Contribute to structured delivery practices including tracking milestones, dependencies, and risks
- Act as a senior individual contributor and technical lead for data initiatives
- Provide guidance and mentorship to junior team members and developers
- Collaborate effectively with distributed teams (onshore/offshore model)
- Contribute to knowledge sharing, documentation, and standardization efforts
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, Finance, or related field
- 10+ years of experience in:
- Data engineering
- Data warehousing
- Business intelligence or analytics
- Minimum 5 years of experience within financial services, preferably:
- Private credit
- Commercial lending
- Direct lending or asset management
- Strong expertise in:
- SQL Server (advanced T-SQL, query optimization, stored procedures)
- ETL development (SSIS and/or Azure Data Factory)
- Data warehousing and dimensional modeling
- Experience with Azure data platform (Data Lake, Synapse, or similar)
- Exposure to Databricks or distributed data processing frameworks
- Experience with BI tools (Power BI preferred)
- Experience with Agentic AI based Software Development approach
- Strong understanding of:
- Lending lifecycle (origination to servicing and monitoring)
- Loan products (e.g., term loans, revolvers)
- Portfolio and investor reporting
- Experience working with loan servicing systems such as FIS, WSO, or similar platforms as well as other platforms such as Salesforce, Oracle, etc.
- Analytical Thinking: Ability to break down complex data challenges into actionable solutions
- Business Acumen: Understanding of how data supports lending operations, risk management, and investor reporting
- Communication: Ability to translate technical concepts into business-relevant insights
- Execution: Strong ownership mindset with ability to deliver high-quality work across multiple priorities
- Collaboration: Proven ability to work effectively across business and technology teams
- Experience in private credit or middle-market lending environments
- Exposure to cloud modernization or enterprise data platform transformation initiatives
- Familiarity with data governance frameworks and best practices
- Experience working in hybrid onshore/offshore delivery models
Numbers & Facts
| Location | Chicago, IL |
Skills
- Accountingunmatched
- Analysis Skillsunmatched
- Artificial Intelligence (AI)unmatched
- Asset Managementunmatched
- Best Practicesunmatched
- Business Intelligenceunmatched
- Business Intelligence Softwareunmatched
- Business Skillsunmatched
- Business Supportunmatched
- Cloud Computingunmatched
- Commercial Loansunmatched
- Computer Scienceunmatched
- Cross-Functionalunmatched
- Customer Support/Serviceunmatched
- Data Analysisunmatched
- Data Lakeunmatched
- Data Managementunmatched
- Data Modelingunmatched
- Data Processingunmatched
- Data Qualityunmatched
- Data Setsunmatched
- Data Warehousingunmatched
- Database Extract Transform and Load (ETL)unmatched
- Dimensional Modelingunmatched
- Direct Lendingunmatched
- Documentationunmatched
- Financeunmatched
- Financial Servicesunmatched
- Information Technology & Information Systemsunmatched
- Investment Analysisunmatched
- Investment Managementunmatched
- Investor Relationsunmatched
- Leadershipunmatched
- Loan Operationsunmatched
- Loan Originationunmatched
- Loan Portfoliounmatched
- Loan Servicingunmatched
- Loansunmatched
- Mentoringunmatched
- Microsoft Product Familyunmatched
- Microsoft SQL Serverunmatched
- Microsoft Transact-SQL (T-SQL)unmatched
- Microsoft Windows Azureunmatched
- Multitaskingunmatched
- Operational Auditunmatched
- Operational Supportunmatched
- Oracleunmatched
- People Managementunmatched
- Performance Analysisunmatched
- Power BIunmatched
- Production Supportunmatched
- Project Executionunmatched
- Query Optimizationunmatched
- Reconciliationunmatched
- Reporting Dashboardsunmatched
- Requirements Managementunmatched
- Risk Managementunmatched
- SQL (Structured Query Language)unmatched
- SQL Server Integration Services (SSIS)unmatched
- Salesforce.comunmatched
- Software Developmentunmatched
- Stored Proceduresunmatched
- Team Playerunmatched
- Technical Leadershipunmatched
- Test Plan/Scheduleunmatched
- Training Data Setsunmatched
- Underwritingunmatched
- Usability Engineeringunmatched
- Use Casesunmatched
- Validation Testingunmatched
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 templatesFree 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