Sr. Engineer II - Data Engg & AI

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.

Database & Pipeline Development

• • 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.

Collaboration & Documentation

• • 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 Stake holder 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.