Data Engineer

CrossCountry Mortgage (CCM) is the nation's number one distributed retail mortgage lender with more than 9,000 employees operating over 700 branches and servicing loans across all 50 states, D.C. and Puerto Rico. Our company has been recognized ten times on the Inc. 5000 list of America's fastest-growing private businesses and has received many awards for our standout culture.

A culture where you can grow! CCM has created an exceptional culture driving employee engagement, exceeding employee expectations, and directly impacting company success. At our core, our entrepreneurial spirit empowers every employee to be who they are to help us move forward together. You’ll get unwavering support from all departments and total transparency from the top down.

CCM offers eligible employees a competitive compensation plan and a robust benefits package, including medical, dental, vision, as well as a 401K. We also offer company-provided short-term disability, an employee assistance program, and a wellness program.

Position Overview:
The Data Engineer will support RoundPoint Mortgage Servicing LLC. 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.

Job Responsibilities:

• Full lifecycle delivery; development, testing and deployment of data solutions ensuring seamless delivery of business-critical analytics and reporting data.

• Demonstrates high intuition and problem-solving skills to navigate ambiguous requirements, independently solving complex data flow challenges with minimal oversight.

• Proactively monitor, diagnose and troubleshoot data ingestion failures and performance bottlenecks across enterprise pipelines to maintain high data availability and integrity.

• Work closely with the Data Architect and Tech Lead to translate requirements into scalable and maintainable data solutions.

• Partner with Business Analysts to clarify functional requests, ensuring a complete and unambiguous understanding of the underlying business intent.

• Collaborate seamlessly with Reporting Developers and analytics teams to ensure data models, tables, and views are structured logically, performant and optimized for downstream consumption.

Qualifications and Skills:

• 5+ years proven experience in

• • Deep understanding of relational database design principles, normalization, index strategies and schema optimization to ensure performant data structures.

• • Design, build and maintain enterprise ETL/ELT processes using SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) to orchestrate cloud and on-premises data movement.

• • Advanced SQL mastery to write, optimize and tune SQL queries, stored procedures and database objects within relational databases.

• • Hands-on data engineering experience, focusing on data ingestion, pipeline development and analytical workflows.

• 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 comfortable with a Microsoft SQL business intelligence environment.

• Familiarity with financial and/or mortgage servicing data, preferred.

• Experience in Active Batch scheduling software, preferred.

This job description is intended to convey information essential to understanding the scope of the job and the general nature and level of work performed by job holders within this job. However, this job description is not intended to be an exhaustive list of qualifications, skills, efforts, duties, responsibilities or working conditions associated with the position.