Lead - Data Modeler and Data Analyst

LOCATION: Mumbai / Gurgaon

REPORTS TO: Director, Enterprise Information Management & Analytics

The data modeler plays a crucial role in designing, developing, and maintaining data models to support efficient data management and analytics within the organization. The data modeler is responsible for developing conceptual, logical, and physical data models.

As a data analyst this role interprets and analyzes complex datasets to provide insights and support data-driven decision making within an organization.

Core Responsibilities:

• Understand business requirements and translate them into data requirements.
• Analyze existing data structures and determine gaps, if any, to meet new requirements across all ongoing initiatives.
• Actively participate in all ongoing initiatives related to the data and analytics ecosystem, including capital projects, operational projects, and proof of concept work.
• Profile source data by retrieving and gathering raw data from various internal and external source systems, to identify trends, patterns, and quality issues.
• Design, optimize, and maintain conceptual, logical, and physical data models to support efficient data management and analytics within the organization.
• Collaborate with data architect, data engineers, report developers, AI/ML engineers, and business stakeholders/executives.
• Map out data personas and consumer profiles to ensure a better understanding of customer needs.

Data modeler:

• Design, create, and implement logical and physical data models for both IT and business solutions to capture the structure, relationships, and constraints of relevant datasets.
• Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions.
• Effectively collaborate and communicate with various stakeholders to understand data and business requirements and translate them into data models.
• Create entity-relationship diagrams (ERDs), data flow diagrams, and other visualization tools to represent data models.
• Collaborate with database administrators and software engineers to implement and maintain data models in databases, data warehouses, and data lakes.
• Develop data modeling best practices and use these standards to identify and resolve data modeling issues and conflicts.
• Conduct performance tuning and optimization of data models for efficient data access and retrieval
• Incorporate core data management competencies, including data governance, data security and data quality.

Data Analyst:

• Interprets results using a variety of techniques, ranging from simple data aggregation to more complex statistical analysis.
• Completes the gathering and cleaning processes for data from various sources, ensuring data integrity and quality.
• Uses statistical methods and techniques to identify patterns, trends, correlations, and anomalies, and extract meaningful insights.
• Develops and maintains dashboards, reports, and visualizations to communicate data findings effectively.
• Identifies KPIs and develops metrics to track and measure business performance.
• Collaborates with data engineers and IT professionals to optimize data collection, storage, and retrieval processes.
• Monitors data quality to identify data issues and propose data cleansing or enhancement solutions.
• Stays updated with industry trends and best practices in data analysis, visualization, and reporting.

Requirements:

• Bachelor’s degree in computer science, mathematics, or related field.
• 7+ years of experience in data gathering, profiling, data modeling and data analysis.
• Expert knowledge of data modeling concepts, methodologies, and best practices
• Proficiency in data modeling tools
• Familiarity with dimensional modeling and data warehousing concepts
• Expert level of proficiency in designing SQL queries and Python scripts.
• Hands-on relational, dimensional, and analytical project experience using RDBMS, NoSQL data platform technologies, and ETL.
• Robust experience with databases like SAP, Oracle, SQL Server, etc. and Big Data/Cloud platforms like Microsoft Azure, Google Big Query, Databricks, AWS, Cloudera, etc.
• Experience with unstructured, semi-structured, and structured data
• Experience with Business Intelligence/Data visualization and Reporting tools such as Power BI
• Expert knowledge of statistical analysis techniques and concepts for both descriptive and inferential statistics
• Knowledge of data visualization best practices to effectively communicate insights.
• Proficient with desktop tools (PowerPoint, Word, Excel, etc.)
• Ability to work independently and as part of a team to successfully execute projects.
• · Ability to multitask and meet aggressive deadlines efficiently and effectively.
• Excellent communication, presentation, and interpersonal skills.
• Certification in Data modeling or related fields is a plus.

Relocation Available: