Data Modeler, Consultant

Your Role

The Data and Analytics (D&A) organization focuses enterprise-wide to partner with business stakeholders to apply the power of data & analytics to deliver new insights and data-driven solutions to accelerate business outcomes. The Data Services & Solutions team is part of the centralized D&A organization and leads the design and implementation of data solutions and data products. The Data Modeler, Consultant will report to the Manager of Data Management. In this role, you will be responsible for designing, implementing, and maintaining Data Vault 2.0 and Dimensional models within the D&A organization. You will be providing strategic direction, mentoring junior team members, and leading and enforcing data modeling standards and best practices. Our leadership model is about developing great leaders at all levels and creating opportunities for our people to grow – personally, professionally, and financially. We are looking for leaders that are energized by creative and critical thinking, building, and sustaining high-performing teams, getting results the right way, and fostering continuous learning.

Your Work

In this role, you will:

• Demonstrate lead-level capabilities in conceptual analysis, problem-solving, and data analysis
• Take ownership of initiatives or projects with the ability to lead and facilitate business requirements and data analysis and modeling sessions
• Lead data model review sessions; Develop, adopt and mature the data modeling standards and guidelines aligning to industry best practices
• Collaborate with subject matter experts, business analysts, data analysts, and other data modelers to create data modeling deliverables
• Provide support in the use of enterprise data, including guidance in understanding and exploitation of the underlying data and business models, and identifying optimal data sourcing and mapping
• Assist in developing and publishing data management standards, policies, and procedures, including the management and maintenance of related tools and environments
• Create fully attributed and documented conceptual, logical and physical models
• Create, validate, and update the data dictionary by coordinating with data governance team and business users. Capture business rules for logical and physical mapping in the models; Work closely with the data governance team to define data classification, PHI/sensitive information, and enterprise reference data in Collibra and modeling tool
• Generate physical model DDL and SQL for views for data engineering implementation