Data Engineer

About the role

You will be responsible for a wide variety of tasks including all aspects of the development and delivery of data solutions and maintaining the enterprise data warehouse. You will work closely with business analysts, product managers, quality assurance, and business stakeholders to effectively implement data solutions. This role involves building and maintaining data pipelines, optimizing database performance, and automating data processes.

Responsibilities

• Develop and deliver data solutions that comply with development standards.
• Maintain a relational database schema, including defining tables, relationships, and constraints to ensure data integrity.
• Build automated processes to Extract, Transform, and Load (ETL) data from various sources into a centralized data warehouse.
• Optimize complex SQL queries, indexing strategies, and execution plans to handle large datasets efficiently.
• Assist in day-to-day tasks and activities in coordination with a team of developers to meet deliverables and schedules for data solution components within larger application projects.
• Support various business and technology teams during design, development, and delivery to ensure scalable, robust data solutions.
• Support and maintain data and database systems to meet business delivery specifications and needs.
• Demonstrate exceptional oral and written communication skills to facilitate effective cross-functional collaboration.

Requirements

• 5+ years of proven experience in a data-centric role within a collaborative data and technology team.
• Experience writing and optimizing complex SQL queries to extract large datasets.
• Proficiency with data transformation tools like SSIS.
• Advanced SQL knowledge and proficiency in working with relational databases, preferably Microsoft T-SQL.
• Hands-on experience with data warehouse solutions.
• Strong understanding of data modeling and best practices in data governance.
• Excellent problem-solving skills and the ability to work independently as well as collaboratively to resolve data-related issues.
• In lieu of formal education, equivalent experience will be accepted, such as involvement in the full development life cycle of projects lasting longer than two years, including requirements gathering, business and technical designs, development, quality assurance, deployment, support, and documentation.
• Must be flexible, action- and results-oriented, self-starting, with strong analytical skills, and comfortable in a Microsoft SQL business intelligence environment.
• Familiarity with financial and/or mortgage servicing data (not mandatory).

Preferred Qualifications

• Experience in Azure Data Factory.
• Experience in Active Batch scheduling software.
• Experience in Snowflake.

Benefits

• Medical, Dental, and Vision Insurance.
• Life and Disability Insurance.
• 401(k) with company matching.
• Generous Vacation and Paid Time Off (accrual-based).

Pay

Targeted compensation: $95,000–$120,000.

Schedule

This is a full-time, regular position.

Physical Demands & Working Conditions

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

About the Company

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 mortgage servicing rights (MSR) as core to its business strategy. The combined entity leverages the strengths of both companies, adding value for stakeholders through operational and cost efficiencies and expanded participation in the mortgage finance space. Founded in 2009, Two Harbors is a leading publicly traded residential mortgage real estate investment trust (mortgage REIT) focused on Agency residential mortgage-backed securities (RMBS) and MSR portfolios.

Location

Office locations: Fort Mill, SC; St. Louis Park, MN; Dallas, TX.