Data Modeler, Solution Architect-Only Immediate Joiner

Role & responsibilities

Mandate skills- Python, AWS, Data Modeler, SQL and Devops (Good to Have not Mandate)

Please avoid candidates Qualified from the Universities of Hyderabad & Telangana

You Can consider Hyderabad and Telangana Candidates those are working in only tier one companies

6 to 8 years

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 modelling 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 (B.E./B.Tech/M.E./M.Tech/MCA)

  .

• Minimum 8 years of experience

  in data modeling 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

  Python,

  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) Good to have

• AWS Certification (e.g.,

  AWS Certified Solutions Architect

  or

  Data Analytics Specialty

  )
• Data Governance or Data Modelling Certifications (e.g.,

  CDMP

  ,

  Databricks

  , or

  TOGAF

  )

Mandatory Skills

Python, AWS, Technical Architecture, AIML, SQL, Data Warehousing, Data Modelling

Preferred candidate profile

Share resumes on Sakunthalaa@valorcrest.in