Senior Data Engineer: Data Warehousing & ETL Specialist

TWO; Minnesota, United States, Northern America, Americas; Hybrid; USD 95,000 - 120,000; Full time

Benefits offered by this job

Medical / Dental / Vision Insurance

Life / Disability Insurance

401(k) with company matching

Generous Vacation / PTO

Job summary

RoundPoint Mortgage Servicing LLC is seeking a Data Engineer to develop and maintain data pipelines, optimize SQL performance, and automate ETL processes for a centralized data warehouse. You will work closely with analysts, product managers and stakeholders to implement robust data solutions within a mortgage data context.

The role emphasizes building scalable data systems, collaborating across teams, and ensuring high data integrity in a MS SQL/BI environment.

Qualifications

• 5+ years proven experience in a data-centric role within a collaborative data and 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.

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 for large datasets.
• Collaborate with developers to meet deliverables and schedules within a larger project.
• Support business/technology teams to ensure scalable data solutions.
• Maintain data and database systems to meet delivery needs.
• Communicate effectively across teams.

Skills

SQL

SSIS

Data modeling

MS SQL

BI environment

Analytical skills

Independent worker

Financial/mortgage data familiarity

Azure Data Factory

Snowflake

Active Batch

Education

Equivalent experience in lieu of degree

Tools

Azure Data Factory

Active Batch

Snowflake

Job description

RoundPoint Mortgage Servicing LLC is seeking a Data Engineer to develop and maintain data pipelines, optimize SQL performance, and automate ETL processes for a centralized data warehouse. You will work closely with analysts, product managers and stakeholders to implement robust data solutions within a mortgage data context.

The role emphasizes building scalable data systems, collaborating across teams, and ensuring high data integrity in a MS SQL/BI environment.