Data Modeler - Horizontal Talent

Key Responsibilities:

• Review and analyze existing data models in MS SQL Server
• Design and develop new, improved data models for Snowflake platform
• Ensure data models meet business requirements and industry standards
• Collaborate with stakeholders to understand data needs and use cases
• Create and maintain data dictionaries and model documentation
• Optimize data models for performance and scalability
• Support the migration of data models from MS SQL Server to Snowflake
• Implement data governance and quality control measures
• Develop and implement solutions for data quality and consistency issues
• Collaborate with data engineers and analysts to ensure data integrity throughout the pipeline
• Design and implement data validation rules and constraints in the models
• Propose and implement data standardization practices across the organization

• Bachelor’s degree in computer science, Information Systems, or related field
• 7+ years of experience in data modeling, preferably in the financial sector
• Strong knowledge of MS SQL Server and Snowflake architectures
• Expertise in data warehousing concepts, and related modeling concepts
• Proficiency in SQL and data modeling tools
• Experience with ETL processes and data integration
• Experience in data profiling, cleansing, and quality management techniques

• Certifications in data modeling or Snowflake
• Experience with cloud based data platforms
• Familiarity with mortgage industry data structures and regulations

• Analytical thinking and problem solving
• Attention to detail
• Strong communication and collaboration abilities
• Problem solving skills related to data quality and consistency
• Familiarity with data quality tools and methodologies

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact us. All applicants applying must be legally authorized to work in the country of employment.