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.
CrossCountry Mortgage, LLC offers
MORE than a job, we offer a career. Apply now to begin your path to success! careersatccm.com
CrossCountry Mortgage, LLC strives to provide employees with a robust benefit package: https://mycrosscountrybenefits.com