About Client
Our Client is a global leader in AI and Analytics helping Fortune 1000 companies solve their toughest challenges.
They have a team of 4000 technologists and consultants are based in the US Canada the UK India Singapore and Australia working closely with clients across CPG Retail Insurance BFS Manufacturing Life Sciences and Healthcare.
Our client are Great Place to WorkCertified.
They are ranked among the Best and Fastest Growing analytics firms lists by Inc. Financial Times Economic Times and Analytics India Magazine.
Job Responsibility
The Data Modeler will be responsible for the design development and maintenance of data models and standards for Enterprise data platforms.
Understand the Business Requirements and the corresponding data sets.
Translate business requirements into working logical and physical Service Layer Data models. Create and maintain Logical Data Model (LDM) and Physical Data Model (PDM) applying best practices and providing business insights.
Create and maintain the Source to Target Data Mapping document. 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: Maintain data models and capture data models from existing databases and record descriptive information.
Build data warehouse & data marts (on Cloud) while performing data profiling and quality analysis.
Use Version control to maintain versions of data models
Design and develop data extraction and integration code modules.
Work with the Data Engineers to define the Ingestion logic ingestion frequency and data consumption patterns
Requirements
Required Experience Skills & Competencies:
Strong experience in one or more RDBMS systems (such as Oracle DB2 SQL Server)
Good understanding of Star schema Snowflake schema Data Vault Modelling
Good experience in OLTP and OLAP systems
Excellent Data Analysis skills
Good Experience on one or more Cloud DW (e.g. Snowflake Redshift Synapse)
Experience on one or more cloud platforms (e.g. AWS Azure GCP)
Understanding of DevOps process
Handson experience in any Data Modelling Tool
Good understanding of one or more ETL tool
Excellent Communication skills
Minimum 3 years of relevant handson experience
Required Experience, Skills & Competencies: Strong experience in one or more RDBMS systems (such as Oracle, DB2, SQL Server) Good understanding of Star schema, Snowflake schema, Data Vault Modelling Good experience in OLTP and OLAP systems Excellent Data Analysis skills Good Experience on one or more Cloud DW (e.g. Snowflake, Redshift, Synapse) Experience on one or more cloud platforms (e.g. AWS, Azure, GCP) Understanding of DevOps process Hands-on experience in any Data Modelling Tool Good understanding of one or more ETL tool Excellent Communication skills Minimum 3 years of relevant hands-on experience