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.
Photon Chennai, Tamil Nadu, IND Office
DLF IT Park 1/124 Mount Poonamallee Road Sivaji Gardens Manapakkam , Chennai, India, 600089
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads scalable UI and API test automation using Python, PyTest, Playwright, Robot Framework, and Selenium. Develops comprehensive test suites, validates APIs and databases, tests microservices and healthcare applications, and integrates quality checks into CI/CD pipelines. Oversees defect triage, risk-based testing, quality metrics, release readiness, and Agile collaboration. Applies AI tools, LLMs, machine-learning-based test optimization, prompt engineering, and intelligent failure analysis. Supports cloud, containerization, infrastructure-as-code, and healthcare interoperability testing.
Top Skills:
AlmAWSAzureAzure AiAzure BoardsAzure PipelinesClaudeCloudFormationDicomDockerDynamoDBEmbeddingsFhirGCPGitGithub ActionsGithub CopilotGitlab CiHipaaHl7Hugging FaceInsomniaJenkinsJIRAKafkaM365 CopilotMongoDBOpenaiPlaywrightPostmanPytestPythonRagRallyRequestsRest AssuredRobot FrameworkSauce LabsSeleniumSQLTerraformVector Databases
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Develops and maintains ETL/ELT pipelines, legacy SSIS and SSAS solutions, reporting platforms, and relational and dimensional data models. Tunes SQL, data pipelines, semantic layers, and reporting workloads for performance and reliability. Supports Snowflake and cloud-native data platforms, documents data lineage and procedures, responds to ServiceNow incidents, and follows HIPAA, ITIL, governance, and change-control standards. Collaborates across technical and analytics teams while supporting healthcare data systems and modernization initiatives.
Top Skills:
Apache AirflowAzure Data FactoryAzure Machine LearningAzure SynapseCozyroc Ssis+DbtKronosPower BIPythonServicenowSnowflakeSQL ServerSsasSsisSsrsT-SqlTableauUkg
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Lead end-to-end design for complex enterprise digital products, defining experience strategy and creating user journeys, workflows, wireframes, high-fidelity designs, and prototypes. Partner with product, engineering, research, and business leaders to influence product direction, synthesize research, advance design systems, and ensure implementation quality. Mentor designers, promote accessibility and human-centered design, and responsibly use AI-enabled tools to improve design workflows.
Top Skills:
AgileFigmaWcag 2.1Aa
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
