The Senior Data Engineer will be responsible for all aspects of the design, development and delivery of data solutions and maintaining and enterprise data warehouse. You will work closely with 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.
Key Tasks and Responsibilities
Develop and deliver / implement data solutions to include architecture design, prototyping of concepts to proof of concept, development of standards, design and development of test plans, code and module design, development and testing, data solution debugging, design and implementation of a solution that follows efficient design techniques and development that meets and exceeds the intent of the design of the data solution.
Experience in coaching and mentoring data engineers with development, planning and projects.
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.
Exceptional oral and written communication skills, facilitating effective cross-functional collaboration.
Minimum 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 and Azure Data Factory
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
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
Physical Demands and Work Environment
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job:
The employee is regularly required to talk or hear.
The employee is required to sit for extended periods of time and is occasionally required to stand and walk.
The employee must regularly use hands to finger, handle, or feel objects and is regularly required to reach with hands and arms; the employee may occasionally climb or balance, and stoop, kneel, crouch, or crawl.
The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus.
The noise level in the work environment is usually quiet to moderate, and no extreme conditions are present.
All full-time employees of Two Harbors and its subsidiary companies are eligible for our benefits which include:
Medical / Dental / Vision Insurance
Life / Disability Insurance
401(k) with company matching
Generous Vacation / Paid Time Off (accrual based)
Targeted Compensation: $125,000-$145,000
About RoundPoint Mortgage
Founded in 2009, Two Harbors Investment Corp. (NYSE: TWO) has grown into a leading publicly traded residential mortgage real estate investment trust (mortgage REIT). We leverage our core competencies of understanding and managing interest rate and prepayment risk to invest in our Agency residential mortgage-backed securities (RMBS) and mortgage servicing rights (MSR) portfolio, with the objective of delivering attractive risk-adjusted returns to our stockholders.
In 2023, we acquired RoundPoint Mortgage Servicing LLC, a fully integrated, non-bank mortgage company, reaffirming our commitment to MSR as core and essential to our business strategy and our future. A combined Two Harbors and RoundPoint capitalizes on the strengths of both companies, adding significant value for stakeholders through operational and cost efficiencies, as well as the ability to participate more fully in the mortgage finance space as opportunities arise.
Location
St. Louis Park, MN
Employee Status
Regular
Travel
No
Telecommuter Position
No
Founded in 2009, Two Harbors Investment Corp. (NYSE: TWO) has grown into a leading publicly traded residential mortgage real estate investment trust (mortgage REIT). We leverage our core competencies of understanding and managing interest rate and prepayment risk to invest in our Agency residential mortgage-backed securities (RMBS) and mortgage servicing rights (MSR) portfolio, with the objective of delivering attractive risk-adjusted returns to our stockholders.
In 2023, we acquired RoundPoint Mortgage Servicing LLC, a fully integrated, non-bank mortgage company, reaffirming our commitment to MSR as core and essential to our business strategy and our future. A combined Two Harbors and RoundPoint capitalizes on the strengths of both companies, adding significant value for stakeholders through operational and cost efficiencies, as well as the ability to participate more fully in the mortgage finance space as opportunities arise.
Two Harbors Investment Corp. is proud to be an Equal Opportunity/Affirmative Action Employer. We are committed to equal employment opportunity to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.