Data Engineer: Build Scalable Data Pipelines & DW

RoundPoint Mortgage Servicing LLC; Minneapolis (MN); On-site; USD 95,000 - 120,000; Full time

Benefits offered by this job

Medical Insurance

Life Insurance

401(k) with company matching

Generous Vacation / Paid Time Off

Job summary

RoundPoint Mortgage Servicing LLC seeks a Data Engineer to design and deliver data solutions for the enterprise data warehouse. You will partner with business analysts, product managers and QA to implement robust data pipelines and ensure data quality.

The role emphasizes optimizing SQL performance, maintaining relational schemas, and automating ETL processes across sources. Strong collaboration and communication are essential in a mortgage servicing environment.

Qualifications

• 5+ years in a data-centric role within a collaborative data/tech team.
• Writing and optimizing complex SQL queries to extract large datasets.
• Using data transformation tools like SSIS.
• Advanced SQL knowledge and proficiency with relational databases.
• Hands-on experience with data warehouse solutions.
• Proficiency with SQL language, preferably T-SQL.
• Knowledge of data modeling and data governance best practices.
• Flexible, self-starting, analytical, and collaborative.
• Familiarity with financial/mortgage servicing data preferred.

Responsibilities

• Develop and deliver data solutions that comply with development standards.
• Maintain a relational database schema with tables, relationships and constraints.
• Build automated ETL processes to load data into a centralized data warehouse.
• Optimize complex SQL queries, indexing strategies and execution plans.
• Collaborate with developers to meet deliverables within a larger project.
• Support business and technology teams to ensure scalable data solutions.
• Maintain data and database systems to meet business needs.
• Communicate effectively across cross-functional teams.

Skills

SQL

SSIS

Data warehouse

Azure Data Factory

Snowflake

Data modeling

T-SQL (Microsoft SQL)

Education

Equivalent experience in lieu of education

Tools

Active Batch

Job description

RoundPoint Mortgage Servicing LLC seeks a Data Engineer to design and deliver data solutions for the enterprise data warehouse. You will partner with business analysts, product managers and QA to implement robust data pipelines and ensure data quality.

The role emphasizes optimizing SQL performance, maintaining relational schemas, and automating ETL processes across sources. Strong collaboration and communication are essential in a mortgage servicing environment.