Lead Data Modeler Redshift

9 hours ago

Gurgaon, Haryana, India ADI Group Full time ₹ 12,00,000 - ₹ 36,00,000 per year


Role Description: Data Modeler

The ideal candidate is a hands-on SQL, familiar with DB fundamentals, should have good exposure using Erwin. They

must be at ease working in an agile environment with little supervision. The person should be a self-motivated

person with a passion for problem solving and continuous learning.

Designation: Lead Data Modeler (4A): 6 - 9 Years

Office Days - 3 days (Flexible) /

Office Days Hybrid, 3 days

Location Gurgaon, Pune , Bangalore, Chennai , Hyderabad

Role and responsibilities

  • Perform as Data design/modeling lead to support the system designing and construction in data layer and
  • application systems.
  • Understand the current database system with business operation demands and technical capability.
  • Develop data models and related designs, from the data architecture concept, logical, to physical data models for
  • application database.
  • Providing expertise in data modeling tools and techniques for designing data models for applications and related
  • systems.
  • Assure that the modeling complies with the data modeling standards (normalization, data validation)
  • Working closely with business stakeholders, as well as potential users of the information system to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
  • Ensure compliance with technical processes and standards.
  • Identify, communicate, and mitigate Risks, Assumptions, Issues, and Decisions throughout the full lifecycle.

Technical skills requirements

  • The candidate must demonstrate proficiency in,
  • Strong Data Modelling Skills in designing, creating and maintaining conceptual, logical, and physical data model.
  • Must have a strong understanding of Data modeling principles (3nf/dimensional), methods and techniques.
  • 8 years data modeling experience preferably in Pharma or life sciences industry, ERStudio or similar
  • experience. Experience with Data Governance tools, enterprise data management solutions, Modeling best
  • practices, and MDM.
  • Good knowledge on data profiling, integrating, and modeling data from different source systems.
  • Experience in translating/mapping relational data models into XML and Schemas
  • Should have hands-on experience in relational, dimensional, and analytic data modeling using RDBMS, dimensional, SQL, PL/SQL, NoSQL data platform technologies, and ETL and data ingestion protocols.
  • Should have strong knowledge in creating the data model for OLAP and OLTP systems.
  • Strong knowledge of Database Architecture, normalization concepts, and NFR requirements
  • Good Hands-on expertise in data modeling tools (e.g. Power Designer, Erwin, ER/Studio)
  • Hands-on expertise in creating Conceptual, Logical Data models and Physical data models Using ERWIN/ER
  • Studio.
  • Experience with data warehouse, Data Lake, and enterprise big data platforms.
  • Experience on RDBMS platforms (e.g. Redshift, SQL Server, Oracle, Teradata, Snowflake, Postgres)
  • Must have hands-on experience on implementing data models on AWS Redshift along with other AWS cloud solutions services including S3, Glacier, RDS, Athena, DynamoDB etc.
  • Experience working with extracting business rules to develop transformations, data lineage, metadata, and data catalogue.

Nice-to-have skills

  • Azure Cloud certification
  • Unix or Shell scripting
  • Strong delivery background across the delivery of high-value, business-facing technical projects in major organizations

Qualifications

B.Tech./M.Tech. or BCA/MCA degree from a reputed university


  • Senior/Lead Data Engineer

    1 week ago

    Gurgaon, Haryana, India Eucloid Data Solutions Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Role: Senior Lead Data EngineerAbout The Role:Eucloid is looking for a senior/ lead Data Engineer to join our Data Platform team supporting various business applications. The ideal candidate will support development of data infrastructure on Databricks for our clients by participating in activities which may include starting from up- stream and down-stream...

  • Tableau +Redshift Developer

    5 days ago

    Gurgaon, Haryana, India Talent Worx Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Talworx Is Hiring For Tableau +Redshift DeveloperExperience should be 6 to 9 Years Must have:· Experience gathering and analyzing data requirements· AWS and Tableau in-depth Knowledge with work exp .· Good knowledge of ERP ( SAP, Oracle) systems and how data is organized inside ERP systems· In depth knowledge of data querying· Good in Excel· Excellent...

  • AWS Redshift Database Administrator

    7 days ago

    Gurgaon, Haryana, India Movate Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    We are seeking a skilledAWS Redshift Database Administratorto manage and optimize Redshift clusters and other AWS services. This role requires close collaboration with cross-functional teams to ensure the reliability and performance of data infrastructure.Please note:This position is based inGurugram, and the selected candidate must eitherreside in the NCR...

  • Data Modeler

    2 weeks ago

    Gurgaon, Haryana, India Obrimo Technologies Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    We are seeking an accomplishedSenior Data Modeler / Associate Data Architectwith strong expertise in designing scalable enterprise data solutions. The ideal candidate will have hands-on experience building conceptual, logical, and physical data models, enabling enterprise-wide data governance, and leading cloud-based data modernization initiatives.You will...

  • Data Modeler

    2 hours ago

    Gurgaon, Haryana, India Vision Excel Career Solutions Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Job locations: Bangalore / Pune/ Greater Noida / Gurgaon Exp reqd. : 6-12 years.   Data Modeler JD  Responsibilities: Data Modeler will involve in extracting, transforming and inputting data sets from various sources; creating predictive models, coding methods for monitoring models, communicating findings to concern person and translating nontechnical...

  • Lead GCP Data Engineer

    9 hours ago

    Gurgaon, Haryana, India i-Qode Digital Solutions Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Key SkillsData GCPPysparkPythonLead experience: 2-4 Years Technical ExpertiseData engineering: ETL/ELT, Spark, DBTInfrastructure: GCP, Kubernetes/DockerTools: Airflow, BigQuery, Dataflow, Kafka/PubSub, Vertex AI, Jenkins/GitHub ActionsProgramming languages: Python, SQLMethods: dimensional modeling, OO ResponsibilitiesDevelop and maintain data models,...

  • Sr Data Engineer

    2 hours ago

    Gurgaon, Haryana, India CityMall Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Roles and Responsibilities: . Tests, monitors, manage and validate data warehouse activity including data extraction, transformation, movement, loading, cleansing, and updating processes Building and maintaining optimized and highly available data pipelines that facilitate deeper analysis and reporting Collaborate with stakeholders to understand,...

  • Data Engineer

    5 days ago

    Gurgaon, Haryana, India Weekday Full time ₹ 3,00,000 - ₹ 10,00,000

    This role is for one of our clientsCompany Name: Industry: Technology, Information and MediaSeniority level: Mid-Senior levelMin Experience: 5 yearsLocation: NCRJobType: full-time ₹3,00,000 - ₹10,00,000 a year We are seeking an experienced Data Engineer with deep expertise in the AWS data ecosystem to design, build, and optimize scalable data pipelines...

  • Lead Data Engineering

    7 hours ago

    Gurgaon, Haryana, India Incedo Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Company Overview Incedo is a US-based consulting, data science and technology services firm with over 3000 people helping clientsfrom our six offices across US, Mexico and India. We help our clients achieve competitive advantage throughend-to-end digital transformation. Our uniqueness lies in bringing together strong engineering, data science, anddesign...

  • Assistant Manager-Data Management and Analytics-Data Ops/Data Analyst

    7 days ago

    Gurgaon, Haryana, India EXL Talent Acquisition Team Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job description – Requirements Gathering Worked in client-facing engagements, scoping analytical asks, and translating business problems into data solutions. Proactively drive requirement gathering and solutioning and support delivery excellence Experience working in Agile setups using JIRA, ConfluenceData Modelling & Analysis Experience building and...