Data Model Architect

The Data Model Architect assists with the design and implementation of company databases. As a data modeler architect, you will be working closely with platform architects, product owners and data analysts to implement data modeling solutions that streamline and support enterprise information management. To ensure success as a data model architect, you should have in-depth knowledge of data warehousing, as well as expert communication skills. Ultimately, a top-notch data model architect should be able to design models that reduce data redundancy, streamline data movements, and improve enterprise information management.

Responsibilities

Analyzing and translating business needs into supporting, conceptual data models; Working with development teams to create physical data models and implementation road maps; Developing best practices for data model development to ensure consistency; Ensuring data models adhere to data classification and governance objectives; Reviewing data models in data systems for variances, efficiency, and interoperability; Evangelizing data models and aligning their use to support a variety of business needs; Troubleshooting and optimizing data models

Requirements

Five (5) years of hands-on experience with relational and dimensional data modeling; Expert knowledge of metadata management and related tools; Strong interpersonal skills; Excellent communication and presentation skills; Advanced troubleshooting skills; Detail oriented, capable of envisioning edge-cases that are likely to happen in the real data sets; Aware of software engineering / DevOps best practices (Source control and branching patterns, automated testing, automated deployments); Understanding of modern CI / CD practices and principles; Strong understanding of DataOps principles; Microsoft Office (Outlook, Word, Excel, PowerPoint, Project, Visio, etc.) and Web proficiency; Ability to travel 10% of the time; Ability to clear required background check

Nice to have

CBIP Certification; Bachelor’s Degree in information systems, computer science, engineering or other relevant discipline; Familiarity with Dbt, Snowflake, Alation, Power BI; Experience in Jenkins development; Ideally capable of writing data transformations in code

Benefits

health benefits; retirement contributions; paid time off; bonus