Data Modeller

Job Description

Job Description: Interacting with Business Users/ Business Relationship Managers to understand the BI and analytical needs Identify the right data sources / data completeness to meet the BI needs Data profiling to build the entity relationships across multiple sources Develop and maintain data dictionary for all the data sources (existing and new ones) Build conceptual and logical data models considering the BI needs Develop optimized database design to achieve acceptable performance by tuning views, tables for proper response time Work with database administrators to implement data models into database platforms, ensuring data integrity and consistency Monitor database performance, identify bottlenecks, and optimize data models to improve query efficiency and data access speed Work closely with the IT teams in ETL design discussions adopting best practices of data load strategy Identify effective reporting techniques, identify the best data sources for each report, identify risks and constraints, and design reporting formats Create and maintain metadata describing the data model, including data lineage and definitions Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners Define data storage strategy