Lead Data Modeler

4 weeks ago

Gurugram, India SIERA IT SERVICES PRIVATE LIMITED Full time

Position Overview : Analytics Data modeler

Mandatory Skills : Very Strong Informatica , SQL Server and Alteryx .

Good to have : Python, Exasol, MongoDB, Redis .

Roles and Responsibilities :

1. Data Modeling & Design :

- Lead and manage the design and development of data models for analytics and business intelligence solutions.

- Create logical and physical data models for large-scale data warehousing projects, ensuring scalability, efficiency, and alignment with business requirements.

- Develop dimensional models (star schema, snowflake schema) and implement best practices in data architecture, ensuring high-quality and easily maintainable data structures.

- Collaborate with stakeholders to understand business requirements and translate them into effective data models.

2. Data Integration & ETL Processes :

- Lead the development and optimization of ETL processes using Informatica, ensuring efficient data extraction, transformation, and loading into the target systems.

- Work with SQL Server and other databases to build and manage data pipelines that support high-volume, real-time data processing.

- Utilize Alteryx to automate workflows, perform data transformations, and enhance data quality.

- Identify opportunities to improve data integration processes, optimize performance, and reduce ETL processing times.

3. Database and Cloud Management :

- Oversee database management and optimization for the analytics platform, ensuring high performance, availability, and scalability.

- Work with modern database technologies such as SQL Server, Exasol, MongoDB, and Redis to design and implement efficient data storage and retrieval solutions.

- Ensure that data is correctly indexed, partitioned, and optimized to meet the needs of analytical queries.

4. Analytics & Reporting :

- Develop analytics models that support business intelligence and reporting systems, enabling stakeholders to gain insights from data.

- Implement data governance processes to ensure data quality, consistency, and integrity across reporting and analytical tools.

- Collaborate with data scientists, analysts, and business users to understand requirements and deliver actionable insights.

5. Technical Leadership & Mentorship :

- Lead a team of data modelers and developers, providing technical guidance, support, and mentorship to junior team members.

- Act as the primary point of contact for technical decisions and solutions related to data modeling and analytics architecture.

- Foster a collaborative environment, ensuring the team is motivated, focused, and aligned with project goals.

6. Client Interaction & Requirement Gathering :

- Engage directly with clients to understand business requirements, pain points, and deliverables, ensuring that solutions meet expectations.

- Conduct workshops, meetings, and presentations to discuss data modeling strategies, system design, and progress updates with clients.

- Present complex technical concepts in a clear and concise manner to both technical and non-technical stakeholders.

7. Performance Optimization :

- Continuously monitor and optimize the performance of data models, ETL processes, and database queries to ensure high-speed data access and reporting.

- Conduct performance tuning of SQL queries, data loads, and transformation processes to reduce latency and improve efficiency.

- Identify bottlenecks in the system and work with the team to implement effective solutions.

8. Documentation & Best Practices :

- Maintain comprehensive documentation for data models, ETL workflows, and system configurations.

- Establish and enforce best practices for data modeling, ETL development, and analytics processes, ensuring consistency and quality across projects.

- Create and update standard operating procedures (SOPs) for various stages of the data modeling lifecycle.

9. Research & Continuous Learning :

- Stay updated with the latest trends, tools, and technologies in data modeling, analytics, and cloud solutions.

- Proactively explore new technologies such as Python, Exasol, MongoDB, and Redis to enhance the data modeling and analytics capabilities.

- Promote continuous learning within the team, ensuring they are equipped with the skills and knowledge to tackle evolving business challenges.

10. Cross-functional Collaboration :

- Collaborate with teams across the organization, including data engineering, application development, business intelligence, and data science, to ensure seamless data flows and integration.

- Work with cloud infrastructure teams to implement scalable and efficient data storage and processing solutions in cloud environment

