Principal Data Modeler w/ Snowflake Job at Anblicks, Dallas, TX

dVUrblM4R2VQalpveTZWMnYzVTRMckFhbkE9PQ==
  • Anblicks
  • Dallas, TX

Job Description

MUST HAVE minimum of 14 years of direct experience in the data field .

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.

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. 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.

Job Tags

Work experience placement,

Similar Jobs

American Red Cross

Histocompatibility Lab Director Job at American Red Cross

By joining the American Red Cross you will touch millions of lives every year and experience the greatness of the human spirit at its best. Are you ready to be part of the world's largest humanitarian network? Join usWhere your Career is a Force for Good! Job ...

WSP Group

Senior Construction Project Manager Job at WSP Group

 ...This Opportunity WSP is currently initiating a search for a Senior Construction Project Manager for our New York, New York office. Be involved in projects with our PMCM Team and be a part of a growing organization that meets our clients objectives and solves their... 

Mount Prospect Academy

Bilingual Mental Health Clinician Job at Mount Prospect Academy

 ...Do you have a passion for working with youth and families? Are you bilingual in Spanish? If so, we have position for you! Job Description Our Community Based Services are intended to provide short term support and stabilization. As such, services provided by the... 

Sanford Health

RN Clinical Care Leader - Dickinson Job at Sanford Health

Careers With Purpose Sanford Health is one of the largest and fastest-growing not-for-profit health systems in the United States. We're proud to offer many development and advancement opportunities to our nearly 50,000 members of the Sanford Family who are dedicated...

5 Star Recruitment

Radiation Therapist Job at 5 Star Recruitment

 ...Job Summary Administers prescribed dose of ionizing radiation according to physicians written prescription and established departmental policy and procedures. Performs adjuvant procedures which aid in the management of patient care. Required Qualifications:...