Apex Systems · 10 hours ago
Business Systems Data Analyst
United States
Contract
Remote
Mid Level
$60/hr - $65/hrApex Systems, a World-Class Technology Solutions Provider, is seeking a Business Systems Data Analyst to support reporting and analytics within loan servicing and financial systems. The role focuses on building data models, extracting and transforming loan data, and delivering business intelligence solutions for decision-making.
Human ResourcesInformation TechnologyRecruiting
Responsibilities
Design, develop, and maintain ETL pipelines using SSIS to extract, transform, and load data from loan systems into enterprise data warehouses
Build data pipelines that support loan origination, servicing, payment history, delinquency, and charge-off analytics
Optimize and troubleshoot existing ETL workflows for performance and reliability
Collaborate with source system owners to ensure data accuracy and consistency
Design and maintain dimensional models following the Kimball methodology
Create and manage fact and dimension tables related to loan portfolios, borrower profiles, transaction history, and risk indicators
Ensure data integrity across staging, ODS, and data warehouse layers
Write complex SQL queries from scratch, including multi-table joins, window functions, CTEs, subqueries, and performance-optimized scripts
Perform advanced data validation, reconciliation, and anomaly detection
Develop stored procedures and views to support analytics and reporting needs
Develop and maintain dashboards and operational reports using Power BI
Translate business requirements into meaningful KPIs and visualizations
Partner with stakeholders to understand reporting needs across loan servicing, compliance, operations, and finance
Implement data quality checks and monitoring frameworks
Document data flows, transformations, and business logic
Support audit, regulatory, and compliance reporting initiatives
Qualification
Required
Strong SQL expertise – ability to design and troubleshoot complex queries independently
Hands-on SSIS experience building enterprise-grade ETL pipelines
Advanced experience creating reports and dashboards in Power BI
Solid understanding of Kimball data warehouse architecture
In-depth knowledge of the loan lifecycle, including origination, servicing, payments, delinquency, and close-out
Experience working with loan servicing systems or financial services platforms
Strong analytical and problem-solving skills
Preferred
Experience with Informatica as an alternative ETL tool
Working knowledge of Python for data processing or automation
Background in financial services, banking, mortgage, or consumer lending environments
Familiarity with data governance, regulatory reporting, and compliance frameworks
Benefits
Medical
Dental
Vision
Life
Disability
Other insurance plans that offer an optional layer of financial protection
ESPP (employee stock purchase program)
401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure
HSA (Health Savings Account on the HDHP plan)
SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions
Corporate discount savings program
Other discounts
On-demand training program
Access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure
Certification discounts and other perks to associations that include CompTIA and IIBA
Dedicated customer service team for our Consultants that can address questions around benefits and other resources
Certified Career Coach
Company
Apex Systems
Apex Systems, a division of On Assignment, provides organizations with IT staffing solutions to address gaps in their current workforce.
Founded in 1995
1001-5000 employees
H1B Sponsorship
Apex Systems 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
2025 (28)
2024 (21)
2023 (35)
2022 (26)
2021 (29)
2020 (38)
Funding
Current Stage
Late StageLeadership Team
Roger Wahman
Chief Technology Officer - SVP
Andrea Schiola
Global Head of Technology Partnerships, SVP, Principal
Recent News
Company data provided by crunchbase