The Role
Design and implement scalable logical and physical data models, data warehouses, and ETL/ELT ingestion frameworks using Snowflake Medallion architecture. Develop optimized SQL and RDBMS schemas, establish data quality, lineage, governance, and DataOps practices, and collaborate with business and engineering teams. Document data structures and transformation logic while supporting distributed-team collaboration and stakeholder management.
Summary Generated by Built In
Job Title - Data Modeler / Data EngineerLocation
Working hours: Ability to overlap at least 4–5 hours with U.S. Central Time for collaboration.
Role OverviewWe 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 ResponsibilitiesData 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.
- 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
- 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.
Skills Required
- 8+ years of total experience in data engineering and architecture
- At least 5 years of hands-on experience implementing data modeling techniques and best practices
- Strong SQL and RDBMS skills
- Experience with dimensional modeling, including Kimball and Inmon methodologies
- Experience with data warehousing
- Experience with ETL and ELT pipelines
- Experience with cloud platforms, especially AWS
- Experience with data modeling tools, ER diagrams, and Lucidchart
- Experience implementing Medallion architecture for data ingestion
- Excellent communication skills and ability to work in a distributed team
- Stakeholder management experience
- Ability to overlap at least 4–5 hours with U.S. Central Time
- Knowledge of Snowflake data modeling
- Experience in the ITOps domain, including monitoring, incident management, cloud cost and billing, or managed services SLA data
- Exposure to data governance and cataloging tools such as Collibra and Soda
- Knowledge of DataOps practices and pipeline orchestration tools
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Anblicks is a Cloud Data Analytics Company based out of Dallas, TX, with offices in USA, India, and Australia. Since 2004, Anblicks has been helping customers by bringing value to their data and implementing modern data architecture and advanced analytics solutions in the cloud.
