Architect-Data Modeling

As an Architect you will work to solve some of the most complex and captivating data management problems that would enable

them as a datadriven 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 nextgen data platform by collaborating with crossfunctional 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

EXPERTISE AND QUALIFICATIONS

What do we expect

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)

Realtime 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

Remote Work :

No