Principal Data Modeler

Anblicks; Dallas (TX); Hybrid; USD 120,000 - 160,000; Full time

Job summary

A leading company in data solutions is seeking a Principal Data Modeler to design and maintain complex data models. The role involves collaboration with data engineers and stakeholders, mentoring junior staff, and ensuring the integrity and performance of data systems. Candidates should have extensive experience with cloud technologies and data architecture. This position requires a hands-on approach and the ability to work creatively and autonomously.

Qualifications

• Minimum of 10 years experience in data field with a strong focus on data modeling.
• Proficient in Snowflake and extensive experience with cloud data platforms.
• Creative, autonomous problem-solving skills required.

Responsibilities

• Design and maintain complex OLTP and OLAP data models.
• Collaborate with stakeholders to understand their data needs and translate them into models.
• Mentor junior data modelers and oversee their professional development.

Skills

Snowflake Expertise

SQL Proficiency

Data Modeling Tools

Cloud Platforms

ETL / ELT Processes

Data Warehousing

Education

Bachelor's degree in computer science, Information Technology or related field

Master’s degree preferred

Tools

ERwin

ER / Studio

IBM Infosphere Data Architect

Job description

Direct Client : : Job Title : Principal Data Modeler Hybrid Irving, TX

Only GC or USC on W2 Fulltime

Location : : Irving, TX days for Hybrid Tue, Wed, Thursday onsite, remaining Friday, Monday Remote.

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.

The ideal candidate will possess a robust background in data engineering, showcasing expertise in cloud technologies, data architecture & modeling, data pipeline development. Essential qualifications include a bachelor's degree in technology and a minimum of 10 years of direct experience in the data field. The role demands a high level of creativity and autonomy, along with strong delegation skills, enabling the effective distribution of tasks and responsibilities based on individual strengths and expertise. A hands-on approach to problem-solving is highly valued.

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 Doman Knowledge. Ex : 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.