Data Modeler

Role Description

The Data Modeler will work with the Data Engineers, Data Architects, and Application Development teams to translate business needs into practical data models. They are responsible for designing and building highly complex data models and data architecture that improve accessibility, efficiency, governance, and data quality that directly impact business results.

• Understand and translate business needs into data models supporting long-term solutions.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Work with the Application Development team to implement data strategies, build data flows, and develop conceptual data models.
• Optimize and update logical and physical data models to support new and existing projects.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Create and maintain Conceptual, Logical, and Physical Data Models for our reporting layer and Data Marts.
• Define and communicate data standards, industry best practices, technologies, and architecture.
• Support development teams with application database design and mentoring.
• Contribute policies and guidelines for the governance of Data Management standards and best practices.
• Create complex SQL statements to profile data, optimize performance, and perform data analysis for database design input.
• Create DDL/DML to deploy database structures and perform data loads.

Qualifications

• 6+ years experience with at least 4 years designing data models for Enterprise Data Warehouses & Data Marts.
• Knowledge of relational databases, NoSQL, and data architecture.
• Database design experience across data warehousing and analytic data stores.
• Bachelor’s degree in computer science, data science, information technology, or data modeling.
• Experience with ER modeling, big data, enterprise data, and physical data models.
• Experience developing and maintaining Enterprise Canonical Models.
• Familiarity with data modeling software such as Microsoft Visio or Erwin Data Modeler.
• Excellent presentation, communication, and organizational skills.
• Ability to work in a fast-paced environment.
• Experience translating Conceptual models into Logical and Physical Data Warehouse models leveraging Canonical standards.
• Ability to work independently and collaboratively on large-scale data projects.
• Ability to lead sessions with stakeholders to determine data rules and review data models.
• Ability to coach and mentor members of the data engineering team.

Requirements

• Exposure to Business Intelligence tools such as PowerBI and Tableau.
• Exposure to messaging solutions such as Kafka.
• Software Development experience with Python or JavaScript.
• Experience in Enterprise Reference and Master Data Management strategies.
• Experience with AWS Cloud.

Benefits

• Salary range: approximately $100,000 to $125,000, based on experience, skills, and qualifications.
• Eligible for annual performance-based bonuses.
• Comprehensive benefits package includes individual and family health, vision, and dental coverage.
• 401(k) plan with employer-matching.
• Paid Time Off (PTO) and holidays.