Data Modeler

Job Title: Data Modeler

Location: Englewood, CO

Job Description:

Position Overview:

A Data Modeler plays a critical role in an organization's data management and analytics efforts

by consolidating various databases and data stores, eliminating redundancy, and optimizing

data structures for improved efficiency. This role requires a deep understanding of data

modeling, database design, and data integration principles. The Data Modeler collaborates

closely with data engineers, data scientists, and other stakeholders to ensure that the

organization's data assets are structured and organized for optimal performance and usability.

Key Responsibilities:

1. Data Consolidation: - Identify and analyze existing databases, data sources, and data stores within the

organization. - Develop strategies and plans for consolidating disparate data assets into a unified and

coherent structure. - Assess the quality and relevance of data from different sources and recommend data

consolidation techniques.

2. Data Modeling: - Design and create data models that represent the structure and relationships within the

organization's data. - Utilize industry-standard modeling techniques such as Entity-Relationship Diagrams (ERD)

and/or multidimensional modeling as necessary. - Ensure data models are consistent, maintainable, and scalable.

3. Redundancy Removal: - Identify and eliminate redundant data across different systems, databases, or data stores. - Implement data normalization and denormalization strategies where appropriate to

optimize data storage and retrieval.

4. Database Optimization: - Work with database administrators and developers to optimize the performance of database

systems. - Fine-tune data storage configurations, indexing, and query performance. - Identify and implement strategies for data archiving, partitioning, and purging to improve

efficiency.

5. Data Efficiency:

- Collaborate with data analysts and data scientists to understand their data requirements and

optimize data structures accordingly. - Implement data compression, caching, and indexing techniques to improve data access

times. - Continuously monitor data performance and make adjustments as needed.

6. Documentation: - Create and maintain detailed documentation of data models, schema designs, and data

integration processes. - Ensure that data-related documentation is kept up-to-date and accessible to relevant

stakeholders.

7. Data Governance: - Ensure that data modeling and consolidation efforts comply with data governance policies,

security standards, and regulatory requirements. - Collaborate with data governance teams to establish and enforce data standards.

Qualifications: - Bachelor's or Master's degree in Computer Science, Information Systems, or a related field. - Proven experience in data modeling, database design, and data consolidation. - Proficiency in data modeling tools such as ERwin, ER/Studio, or similar software. - Strong knowledge of database management systems (SQL and NoSQL). - Familiarity with data warehousing concepts and ETL processes. - Excellent problem-solving skills and attention to detail. - Strong communication and collaboration skills to work with cross-functional teams. - Knowledge of data governance and data security best practices is a plus.