Senior Data Engineer: Data Warehousing & Pipelines

RoundPoint Mortgage Servicing LLC; Fort Mill (SC); Vor Ort; USD 100.000 - 140.000; Vollzeit

Zusammenfassung

RoundPoint Mortgage Servicing LLC is seeking a Data Engineer to develop data solutions and deliver enterprise data warehouse capabilities. The role involves building data pipelines, optimizing SQL performance, and automating data processes while coordinating with analysts, product managers, QA, and stakeholders.

Strong SQL, data modeling, and data governance skills are essential. Preferred experience includes Azure Data Factory, ActiveBatch, and Snowflake.

Qualifikationen

• 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 with relational databases.
• Hands-on experience with data warehouse solutions.
• Proficiency with SQL, preferably Microsoft T-SQL.
• Strong understanding of data modeling and data governance.
• Excellent problem-solving skills and ability to work independently or with a team.
• Experience reflecting development lifecycle across projects longer than two years.

Aufgaben

• Develop and deliver data solutions that comply with development standards.
• Maintain relational database schema with tables, relationships and constraints.
• Build automated ETL processes to centralize data in a data warehouse.
• Optimize complex SQL queries, indexing strategies and execution plans for large datasets.
• Collaborate with developers to meet deliverables within project schedules.
• Support business and tech teams to ensure scalable data solutions.
• Maintain data and database systems to meet delivery specifications.
• Communicate effectively across teams.

Kenntnisse

Complex SQL

SQL optimization

Relational databases

Data modeling

Data governance

Team collaboration

Self-starter

Tools

SSIS

Azure Data Factory

ActiveBatch

Snowflake

Jobbeschreibung

RoundPoint Mortgage Servicing LLC is seeking a Data Engineer to develop data solutions and deliver enterprise data warehouse capabilities. The role involves building data pipelines, optimizing SQL performance, and automating data processes while coordinating with analysts, product managers, QA, and stakeholders.

Strong SQL, data modeling, and data governance skills are essential. Preferred experience includes Azure Data Factory, ActiveBatch, and Snowflake.