onsite
Senior Loan Boarding Data Analyst - Cornerstone Capital Bank
Data Analyst
Senior analyst responsible for exploring, modeling, and visualizing loan boarding data, building secure ETL pipelines, and delivering actionable insights to stakeholders in a mortgage servicing environment.
About the role
Key Responsibilities
- Explore and analyze loan boarding datasets to identify trends, anomalies, and opportunities for process improvement.
- Design, develop, and maintain secure ETL pipelines that ingest, transform, and load mortgage data into analytical platforms.
- Create interactive dashboards and visual reports using tools such as Tableau or Power BI to communicate findings to business partners.
- Collaborate with product, operations, and compliance teams to define data requirements and ensure data quality and governance.
- Document data models, data dictionaries, and analytical methodologies to support reproducibility and auditability.
Requirements
- 5+ years of experience in data analysis or business intelligence, preferably within mortgage or financial services.
- Proficiency in SQL for complex queries and data manipulation.
- Strong programming skills in Python, including libraries for data cleaning and analysis (pandas, numpy).
- Experience building ETL workflows and data pipelines using tools such as Airflow, SSIS, or similar.
- Ability to translate business needs into clear visualizations and actionable insights.