Design, develop, and maintain relational, dimensional, and analytical data models for OLTP and analytical systems. Perform ER diagramming, enforce modeling standards, optimize SQL performance, implement metadata management and data cataloging (Alation/Collibra), support data governance, lineage, time-series/history handling, and collaborate with cross-functional teams in an agile environment.
Location: Chennai
Experience: 6-9 Years
We are looking for a highly skilled Senior Data Modeler with extensive experience in data modeling, SQL, metadata management, and data governance. The ideal candidate will have expertise in relational, dimensional, and analytic data modeling with hands-on experience in databases like Oracle, PostgreSQL, Snowflake, and Teradata. Strong knowledge of data governance, data cataloging tools (Alation, Collibra), and metadata repositories is essential.
Key Responsibilities:- Design, develop, and maintain relational, dimensional, and analytical data models for large-scale OLTP and analytical systems.
- Perform hands-on data modeling, ER diagramming, and enterprise software design for diverse data ecosystems.
- Define and enforce data modeling standards and best practices for scalable and high-performance solutions.
- Work with SQL databases such as Oracle, PostgreSQL, Snowflake, and Teradata, optimizing performance and query tuning.
- Collaborate with cross-functional teams (engineers, architects, product managers) to translate business requirements into effective data models.
- Implement metadata management, data lineage, and data cataloging using tools like Alation and Collibra.
- Ensure data accuracy, completeness, and consistency across data models and maintain comprehensive documentation.
- Support history handling, time-series data warehousing, and complex data transformations.
- Assist teams in adopting data modeling best practices for global, large-scale data-driven implementations.
- Contribute to data governance initiatives and establish a centralized metadata repository.
- Work in a fast-paced, agile environment with short release cycles and iterative development methodologies.
- 7+ years of experience in relational, dimensional, and analytical data modeling.
- Strong SQL skills with hands-on experience in Oracle, PostgreSQL, Snowflake, and Teradata.
- Experience with data modeling tools (Erwin, ER Studio, or similar).
- Expertise in data governance processes and metadata repositories.
- Knowledge of semantic data modeling concepts and multi-fact model designs.
- Strong verbal and written communication skills to interact with engineers, architects, and product managers.
- Ability to work on multiple projects/products simultaneously with minimal specifications.
- Experience in Alation and Collibra for data cataloging and data lineage tracking.
- Knowledge of Python for data processing.
- Experience with Informatica for ETL and data integration.
Similar Jobs
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Lead design and operation of a self-managed Enterprise MongoDB platform: set standards, own backups/restore, performance engineering, capacity planning, security hardening, incident leadership, documentation, and mentor junior administrators while partnering with infrastructure and application teams to standardize and automate operations.
Top Skills:
AnsibleCi/CdLinuxMongoDBMongodb Ops ManagerNutanixRbacReplica SetsShardingTerraformTls
Cloud • Information Technology • Security • Software
Provides Tier 1 technical support to SaaS customers through email, phone, chat, and remote sessions. Troubleshoots macOS, MDM, directory services, iOS management, software management, APIs, and user lifecycle issues. Manages high-priority tickets, reproduces defects, collaborates with engineering and product teams, supports customer onboarding, maintains knowledge-base content, and participates in on-call coverage.
Top Skills:
Ai Prompt EngineeringApple Mobile Device Management (Mdm)AptCentosDebianDepFilevaultGoogle WorkspaceiOSKeychainLdapLinuxmacOSOktaPamRest ApisRhelRpmScriptingSshUbuntuVolume Purchase Program (Vpp)Yum
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Performs complex semiconductor manufacturing operations independently, serves as a subject matter expert, troubleshoots equipment and process issues, and supports yield, scrap, cycle-time, and productivity improvements. Analyzes manufacturing data, trains production associates, supports engineering evaluations and product introductions, investigates root causes, implements corrective actions, and maintains safety, cleanroom, quality, and operational standards while working rotating 12-hour shifts.
Top Skills:
Cleanroom OperationsHigh-Volume Production OperationsManufacturing EquipmentManufacturing SystemsProcess ControlsSemiconductor Manufacturing
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