(ref:hirist.tech)

  • Data Modeler

    2 months ago

    Gurugram, India Fractal Full time

    Role: Data ModelerLocation: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / CoimbatoreKey Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWHExperience Range: 6-13 yearsWe are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc.Key...

  • Data Modeler

    2 months ago

    Gurugram, India Fractal Full time

    Role: Data Modeler Location: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / Coimbatore Key Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWH Experience Range: 6-13 years We are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc. Key...

  • Data Modeler

    2 months ago

    Gurugram, India Fractal Full time

    Role: Data ModelerLocation: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / CoimbatoreKey Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWHExperience Range: 6-13 yearsWe are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc.Key...

  • Data Modeler

    1 week ago

    Gurugram, India Straive Full time

    About Straive: Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains. Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the company’s long-term vision. The company is a specialized solutions...

  • Data Modeler

    10 hours ago

    Gurugram, India Straive Full time

    About Straive:Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains.Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the company’s long-term vision. The company is a specialized solutions...

  • Data Modeler

    13 hours ago

    Gurugram, India Straive Full time

    About Straive:Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains.Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the company’s long-term vision. The company is a specialized solutions...

  • Data Modeller

    7 months ago

    Gurugram, Haryana, India Coforge Ltd. Full time

    **Title - Data Modeler** **Duration: Full Time** **Location: Gurugram/Gurgaon (WFO)** - Responsibilities - Data analysis to understand the data and relationship in source systems - Updating and optimizing local and metadata models - Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data...

  • Fractal | Data Modeler | gurugram

    2 months ago

    gurugram, India Fractal Full time

    Role: Data ModelerLocation: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / CoimbatoreKey Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWHExperience Range: 6-13 yearsWe are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc.Key...

  • Fractal | Data Modeler | gurugram

    2 months ago

    gurugram, India Fractal Full time

    Role: Data Modeler Location: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / Coimbatore Key Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWH Experience Range: 6-13 years We are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc. Key...

  • Data Modeler

    7 months ago

    Gurugram, Haryana, India CALLISTOFUSION Full time

    Hi, We have a 6-month contract (with the possibility of extension) for the **Data Modeler** for location **Gurugram Haryana (On-site)**. Please find below the job description for the same: **Job Title: Data Modeler** **Location: Gurugram Haryana (On-site)** **Duration: 6-month contract (with the possibility of extension)** **Annual Salary Expectation:...

  • Data Modeler

    7 months ago

    Gurugram, Haryana, India S&P Global Full time

    **About the Role**: **Grade Level (for internal use)**: 10 **Location**: Gurgaon, India **What You’ll Do**: We are seeking a talented and experienced Data Modeler to join our Data Management team and play a critical role in shaping our data infrastructure and strategy. As a Data Modeler, you will be responsible for designing, building, and maintaining our...

  • Straive | Data Modeler

    15 hours ago

    gurugram, India Straive Full time

    About Straive:Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains.Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the company’s long-term vision. The company is a specialized solutions...

  • Straive | Data Modeler

    5 days ago

    gurugram, India Straive Full time

    About Straive: Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains. Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the company’s long-term vision. The company is a specialized solutions...

  • Data Modeler

    3 months ago

    Gurugram, India BLJ Tech Geeks Full time

    Job Title : Data Modeler Job Summary :We are seeking an experienced Data Modeler to join our dynamic team. The ideal candidate will be responsible for developing and maintaining robust data models that meet our business requirements and enhance our data infrastructure. You will work closely with stakeholders to ensure that data models are scalable,...

  • Associate, Data Modeling

    7 months ago

    Gurugram, Haryana, India BlackRock Full time

    Description About this role As a data modeler, you will be working closely with SME’s. data architects, data analysts and data/software engineers to design/implement data modeling solutions for domains with respect to financial services. To ensure success as a data modeler, you should have in-depth knowledge of data warehousing, as well as expert...

  • Data Modeler

    3 months ago

    Gurugram, India Acme Services Full time

    Job Description :- Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms.- Implement business and IT data requirements through new data strategies and designs across all data platforms (relational & dimensional - MUST...

  • Data Modelling Expert

    1 week ago

    Bangalore/Gurgaon/Gurugram, India BLJ Tech Geeks Full time

    Data ModellerWe are seeking an experienced Data Modeller to join our dynamic team at BLJ Tech Geeks. The ideal candidate will be responsible for developing and maintaining robust data models that meet our business requirements and enhance our data infrastructure.You will work closely with stakeholders to ensure that data models are scalable, efficient, and...

  • StatusNeo Technology

    2 months ago

    Gurugram, India Status Neo Full time

    About the job :Company Description :StatusNeo is a global consulting firm based in Bhopal that specializes in cutting-edge AI, automation, and cloud-first digital solutions. As product & platform engineering experts, we focus on delivering exceptional user experience, design, and functionality. Our team, comprised of top software engineers and product...

  • Data Engineer

    1 month ago

    Gurgaon/Gurugram, India Unifocus Full time

    Unifocus (formerly Knowcross) is an integrated workforce management software platform offering intelligent automation for daily work orders management, housekeeping activities, facility maintenance, survey solutions, scheduling & labour management, and time & attendance built for the hospitality market and other dynamic scheduling environment.We support...

  • Lead Data Scientist

    3 months ago

    Gurugram, India Aditya Consulting Full time

    Key Responsibilities : 1. Data Modeling & Algorithm Development : - Lead the design and implementation of advanced data models and algorithms to address consumer problems, enhancing product functionality and user experience.- Collaborate with cross-functional teams to integrate machine learning models into production environments.2. Domain Expertise : -...