Enterprise Data Modeler
MIS
Dallas, TX
September 23, 2024
Enterprise Data Modeler
Dallas TX
What does it mean to be a BrinkerHead? We play like a team, take pride in our culture and seek every opportunity to make people feel special. Life is short. Work happy.
At Brinker, we connect, serve and give to create the best life for our Team Members, Guests and community. Through our cultural beliefs, Brinker empowers its Team Members to positively impact our 4 Key Results: Engaging Team Members, Bringing Back Guests, Growing Sales and Increasing Profits.
Brinker International is an equal opportunity employer; we foster an inclusion environment that promotes respect, diversity of thought and success for all.
Job Summary
The position is responsible for designing data models for all assigned projects with an emphasis on enterprise data modeling standards.
Your Key Job Functions
- Create industry standard data models using the Erwin Data Modeling solution.
- Enhance and create enterprise data structures and a data dictionary.
- Manage Meta Data and Meta Data Definitions for new and existing data models.
- Maintain and enhance existing data modeling standards such as naming conventions and data modeling standards.
- This includes but is not limited to generating Source-To-Target Mappings, executing Data Profiling on Source and Target Systems in preparation for ETL solutions.
· Incorporate new data requests into project and enterprise data models.
· Create and manage conceptual, logical, and physical data models using best practices for generation, creation, and naming standards.
· Work with the business and technical teams to fully understand the business requirements and be able to translate them into data structures and account for changing business needs.
· Compare data objects for impact analysis and structure changes.
· Analyze and profile source data to find underlying data/domain relationships and gaps.
· Reverse and forward engineering of data models.
· Create Meta Data and a Data Dictionary for each project data model.
· Assisting with data extraction, transformation, and loading.
· Create Source-To-Target Mappings with Meta Data Definitions.
· Ensure and track model deployments across all the environments.
· Provide walkthroughs & publish changes to all technology teams before every release rollout.
· Lead the exploration and adoption of new data modeling tools and technologies.
· Employ code repositories for version control and documentation, adhering to standard methodologies in data management.
· Advocate for standard processes in managing large datasets, applying star schema and other techniques to maintain data integrity and performance.
· Design dimensional/star schema and normalized data models from scratch.
· Apply your expertise to optimize data models, ensuring efficient storage, retrieval, and processing of data.
· Conduct data profiling, data quality assessments, and data lineage analysis to identify data inconsistencies, anomalies, and opportunities for improvement.
·