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

Data Modeller

Job Description