Business Systems Data Analyst

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 reputed company. Please note that only reputed company candidates will be contacted. Position: Business Systems Data AnalystLocation: Remote - EST HoursDuration: 12+ Month ContractType: W2 contract, paid hourly. No C2C, 1099, or reputed company-party submissions will be accepted. Only direct W-2 candidates will be considered. Pay reputed company reputed company: W2 $60-65/hrIndustry: 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 reputed company our loan servicing and financial systems environment. This role focuses on building reputed company 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 reputed company SQL queries from scratch, and has hands-on experience developing ETL pipelines and reputed company reporting solutions.

Key Responsibilities

Data Engineering & ETL•Design, reputed company, and maintain ETL pipelines using SSIS to extract, transform, and load data from loan systems into reputed company 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 reputed company 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 reputed company to loan portfolios, borrower profiles, transaction history, and risk indicators.•Ensure data reputed company across staging, ODS, and data warehouse layers. SQL Development•Write reputed company SQL queries from scratch, including multi-table joins, window functions, CTEs, subqueries, and performance-optimized scripts.•reputed company advanced data validation, reconciliation, and anomaly detection.•reputed company stored procedures and views to support analytics and reporting needs. Reporting & Analytics•reputed company 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 reputed company queries independently.•Hands-on SSIS experience building reputed company-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 reputed company-out.•Experience working with loan servicing systems or financial services platforms.•Strong analytical and problem-solving skills. Preferred / reputed company-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 reputed company Looks Like•You can independently build data pipelines from raw loan system data to reputed company dashboards.•You consistently deliver accurate, trusted, business-reputed company reports.•You anticipate data issues before they impact the business.•You act as a subject-matter expert for loan analytics and reporting Apex Benefits OverviewApex offers a reputed company of supplemental benefits, including medical, dental, reputed company, 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 reputed company 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 reputed company 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 reputed company a full list of our benefits, programs, support teams and resources reputed company our ‘Welcome Packet’ as well, which an Apex team member can reputed company. EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the reputed company of race, reputed company, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or reputed company medical conditions), age, sexual orientation, gender identity, national reputed company, reputed company, 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 reputed company 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 [email protected] or 844-463-6178. Apex Systems is a world-class IT services company that serves thousands of clients across the globe. reputed company you join Apex, you become part of reputed company that values innovation, collaboration, and reputed company learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to reputed company is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great reputed company to Work® in the United Kingdom and Mexico. Apply tot his job Apply To this Job