Senior Data Modeler

4 weeks ago

Bengaluru, India Risosu Consulting Full time

Job Description :

We are seeking a highly experienced Sr Data Modeler / Solution Architect to join the Data Architecture team in Bangalore.

The ideal candidate will have 8 to 10 years of experience in data modeling and architecture with deep expertise in AWS cloud stack, data warehousing, and enterprise data modeling tools.

This individual will be responsible for designing and creating enterprise-grade data models and driving the implementation of Layered Scalable Architecture or Medallion Architecture to support robust, scalable, and high-quality data marts across multiple business units.

This role will involve managing complex datasets from systems like PoS, ERP, CRM, and external sources, while optimizing performance and cost. You will also provide strategic leadership on data modeling standards, governance, and best practices, ensuring the foundation for analytics and reporting is solid and future-ready.

Key Responsibilities :

- Design and deliver conceptual, logical, and physical data models using tools like ERWin.

- Implement Layered Scalable Architecture / Medallion Architecture for building scalable, standardized data marts.

- Optimize performance and cost of AWS-based data infrastructure (Redshift, S3, Glue, Lambda, etc.).

- Collaborate with cross-functional teams (IT, business, analysts) to gather data requirements and ensure model alignment with KPIs and business logic.

- Develop and optimize SQL code, materialized views, stored procedures in AWS Redshift.

- Ensure data governance, lineage, and quality mechanisms are established across systems.

- Lead and mentor technical teams in an Agile project delivery model.

- Manage data layer creation and documentation: data dictionary, ER diagrams, purpose mapping.

- Identify data gaps and availability issues with respect to source systems.

Required Skills & Qualifications :

- Bachelors or Masters degree in Computer Science, IT, or related field Minimum 4 years of experience in data modelling and architecture.

- Proficiency with data modeling tools such as ERWin, with strong knowledge of forward and reverse engineering.

- Deep expertise in SQL (including advanced SQL, stored procedures, performance tuning).

- Strong experience in data warehousing, RDBMS, and ETL tools like AWS Glue, IBM DataStage, or SAP Data Services.

- Hands-on experience with AWS services: Redshift, S3, Glue, RDS, Lambda, Bedrock, and Q.

- Good understanding of reporting tools such as Tableau, Power BI, or AWS QuickSight.

- Exposure to DevOps/CI-CD pipelines, AI/ML, Gen AI, NLP, and polyglot programming is a plus.

- Familiarity with data governance tools (e.g., ORION/EIIG).

- Domain knowledge in Retail, Manufacturing, HR, or Finance preferred.

- Excellent written and verbal communication skills.

Certifications (Preferred) :

- AWS Certification (e.g., AWS Certified Solutions Architect or Data Analytics Specialty)

- Data Governance or Data Modeling Certifications (e.g., CDMP, Databricks, or TOGAF)

Mandatory Skills :

- Aws, Technical Architecture, Aiml, SQL, Data Warehousing, Data Modelling

(ref:hirist.tech)

  • Data Modeler

    19 hours ago

    Bengaluru, India Aptus Data LAbs Full time

    **Job Information**: Number of Positions - 1Industry - TechnologyWork Experience - 5-8 yearsLast Activity Time - 12/02/2021 23:00City - Bangalore NorthState/Province - KarnatakaCountry - IndiaZip/Postal Code - 560002The data modeller designs, implements, and documents data architecture and data modelling solutions, which include the use of relational,...

  • ERWin Data Modeler

    3 weeks ago

    Bengaluru, India NTT DATA Full time

    Req ID: NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a ERWin Data Modeler to join our team in Bangalore, Karnātaka (IN-KA), India (IN). "Job Duties: Build Conceptual Data...

  • ERWin Data Modeler

    1 week ago

    Bengaluru, Karnataka, India NTT DATA Full time ₹ 15,00,000 - ₹ 28,00,000 per year

    Req ID: 340303NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a ERWin Data Modeler to join our team in Bangalore, Karnātaka (IN-KA), India (IN). "Job Duties: Build Conceptual Data...

  • Sr. Data Modeler

    2 weeks ago

    Bengaluru, India NTT DATA Full time

    Job Description Req ID:     NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Sr. Data Modeler to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Primary...

  • Senior Data Modeler

    2 weeks ago

    Bengaluru, Karnataka, India Rite Software Solutions And Services Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Overview:We are seeking a highly skilled Senior Data Modeler with strong expertise in conceptual, logical, and physical data modeling. The ideal candidate will be proficient in data modeling tools like ERwin, ER/Studio, or similar, with a deep understanding of different database modeling techniques, including Star, Snowflake, and 3NF. This role requires...

  • Data Modeler

    2 weeks ago

    Bengaluru, Karnataka, India NTT DATA Global Delivery Services Ltd Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    ERWin Data Modeler Req ID: 340303 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a ERWin Data Modeler to join our team in Bangalore, Karnātaka (IN-KA), India (IN). "Job...

  • Senior Data Scientist

    2 weeks ago

    Bengaluru, India IC Data Full time

    Senior Data Scientist (Remote Sensing) About the job Sagri Inc. is a pioneering social impact startup founded in 2018 with the vision of "realizing the coexistence of humanity and the earth." We utilize satellite data and AI technology to address global food crises and climate change challenges. Our core products - Actaba, Detaba, and Sagri - offer...

  • Senior Data Scientist

    2 weeks ago

    Bengaluru, India IC Data Full time

    Senior Data Scientist (Remote Sensing) About the job Sagri Inc. is a pioneering social impact startup founded in 2018 with the vision of "realizing the coexistence of humanity and the earth." We utilize satellite data and AI technology to address global food crises and climate change challenges. Our core products - Actaba, Detaba, and Sagri - offer...

  • Senior Data Modeler

    6 days ago

    Bengaluru, Chennai, Pune, India Photon Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    About The Role   Location:  ChennaiExperience:  6-9 YearsJob Summary: We are looking for a highly skilled Senior Data Modeler  with extensive experience in data modeling, SQL, metadata management, and data governance . The ideal candidate will have expertise in relational, dimensional, and analytic data modeling  with hands-on experience in databases...

  • Senior Data Scientist

    3 days ago

    Bengaluru, India Enable Data Incorporated Full time

    Enable Data Incorporated is looking for a talented and experienced Senior Data Scientist to join our innovative team. In this role, you will be responsible for driving data science initiatives, developing predictive models, and providing insights that guide key business decisions. The ideal candidate has a strong background in statistical analysis, machine...