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.

• →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.

• 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.