Senior Data Engineer: Data Warehouse & Pipelines

Two Harbors Investment Corp.; Saint Louis Park (MN); On-site; USD 95,000 - 120,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life/Disability Insurance

401(k) with company matching

Generous Vacation / PTO

Job summary

Two Harbors Investment Corp. in Saint Louis Park, MN is seeking a Data Engineer to design and deliver data solutions for the enterprise data warehouse, collaborating with business analysts and product teams to translate requirements into scalable pipelines.

You will optimize SQL queries, build automated ETL processes (SSIS), and maintain data models while supporting governance and BI initiatives across the organization.

Qualifications

• 5+ years in a data-centric role within a collaborative data and technology 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, preferably T-SQL.
• strong understanding of data modeling and data governance best practices.

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 project schedules.
• Support business and technology teams during design, development and delivery of data solutions.
• Maintain data and database systems to meet business delivery needs.
• Communicate effectively across teams.

Skills

SQL

Data warehousing

Data modeling

T-SQL

Data governance

Relational databases

Mortgage data

Tools

SSIS

Azure Data Factory

Snowflake

ActiveBatch

Job description

Two Harbors Investment Corp. in Saint Louis Park, MN is seeking a Data Engineer to design and deliver data solutions for the enterprise data warehouse, collaborating with business analysts and product teams to translate requirements into scalable pipelines.

You will optimize SQL queries, build automated ETL processes (SSIS), and maintain data models while supporting governance and BI initiatives across the organization.