Data Modeler

Bright MLS, Inc•North Bethesda, MD

2d•$100,000 - $125,000

About The Position

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.

Requirements

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 data engineering team.

Nice To Haves

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.

Responsibilities

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.