Business Systems Data Analyst

Job#: 3017942

Job Description:

Apex Systems, a World-Class Technology Solutions Provider, is seeking applicants for the below position on behalf of our client. Please apply if interested and qualified. Please note that only qualified candidates will be contacted.

Position: Business Systems Data Analyst

Location: Remote - EST Hours

Duration: 12+ Month Contract

Type: W2 contract, paid hourly. No C2C, 1099, or third-party submissions will be accepted. Only direct W-2 candidates will be considered.

Pay Rate Range: W2 $60-65/hr

Industry: Banking

Job Description:

We are seeking a highly skilled Data Analyst with strong expertise in SQL, SSIS, Power BI, and Kimball data warehouse design to support reporting and analytics within our loan servicing and financial systems environment. This role focuses on building complex data models, extracting and transforming loan data, and delivering high-quality business intelligence solutions to support operational and executive decision-making.

The ideal candidate understands the full lifecycle of a loan, can write complex SQL queries from scratch, and has hands-on experience developing ETL pipelines and enterprise reporting solutions.

Key Responsibilities

Data Engineering & ETL

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.

Data Warehouse & Modeling

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.

SQL Development

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.

Reporting & Analytics

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.

Data Quality & Governance

Implement data quality checks and monitoring frameworks.

Document data flows, transformations, and business logic.

Support audit, regulatory, and compliance reporting initiatives.

Required Qualifications

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 / Nice-to-Have Skills

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.

What Success Looks Like

You can independently build data pipelines from raw loan system data to enterprise dashboards.

You consistently deliver accurate, trusted, business-ready reports.

You anticipate data issues before they impact the business.

You act as a subject-matter expert for loan analytics and reporting

Apex Benefits Overview

Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a retirement plan (401k or local country equivalent) program. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click for more details.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.