Reporting Developer

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
• Develop SQL Stored Procedures, Views, and Functions to facilitate effective and optimized reporting output
• 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
• Required: 5+ years of experience with business intelligence reporting tools such as Power BI (including DAX), MicroStrategy, or Tableau
• Required: High proficiency with T-SQL, SSMS, SSRS, and Visual Studio
• Required: Experience with data modelling specific to reporting, database architecture, and building robust data sets
• Required: Experience creating database objects, stored procedures, and indexing
• Required: Experience in the mortgage industry, working with mortgage data (Servicing and Originations)
• Required: Strong analytical skills and a knack for creative problem solving
• Required: Ability to collaborate effectively and respectfully across diverse audiences and teams
• Required: Strong written and verbal communication skills, with demonstrated ability to effectively communicate with internal and external customers, peers and management
• Required: Strong attention to detail and ability to handle multiple time sensitive tasks
• Preferred: Experience building ETL with tools such as SSIS
• Preferred: Experience working with MSP/LPS/Black Knight servicing systems
• Preferred: Experience with Python

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: Office Location: Fort Mill, SC

Employee Status: Regular

Travel: No