Principal Data Modeler

At Mr. Cooper Group, You Make the Dream Possible.

Our purpose is simple: Keeping the dream of homeownership alive. As a Mr. Cooper Group team member, you play a big role in making that dream possible. Around here, we know our roles and work together, volunteer to make a difference, and challenge the status quo when needed. Everything we do is in the care and service of our teammates and our customers.

Join us and make the dream of home ownership possible!

Job Overview

The Principal Data Modeler will be responsible for designing, developing, and maintaining complex OLTP and OLAP data models across multiple platforms, including Snowflake, Big Query, SQL server, PostgreSQL. He/she will work closely with data engineers, analysts, and business stakeholders to ensure our data models meet the highest standards of performance, scalability, and reliability of data systems. Additionally, the principal will be responsible for mentoring junior modelers in both the US and India and will serve as their direct reporting manager as the team expands. This role typically reports to an AVP of Data Engineering & Architecture.

Responsibilities:

• Designing Data Models: Creating conceptual, logical, and physical data models to represent and structure the data of an organization.
• Database Management: Designing and maintaining databases to ensure they meet performance and security standards.
• Data Analysis: Analyzing data requirements and identifying data sources to integrate them into the data models.
• Collaboration: Working with business analysts, data architects, and other stakeholders to understand business needs and translate them into data models.
• Data Governance: Establishing and enforcing data modeling standards and best practices to ensure data integrity and consistency.
• Documentation: Creating and maintaining detailed documentation of data models, including data dictionaries and metadata.
• Optimization: Continuously refining and optimizing data models to improve performance and scalability.
• Mentoring: Providing guidance and mentoring to junior data modelers and other team members.
• Troubleshooting: Identifying and resolving data-related issues and discrepancies.
• Staying Updated: Keeping up with the latest trends and advancements in data modeling, architecture and database technologies.
• Implementation Support: Assisting in the implementation of data models within database management systems and ensuring their proper integration.
• Quality Assurance: Ensuring data models meet quality standards and align with organizational goals and requirements.

Qualifications (Education & Experience)

• Bachelor's degree in computer science, Information Technology, or related field (master’s degree preferred).
• 8+ years of experience in data modeling, database design, or data architecture, particularly with Snowflake or other cloud-based data warehousing solutions.
• Mortgage Domain Knowledge: Knowledge of mortgage products, services, lifecycle, regulatory requirements, compliance standards etc.

Technical Skills:

• Snowflake Expertise: Proficient in Snowflake architecture, features, and best practices.
• SQL Proficiency: Strong skills in SQL for creating and managing databases, writing complex queries, and optimizing performance.
• Data Modeling Tools: Experience with data modeling tools like ERwin, ER/Studio, IBM Infosphere Data Architect or similar software.
• Cloud Platforms: Strong work experience with cloud platforms (e.g., AWS, Azure, Google Cloud) and their data services.
• ETL/ELT Processes: Knowledge of ETL/ELT processes and tools like DataStage, Talend, SSIS or similar software.
• Data Warehousing: Deep understanding of data warehousing concepts and methodologies.

Preferred Qualifications:

• Certification in Snowflake (e.g., Snowflake SnowPro Core Certification).
• Certifications in related areas like AWS Certified Solutions Architect, Google Cloud Professional Data Engineer, or Microsoft Certified: Azure Data Engineer Associate.

Mr. Cooper Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or status as a protected veteran. EOE/M/F/D/V