Data Modeler

Data ModelerIt's a word that holds a special place at Bright MLS. At its core, it's shelter. But it's also so much more. Family. Community. Safety. A place where you can be your fullest, truest self. That's the word that inspires all of us at Bright to do the work that we do -- Ensuring an open, clear, and competitive housing market for ALL.Our company –and our brand –are reflective of the diverse communities that make up our market. Our employees represent a diverse mix of backgrounds, cultures and experiences, so much so that Bright's been named as one of the most diverse employers in the area by the Washington Business Journal –2 years in a row.Bright MLS is the engine that powers the real estate market in the Mid-Atlantic U.S. - supporting over $100B in transactions yearly. It is the single source for all data on Mid-Atlantic residential real estate - anywhere. As a Multiple Listing Service (MLS), our technology solutions connect real estate professionals with other real estate professionals and their clients, providing an open and accessible marketplace for buying and selling real estate.We're redefining what it means to be an MLS, and we'd love to have YOU here with us helping tell a Brighter story to the world. To learn more, please visit 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.Essential Job Functions: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.Required 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 skillsAbility 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.Preferred Qualifications: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.The salary range for this position is approximately $100,000 to $125,000, based on experience, skills, and qualifications. This position is also eligible for annual performance-based bonuses. Our comprehensive benefits package includes individual and family health, vision, and dental coverage, 401(k) plan with employer-matching, and Paid Time Off (PTO) and holidays.It is the company's policy to recruit, hire, train and promote individuals, as well as to administer any and all personnel actions, without regard to race, color, religion, age, sex (including gender identity, sexual orientation, and pregnancy), marital status, national origin, disability, genetic information, ancestry, military status or any other unlawfully prohibited characteristic in accordance with applicable laws.