Position Summary
JOB DESCRIPTION
The role requires someone who can function under minimal direction and in a fast-paced environment, while working with a broad cross-section of the company, including Finance/Accounting, Servicing, Originations, Risk and Technology. The position focuses on analytics and business intelligence for the Capital Markets function to support lending and mortgage portfolio valuation, margin analysis, and various strategic initiatives. Working directly with business stakeholders, this role transforms complex mortgage data into actionable insights that drive business decisions and financial performance. The ideal candidate will have a working knowledge of scripts and query writing to efficiently present actionable insight when reviewing large data sets.
Job Functions And Responsibilities
- Develop robust and comprehensive data analytic strategies combining data from Servicing, Originations, accounting, and secondary marketing systems.
- Write and optimize complex SQL queries to extract and combine data from multiple mortgage systems.
- Build and maintain Power BI dashboards and reports to visualize key business metrics to enable data-driven decision-making.
- Assist in integrating and streamlining data flows from different sources (e.g., Excel, databases) into centralized repositories for efficient reporting.
- Automate routine business reporting through Python scripting
- Transform raw mortgage data into meaningful business metrics through SQL aggregations and calculations
- Troubleshoot and optimize existing Python and SQL scripts, ensuring they run efficiently and scale with the growth of the business.
- Collaborate with stakeholders to understand reporting requirements and create effective visualizations in Power BI.
- Perform ad-hoc analysis and reporting tasks as needed to support various teams and initiatives.
Qualifications
- 5+ years of experience with Python, including experience in automating workflows and interacting with APIs, databases, and file systems.
- Strong experience with SQL (Oracle and MSSQL) for writing efficient queries, creating joins, and optimizing performance.
- Hands-on experience with Power BI, including developing dashboards, working with DAX, and connecting to diverse data sources.
- Experience with data analysis, including transforming, cleaning, and processing large datasets.
- Ability to work independently, troubleshoot issues, and collaborate with various stakeholders within a fast-paced environment while interacting across various time zones.
- Strong communication skills to translate technical solutions into business value.
Preferred Skills
- Familiarity with tools such as ArcGIS for geospatial analysis and integrating spatial data into workflows.
- Experience with Mortgage Lending or Capital Markets functions within the financial services, industry is a plus.
- Familiarity with automating tasks related to loan and financial data is a plus.
Shift- Night
About Us
Ocwen Financial Solutions Private Limited is a wholly-owned subsidiary of Onity Group Inc., a leading non-bank mortgage servicer and originator providing solutions through its primary brands, PHH Mortgage and Liberty Reverse Mortgage.
PHH Mortgage is one of the largest servicers in the United States, focused on delivering a variety of servicing and lending programs. Liberty is one of the largest reverse mortgage lenders in the U.S., dedicated to education and providing loans that help customers meet their personal and financial needs. Onity Group Inc. and its subsidiaries are committed to helping homeowners and delivering exceptional service and value to customers, clients and investors.
At Onity Group Inc., we consistently deliver on our commitments to customers, clients, investors and colleagues through caring service, integrity and creative solutions. This Service Excellence philosophy is embraced by meeting service standards we call CARE, which stands for Caring, Accurate, Responsive and Empowered. We expect all employees to interact and engage our colleagues and our customers with respect, courtesy and professionalism, and to achieve results consistent with our CARE standards.
Onity Group Inc. is intensely focused on hiring, developing and retaining the best talent in the industry! Our commitment to Diversity, Equity & Inclusion ensures that we sustain our reputation as an outstanding place to work, a great business partner and a valued community member. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. If you have a disability or special need that requires accommodation, please let us know. Visit jobs.onitygroup.com for details.
