Business Systems Data Analyst

Job Summary

A company is looking for a Business Systems Data Analyst to support reporting and analytics within loan servicing and financial systems.

Key Responsibilities

• Design, develop, and maintain ETL pipelines using SSIS for data extraction and transformation
• Create and manage dimensional models and ensure data integrity across various layers
• Develop and maintain dashboards and reports using Power BI to meet business requirements

Required Qualifications

• Strong SQL expertise with the ability to design and troubleshoot complex queries
• Hands-on experience with SSIS for building enterprise-grade ETL pipelines
• Advanced skills in creating reports and dashboards in Power BI
• Solid understanding of Kimball data warehouse architecture
• In-depth knowledge of the loan lifecycle, including origination and servicing