Data Engineer

Two Harbors Investment•St. Louis Park, MN

18d•Onsite

About The Position

The Data Engineer will be responsible for a wide variety of tasks which include 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 will be responsible for building and maintaining data pipelines, optimizing performance of database environments and automating data processes.

Requirements

5+ years proven experience 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 in working with relational databases
Hands-on experience with data warehouse solutions
Proficiency with the SQL query language, preferably Microsoft T-SQL.
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 education the following equivalent experience will be accepted: development life cycle of projects lasting longer than two years, requirements gathering, business and technical designs, development, quality assurance, deployment, support and documentation.
Must be flexible, action and results oriented, self-starting, have strong analytical skills, and be comfortable with a Microsoft SQL business intelligence environment

Nice To Haves

Familiarity with financial and/or mortgage servicing data but not mandatory
Experience in Azure Data Factory a plus
Experience in Active Batch scheduling software a plus

Responsibilities

Develop and deliver data solutions that comply with development standards.
Maintaining a relational database schema. This includes defining tables, relationships and constraints to ensure data integrity.
Build automated processes to Extract, Transform and Load data from various sources into a centralized data warehouse.
Optimizing complex SQL queries, indexing strategies and execution plans to handle large datasets efficiently.
Effectively assist in day-to-day tasks / activities in coordination with a team of developers to effectively meet the deliverables and schedule of a data solution component within a larger application project.
Lend support to various business and technology teams as necessary during design, development and delivery to ensure solid, scalable, robust data solutions.
Support and maintain data and database systems to meet business delivery specifications and needs.