Data Engineer: Build Scalable Pipelines & Data Warehouse

TWO; Fort Mill (SC); Hybrid; USD 110.000 - 160.000; Vollzeit

Zusammenfassung

RoundPoint Mortgage Servicing LLC in Fort Mill, SC is seeking a Data Engineer to build and maintain data pipelines, optimize the data warehouse, and automate data processes in collaboration with analysts, product managers, QA and stakeholders.

You will develop scalable data solutions, tune SQL queries, and ensure data integrity across the enterprise, leveraging MS SQL/BI environments and modern cloud data tooling.

Qualifikationen

• 5+ years in a data-centric role within a data/tech team.
• Writing and optimizing complex SQL queries to extract large datasets.
• Experience with data warehouse solutions and Microsoft SQL BI environments.
• Strong understanding of data modeling and governance best practices.
• Hands-on experience with data transformation tools like SSIS.

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 load data from sources into a centralized data warehouse.
• Optimize complex SQL queries, indexing strategies and execution plans.
• Collaborate with developers to meet deliverables and project schedules.
• Provide support to business and technology teams for scalable data solutions.
• Maintain data and database systems to meet business needs.
• Communicate effectively with stakeholders to enable cross-functional collaboration.

Kenntnisse

Data modeling

SQL proficiency

Team collaboration

Problem solving

BI environment experience

Tools

SSIS

Azure Data Factory

Snowflake

ActiveBatch

Jobbeschreibung

RoundPoint Mortgage Servicing LLC in Fort Mill, SC is seeking a Data Engineer to build and maintain data pipelines, optimize the data warehouse, and automate data processes in collaboration with analysts, product managers, QA and stakeholders.

You will develop scalable data solutions, tune SQL queries, and ensure data integrity across the enterprise, leveraging MS SQL/BI environments and modern cloud data tooling.