Systems, Reporting, & Analysis - Reporting Developer

RoundPoint Mortgage Servicing LLC is seeking a Reporting Developer to join a diverse team in our exciting and fast-paced organization. This role will focus on building engaging visualizations, enhancing data models and performance, and delivering impactful reports – all of which will directly drive decisioning, profits, and compliance. The Reporting Developer will work with large data sets related to loan level mortgage servicing and originations data, perform data mining and analysis, and work closely with business units. Qualified candidates will be passionate about data, flexible, results oriented, self-starting, possess strong communication skills, and have familiarity with the mortgage servicing and originations market.

Responsibilities

• Design and build robust Business Intelligence reports, KPIs, dashboards, and engaging visualizations tailored to the needs of various Business Units in an Agile environment
• Ensure reports are intuitive and visually compelling, enabling end users to easily interpret and interact with the data to drive processes and decisions
• Build structured tabular reporting as needed to meet the needs of business processes and controls
• Perform data analysis and ad hoc reporting to answer complex and time sensitive questions critical to strategy
• Build SQL Stored Procedures, Views, and Functions to facilitate effective and optimized reporting output
• Where necessary, develop and maintain data models to ensure efficient report performance and data accuracy
• Collaborate with Business Leaders on developing a vision and long-term goals for reporting
• Connect, integrate, and transform data from multiple systems and sources to create cohesive datasets
• Work closely with Business Analysts to build, maintain, and enhance reporting
• Work closely with various Business Units to understand reporting requirements and translate them into actionable reports
• Provide ongoing support and maintenance for developed reports
• Continuously evaluate new BI Tools’ features and data visualizations to enhance reporting capabilities
  
  

Qualifications

Required

• Bachelor’s degree in Finance, Information Systems, Computer Science, Data Analytics, Data Science, or equivalent combination of education and/or experience
• 5 years of experience with business intelligence reporting tools such as Power BI (including DAX), MicroStrategy, or Tableau
• Expertise in the design, development, and formatting of tabular reports, charts, graphs, dashboards with drilldown capability, and other custom visualizations
• High proficiency with T-SQL, SSMS, SSRS, and Visual Studio
• Experience with data modelling specific to reporting, database architecture, and building robust data sets
• Experience creating database objects, stored procedures, and indexing
• Experience in the mortgage industry, working with mortgage data (Servicing and Originations)
• Must have strong analytical skills and a knack for creative problem solving
• Ability to collaborate effectively and respectfully across diverse audiences and teams
• Strong written and verbal communication skills, with demonstrated ability to effectively communicate with internal and external customers, peers and management
• Strong attention to detail and ability to handle multiple time sensitive tasks
• Demonstrates flexibility in responding to changes in assignment and job responsibility in a dynamic environment
  
  

Preferred

• Experience building ETL with tools such as SSIS
• Experience working with MSP/LPS/Black Knight servicing systems
• Experience with Python
  
  

Physical Demands & Working Conditions

Duties

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job:

• The employee is regularly required to talk or hear.
• The employee is required to sit for extended periods of time and is occasionally required to stand and walk.
• The employee must regularly use hands to finger, handle, or feel objects and is regularly required to reach with hands and arms; the employee may occasionally climb or balance, and stoop, kneel, crouch, or crawl.
• The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
• Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus.
• The noise level in the work environment is usually quiet to moderate, and no extreme conditions are present.
  
  

About RoundPoint Mortgage Servicing LLC

RoundPoint Mortgage Servicing LLC is a fully integrated, non-bank mortgage company, with a subservicing portfolio of approximately 900,000 loans. In 2023, RoundPoint was acquired by Two Harbors Investment Corp. (NYSE: TWO), reaffirming its commitment to MSR as core and essential to our business strategy and our future. A combined Two Harbors and RoundPoint capitalizes on the strengths of both companies, adding significant value for stakeholders through operational and cost efficiencies, as well as the ability to participate more fully in the mortgage finance space as opportunities arise.

Founded in 2009, Two Harbors has grown into a leading publicly traded residential mortgage real estate investment trust (mortgage REIT). We leverage our core competencies of understanding and managing interest rate and prepayment risk to invest in our Agency residential mortgage-backed securities (RMBS) and mortgage servicing rights (MSR) portfolio, with the objective of delivering attractive risk-adjusted returns to our stockholders.

Location

• Fort Mill, SC
• Coppell, TX
• St. Louis Park. MN
  
  

Employee Status

• Regular
  
  

Travel

• No