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 works with the Data Platform team to design, build, and maintain data infrastructure across a diverse set of database technologies including MongoDB, SQL Server, PostgreSQL, MySQL, and Snowflake. This role collaborates with software engineers, data analysts, and architects to ensure our data systems are reliable, secure, and optimized for performance. The Data Engineer is responsible for developing and supporting scalable data solutions.

Job Responsibilities:

• Design, maintain, and manage databases.
• Monitor system health, performance, and availability; identify and escalate issues in a timely manner.
• Support high levels of performance, availability, sustainability, and security across data infrastructure.
• Analyze and resolve database performance issues through query optimization, indexing, and schema improvements.
• Implement appropriate indexes (B-Tree, Geospatial, Text) to improve query performance.
• Assist in designing and maintaining data models and schemas for relational and document-oriented databases.
• Refine and automate recurring operational processes; track issues and maintain documentation.
• Work alongside software developers on query tuning, schema refinement, and REST API data integration.
• Support the planning and implementation of backup, restore, and recovery procedures.
• Contribute to building and maintaining ETL/ELT pipelines using PySpark, AWS Glue, Lambda, and Step Functions.
• Assist in the monitoring of MongoDB Atlas environments including configuration.
• Follow and help enforce best practices for REST API integration frameworks and data access patterns.
• Support database security standards including access control, encryption, and auditing.

Qualifications and Skills:

• Bachelor's or Master's degree in Software Engineering, Information Technology, Computer Science, or a related field.
• 3+ years of experience in data modelling, schema design, database architecture.
• 3+ years of experience with performance tuning and optimization across relational and NoSQL databases.
• 3+ years of experience managing backups, restores, and recovery models.
• Experience with C# or other object-oriented programming languages.
• Experience with PySpark, AWS Glue, AWS Lambda, and AWS Step Functions.
• Experience working with AWS services, including EC2, S3, RDS, Glue, and Lambda, preferred.
• Experience working with Azure or GCP cloud platforms, preferred.
• Experience with Windows Server, including Active Directory, preferred.
• Experience with automation of database operations, deployments, or related processes, preferred.
• Experience in MongoDB performance troubleshooting and tuning, preferred.
• Commitment to continuous learning and professional development.
• Understanding of MongoDB architecture, replication, and Atlas operations.
• Familiarity with database security management including roles, permissions, and auditing.
• Familiarity with Snowflake concepts including warehousing and basic performance tuning.
• Familiarity with version control tools such as Git/GitHub.
• Familiarity with High Availability (HA) and Disaster Recovery (DR) concepts for SQL Server, preferred.
• Proficiency in SQL query writing across multiple database engines.
• Skilled in taking initiative and managing responsibilities effectively in a dynamic team environment.
• Excellent analytical and problem-solving skills.
• Excellent communication skills.

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.