Data Warehouse Engineer

RoundPoint Mortgage Servicing•Fort Mill, SC

About The Position

The Data Warehouse Engineer develops and delivers data solutions and maintains the enterprise data warehouse. Working with business analysts, product managers, quality assurance, and business stakeholders, the engineer builds and maintains data pipelines, optimizes database performance, and automates data processes. The role delivers data solutions through development, testing, and deployment, helping ensure business-critical analytics and reporting data are available, accurate, and usable. The engineer independently investigates complex data-flow challenges, monitors and troubleshoots ingestion failures and performance bottlenecks, and works with the Data Architect and Tech Lead to translate requirements into scalable solutions. The role also partners with business analysts to clarify business intent and with reporting developers and analytics teams to structure data models, tables, and views for performance and downstream use.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related technical field, or equivalent work experience.
  • At least 5 years of experience in data engineering, focused on data ingestion, pipeline development, and analytical workflows.
  • Experience designing, building, and maintaining enterprise ETL/ELT processes using SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) to orchestrate cloud and on-premises data movement.
  • Deep understanding of relational database design, including normalization, index strategies, and schema optimization.
  • Deep understanding of data modeling and data governance best practices.
  • Advanced SQL skills, including writing, optimizing, and tuning queries, stored procedures, and database objects in relational databases.
  • Excellent problem-solving and analytical skills, including the ability to resolve data-related issues independently and collaboratively.
  • Ability to work independently in a fast-paced environment with flexibility, initiative, and a results-oriented approach.
  • Proficiency with Microsoft SQL Server Business Intelligence (BI) tools and environments.

Nice To Haves

  • Familiarity with financial and/or mortgage servicing data.
  • Experience with Active Batch scheduling software.

Responsibilities

  • Deliver data solutions through the full lifecycle of development, testing, and deployment.
  • Build and maintain data pipelines and automate data processes.
  • Monitor, diagnose, and troubleshoot data ingestion failures and pipeline performance bottlenecks.
  • Maintain high data availability and integrity across enterprise pipelines.
  • Work with the Data Architect and Tech Lead to translate requirements into scalable, maintainable data solutions.
  • Partner with Business Analysts to clarify requests and understand underlying business intent.
  • Collaborate with Reporting Developers and analytics teams to structure performant data models, tables, and views for downstream consumption.
  • Optimize database environments and support business-critical analytics and reporting data.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service