Lead - Data Modeler and Data Analyst
Lead - Data Modeler and Data Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Location : Mumbai
Reports to : Director Enterprise Information Management & Analytics
Workplace type : Hybrid
Salary : 22 28 lpa
The data modeler plays a crucial role in designing developing and maintaining data models to support efficient data management and analytics within the organization. This role is essential in optimizing data architecture translating business initiatives into robust data models and enhancing data integrity availability and performance. 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 datadriven decision making within an organization. This role works alongside engineers modelers and business executives to gather and transform data conduct statistical analyses and create visualizations and reports that will contribute to identifying trends patterns and opportunities that drive business initiatives.
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.
Responsibilities 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 entityrelationship 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.
Responsibilities 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:
- Bachelors degree in related field.
- Hands on 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.
- Handson relational dimensional and analytical project experience using RDBMS SAP Oracle SQL Server) NoSQL (Cassandra Mongo) 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 semistructured 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.
Relocation Available:
NoRequired Experience:
IC
Employment Type
Full-Time
