Architect- Data Modeling

Tiger Analytics; Hyderabad, Chennai District, Bengaluru; Hybrid; INR 3,000,000 - 4,500,000; Full time

Job summary

Tiger Analytics in Hyderabad seeks an experienced Data Modeling Architect to solve complex data management challenges across analytics initiatives. The role requires switching between individual contributor, team member, and architectural leadership to define, design, and deliver actionable insights.

You will create and maintain logical and physical data models, govern data structures, and guide cross-functional teams on cloud platforms and ETL approaches to ensure scalable data solutions.

Qualifications

• Experience in data modeling for complex data ecosystems.
• Strong SQL proficiency and data structures knowledge.
• Experience with RDBMS and dimensional modeling concepts.
• Familiarity with cloud data platforms and ETL tooling.
• Ability to lead discussions with stakeholders and guide architectural decisions.

Responsibilities

• Engage clients to translate business requirements into data models.
• Analyze problems, propose data-struct solutions, and estimate efforts.
• Create and maintain Logical and Physical Data Models (LDM/PDM).
• Use data modeling tools to create appropriate models.
• Document Source to Target mappings, entities, keys, and rules.
• Publish Data Dictionaries and maintain metadata.
• Design automations and accelerators with the team.
• Capture and maintain data models from existing databases.
• Contribute to data warehouse and data marts on cloud, with profiling and quality checks.
• Use version control for data model artifacts.
• Collaborate with Data Engineers on extraction and integration modules.
• Plan ingestion logic, data consumption patterns, and testing with engineers.
• Ideate and design the next-gen data platform with cross-functional stakeholders.
• Define modelling standards and best practices; monitor project milestones.
• Coach team members and review code artifacts; contribute to proposals and RFPs.

Skills

Data space experience

SQL knowledge

Data modeling approaches

RDBMS (Oracle, DB2, SQL Server)

OLAP/OLTP dimensional models

Star/Snowflake/Data Vault

ETL tooling

Cloud services (Azure, AWS, GCP)

Stakeholder management

Team leadership / mentoring

Proposals & RFPs

Communication

Agile experience

Job description

Role & responsibilities

As an Architect, you will work to solve some of the most complex and captivating data management problems that would enable them as a data-driven organization; Seamlessly switch between roles of an Individual Contributor, team member, and Data Modeling Architect as demanded by each project to define, design, and deliver actionable insights.

On a typical day, you might

• Engage the clients & understand the business requirements to translate those into data models.
• Analyze customer problems, propose solutions from a data structural perspective, and estimate and deliver proposed solutions.
• Create and maintain a Logical Data Model (LDM) and Physical Data Model (PDM) by applying best practices to provide business insights.
• Use the Data Modelling tool to create appropriate data models
• Create and maintain the Source to Target Data Mapping document that includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Gather and publish Data Dictionaries.
• Ideate, design, and guide the teams in building automations and accelerators
• Involve in maintaining data models as well as capturing data models from existing databases and recording descriptive information.
• Contribute to building data warehouse & data marts (on Cloud) while performing data profiling and quality analysis.
• Use version control to maintain versions of data models.
• Collaborate with Data Engineers to design and develop data extraction and integration code modules.
• Partner with the data engineers & testing practitioners to strategize ingestion logic, consumption patterns & testing.
• Ideate to design & develop the next-gen data platform by collaborating with cross-functional stakeholders.
• Work with the client to define, establish and implement the right modelling approach as per the requirement
• Help define the standards and best practices
• Involve in monitoring the project progress to keep the leadership teams informed on the milestones, impediments, etc.
• Coach team members, and review code artifacts.
• Contribute to proposals and RFPs

Preferred candidate profile

• 10+ years of experience in Data space.
• Decent SQL knowledge
• Able to suggest modeling approaches for a given problem.
• Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server)
• Real-time experience working in OLAP & OLTP database models (Dimensional models).
• Comprehensive understanding of Star schema, Snowflake schema, and Data Vault Modelling. Also, on any ETL tool, Data Governance, and Data quality.
• Eye to analyze data & comfortable with following agile methodology.
• Adept understanding of any of the cloud services is preferred (Azure, AWS & GCP)
• Enthuse to coach team members & collaborate with various stakeholders across the organization and take complete ownership of deliverables.
• Experience in contributing to proposals and RFPs
• Good experience in stakeholder management
• Decent communication and experience in leading the team