Sr. Engineer II - Data Engg & AI

Anblicks Inc.; Hyderabad; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

Anblicks Inc. is seeking an experienced Data Modeler/Data Engineer with 8+ years of total experience and at least 5 years of hands-on data modeling expertise.

The role focuses on designing scalable data models and ingestion frameworks using Medallion architecture, with strong SQL, RDBMS, dimensional modeling, data warehousing, and ETL/ELT skills. Responsibilities include building Bronze-Silver-Gold data ingestion layers in Snowflake, ensuring data quality and lineage, and collaborating with

Qualifications

• 8+ years of total experience in data engineering and architecture.
• Minimum 5 years of hands-on experience in data modeling techniques and best practices.
• Strong SQL and RDBMS skills; dimensional modeling and data warehousing expertise.
• Experience implementing Medallion architecture for data ingestion.
• Proficiency with ETL/ELT, cloud platforms (AWS), and data modeling tools like ER diagrams and Lucidchart.

Responsibilities

• Design and implement logical and physical data models for analytical and operational use cases.
• Apply data modeling techniques (dimensional modeling, normalization/denormalization, canonical modeling) to ensure scalability and performance.
• Build and maintain data ingestion layers (Bronze, Silver, Gold) in Snowflake Medallion Architecture.
• Define data quality, lineage, and governance standards across layers; ensure schemas align with business requirements.
• Collaborate with data engineers and analysts to translate requirements into robust data models and documentation using ER diagrams and Lucidchart.

Skills

SQL

RDBMS

Dimensional Modeling

Data Warehousing

ETL/ELT

Cloud Platforms

Data Modeling Tools

Medallion Architecture

DataOps

Snowflake

IT Operations (ITOps)

Tools

ER diagrams

Lucidchart

Job description

Job Title - Data Modeler / Data Engineer

Location

Working hours: Ability to overlap at least 4–5 hours with U.S. Central Time for collaboration.

Role Overview

We are seeking an experienced Data Modeler/ Data Engineer with 8+ years of total experience and at least 5 years of hands‑on experience in implementing data modeling techniques and best practices. The candidate will design and implement scalable data models and ingestion frameworks using Medallion architecture. Strong technical skills in SQL, RDBMS, Dimensional Modeling (Kimball/Inmon), Data Warehousing, ETL/ELT, and Cloud Platforms are mandatory. Knowledge of the Snowflake and IT Operations (ITOps) is a strong plus.

Key Responsibilities

Data Modeling

• Design and implement logical and physical data models for analytical and operational use cases.
• Apply data modeling techniques and best practices (dimensional modeling, normalization/denormalization, canonical modeling).
• Ensure models align with business requirements and support scalability and performance.

Snowflake Medallion Architecture Implementation

• Build and maintain data ingestion layers (Bronze, Silver, Gold) for structured and semi‑structured data.
• Define standards for data quality, lineage, and governance across layers.
• Work with SQL and RDBMS systems to design optimized schemas.
• Collaborate with data engineering teams to implement robust ETL/ELT pipelines using modern orchestration tools.
• Apply DataOps principles for CI/CD, automated testing, and deployment of data workflows.
• Work closely with business analysts and domain experts to translate requirements into data models.
• Maintain clear documentation for data structures, lineage, and transformation logic using tools like ER diagrams and Lucidchart.

Required Skills & Qualifications

• 8+ years of total experience in data engineering and architecture.
• Minimum 5 years of hands‑on experience in data modeling techniques and best practices.
• Strong technical skills in:
  • SQL and RDBMS
  • Dimensional Modeling (Kimball/Inmon)
  • Data Warehousing
  • ETL/ELT
  • Cloud Platforms (AWS)
  • Data Modeling Tools (ER diagrams, Lucidchart)
• Experience implementing Medallion architecture for data ingestion.
• Excellent communication skills and ability to work in a distributed team and stakeholder management.
• Knowledge of Snowflake Data Modeling will be Advantage

Nice to Have

• Experience in the IT Operations (ITOps) domain (Monitoring & Telemetry, Incident Management & Ticketing, Cloud Cost & Billing, Managed Services SLA Data).
• Exposure to data governance and cataloging tools (Collibra, Soda).
• Knowledge of DataOps practices and pipeline orchestration tools.