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 strategyJob Location: CHENNAI~MUMBAI~GANDHINAGAR
