Data Administrator

WHO WE ARE

We are Xome, a real estate services company headquartered in the Dallas, Texas area. As a subsidiary of Mr. Cooper Group, we employ over 1,200 team members nationwide. The nation’s largest financial services companies look to us for integrated and scalable business solutions that help simplify the mortgage and real estate process.

At the heart of everything we do is our purpose: To keep the dream of home ownership alive. If that sounds like a big, lofty goal, that’s because it really is. And we can’t do it alone. Our entire team is focused on helping create a stable and healthy housing industry. And, making sure the process of buying/selling a home doesn’t undermine the excitement of home ownership. That’s why we battle every day against the mediocrity of the status quo to simplify the complex world of mortgage servicing, lending and banking. We see ourselves as the experts who make doing business easier. While others bring complexity and a lack of transparency, we offer simplicity, trust, and visibility across the entire property lifecycle. And we deliver radical customer service.

Now, you might be wondering; how exactly do you pronounce Xome? Simple. ZOM (like home, if it started with a z)!

Conceptual Data Modeling: 

• Meet with business areas to determine the subject areas of data where data originates versus is consumed.
• Collaborate with business areas to develop conceptual data models using business and industry taxonomy.
• Collaborate with information architecture to determine placement within the logical data architecture framework of Xome.
• Develop thorough metadata for the data entities and attributes of the conceptual data model.
• Mentor a business counterpart to liaise with regarding data administration issues.

Data Stewardship Program: 

• Collaborate across business areas to address and resolve issues associated with shared subject areas of data. 
• Introduce downstream consumers of data to the business area of data origination to emphasize the value of data completeness and data quality. 
• Share data completeness and data quality issues with the originators of data and help strategize remediation, and report back realistic expectations to stakeholders.
• Identify and recommend opportunities to capture data that may represent a competitive advantage if properly captured and curated with workflow automation technology.

Logical Data Modeling: 

• Leveraging conceptual data models, design and develop logical data models to support the complete modeling of each subject area of data. 
• Apply naming conventions, allowed terms, class words, and standard data types to the model for Azure SQL and for Databricks Data Lake ensuring alignment with enterprise standards in SAP PowerDesigner.
• Present conceptual and logical data models for team reviews with business stakeholders, information architecture, API architecture, database administration, and application development. 

Physical Data Modeling: 

• Leveraging the PowerDesigner CASE tool to forward engineer physical data models.
• Leveraging the PowerDesigner CASE tool to reverse engineer relational schemas to establish the metadata associated with the corresponding conceptual and logical data models.
• Apply physical design standards to physical data models.
• Generate DDL for database administration to support the activities required to create or modify a database design.

Stakeholder Engagement: 

• Work closely with data governance, compliance, and security to protect their various interests.
• Collaborate with downstream consumers of data to prioritize their data needs, especially with data science. 
• Collaborate with business to support enterprise data quality and data governance initiatives. 
• Collaborate with information architecture to further the development of the logical data architecture (LDA). 
• Collaborate with database administration to develop an accurate inventory of existing data in the physical data architecture (PDA). 
• Collaborate with API architecture to optimize the development of reusable APIs.
• Collaborate with data engineering to address the various types of issues that arise.

• Develop strong relationships with broader development teams, fostering trust and improving team efficiency and effectiveness. 

Minimum Qualifications  

• Excellent verbal and written communication skills.
• Strong desire to continually learn and make time for self-managed training.
• Strong ability to develop and conduct presentations to executives.
• Bachelor's Degree or foreign equivalent in Information Technology, Computer Science, Computer Information Systems, Engineering, or equivalent experience of 5 years in relevant fields. 
• Experience in data modeling and the rules of normalization for transactional databases.
• Experience in designing data warehouses, multi-dimensional databases, fact tables, and snowflake structures.
• Familiarity with a Medallion Architecture and the best practices associated with each layer.
• Hands on experience maintaining a comprehensive data dictionary.
• 10+ years of progressively responsible experience in data services, including: 
• Expertise in transactional and analytical data structures.
• Experience in Microsoft SQL (TSQL) based software products. 
• Familiarity with Microsoft Azure. 
• In-depth understanding of IT concepts, strategies, methodologies, and their practical application to business challenges. 
• Working knowledge of application design. 
• Experience with Microsoft SharePoint, Microsoft Teams, and Microsoft Office.

Preferred Qualifications 

• ​Master’s Degree in Information Technology, Computer Science, Computer Information Systems, Engineering, or a related field (foreign equivalent acceptable). Education can be substituted by equivalent experience of 6 years in relevant fields. 
• Certifications in Microsoft Azure.
• 10+ years of progressively responsible experience. 
• Experience in one or more data services departments of a Fortune 500. 
• Experience in the Mortgage, Real Estate, or Finance industry is highly regarded. 
• Proficiency with NoSQL databases. 
• Experience in data profiling.
• Familiarity with ETL technologies, data pipeline and workflow management tools such as ADF. 
• Familiarity with stream processing and Apache Spark and containerized distributed processing.
• Experience using Databricks. 
• Experience with Collibra Data Catalog and or Collibra Data Quality.
• Strong project management and organizational capabilities.

Xome is committed to nurturing a diverse and inclusive environment where every employee is empowered to be their authentic self. We know that a large part of our success as a business is directly tied to our ongoing efforts to attract and retain diverse talent and maintain an inclusive environment where each employee can thrive. Embracing and leveraging diversity through an inclusive work environment fosters new ideas, new insights, and constant innovation. We strive to weave the principles of diversity and inclusion throughout the fabric of how we work, how we interact, and how we engage with our customers and the community.

Job Requisition ID:

022919

Job Category:

Information Technology

Primary Location City:

Lewisville

Primary Location Region:

Texas

Primary Location Postal Code:

75067

Primary Location Country:

United States of America

Additional Posting Location(s):