Data Modeler
Posted on: 20/11/2025
Job Description
Description :
The ideal candidate will have hands-on experience building conceptual, logical, and physical data models, enabling enterprise-wide data governance, and leading cloud-based data modernization initiatives.
You will collaborate with cross-functional business and engineering teams to define robust data architecture, build optimized data processing layers, and guide teams through implementation best practices across OLTP, OLAP, and modern cloud environments.
Key Responsibilities :
- Apply Medallion architecture, ER modeling, dimensional modeling (Star/Snowflake), Data Vault, and advanced data modeling techniques.
- Build reusable intermediary data layers and physical consumable views for data marts.
- Ensure alignment of data models with enterprise architecture and business requirements.
Requirement Gathering & Documentation :
- Develop data mapping, source-to-target documents, metadata documentation, and lineage diagrams.
Data Governance & Quality :
- Use data observability tools and automated anomaly detection mechanisms.
- Maintain business glossaries, reference data, and data dictionaries.
Cloud Platforms & Engineering Collaboration :
- Guide engineers in ETL/ELT design, Snowflake implementation, and performance optimization.
- Support DevOps, DataOps, and CI/CD data pipelines.
Stakeholder Management & Leadership :
- Mentor and coach junior modelers, analysts, and engineers.
- Communicate insights and recommendations to senior stakeholders.
Migration & Modernization Projects :
- Conduct profiling, lineage analysis, performance tuning, and schema optimization.
- Review stored procedures, database objects, triggers, and business logic.
Required Skills & Expertise :
- Enterprise Data Architecture, Medallion Architecture.
- Data Modelling (Conceptual, Logical, Physical).
- OLTP, OLAP, Dimensional Modelling (Star/Snowflake).
- Data Governance, Metadata Management, Master Data.
- ETL/ELT & Data Warehousing.
- Agile, Scrum, Waterfall SDLC.
Technical Skills :
- Databases : Oracle, SQL Server, NoSQL.
- Modeling Tools : ER/Studio.
- ETL Tools : Ab Initio.
- Visualization : Power BI, Tableau.
- Strong SQL expertise-analytical functions, indexing, optimization, partitioning, query tuning.
- Knowledge of Snowflake features : Snowpipes, Streams, Tasks, zero-copy cloning.
Preferred Qualifications :
- Bachelors degree in Computer Applications or related field.
- Experience in BFSI, healthcare, insurance, or enterprise-scale systems.
Certifications (preferred) :
- Certified Data Management Professional (CDMP).
Did you find something suspicious?
Posted By
Vandana Saharan
Talent Acquisition Partner at Obrimo Technologies (Formerly known as Salecino)
Last Active: 28 Nov 2025
4
Posted in
Data Engineering
Functional Area
Data Engineering
Job Code
1577971
