Apply for this Job
- The Data Modeler/Architect is primarily responsible for the design, implementation and maintenance of data models to support the needs of data warehouses and data marts. The position is responsible for recommending and adopting best practices to ensure high data quality standards, repeatability and scalability of data models are designed and maintained and data redundancy is reduced.
- Understand and translate business needs into data models to satisfy enterprise analytics & reporting needs.
- Work with the team to design and implement data strategies, build data flows and develop conceptual, logical and physical data models.
- Create and maintain conceptual, logical, and physical data models, along with corresponding metadata, according to enterprise standards using the Erwin tool.
- Dimensional Modeling Design: Design and develop efficient dimensional models (star schema, snowflake schema) for large-scale data warehouses, ensuring that data structures support analytical and reporting requirements.
- Fact and Dimension Table Design: Design and maintain fact tables, dimension tables, and their relationships, ensuring the correct granularity and historical data management for accurate reporting and analytics.
- Strong Data Analysis, SQL Querying, Data Profiling & Healthcare Domain Knowledge: Leverage advanced data analysis techniques, SQL querying, and data profiling to identify trends, patterns, and data anomalies. Strong knowledge of the healthcare domain is preferred to understand the specific data requirements, workflows, and standards in healthcare system.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Recommend opportunities for reuse of data models in new environments.
- Perform reverse engineering of physical data models from databases and SQL scripts.
- Evaluate data models and physical databases for variances and discrepancies.
- Validate business data objects for accuracy and completeness.
- Analyze data-related system integration challenges and propose appropriate solutions.
Date Posted: 24 April 2025
Apply for this Job