Job Description

About TredenceTredence is a global analytics services and solutions company. We are one of the fastest growing private companies in the country for three straight years according to the Inc. 5000 and we continue to set ourselves apart from our competitors by attracting the greatest talent in the data analytics and data science space. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is in building Scalable Big Data Solutions on Onprem/GCP/Azure cloud in a very cost effective and easily scalable manner for our clients. We also come in with some strong IP and pre-built analytics solutions in data mining, BI and Big Data.Roles & Responsibilities Role- Data ModelerExperience- 8+ yearsLocation- Bangalore/Chennai/Pune/Kolkata/Gurgaon

• 8+ years of proven work experience in data modelling related projects as a Data Modeler. Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL). Experience in deploying data models in on-prem and cloud platforms - Microsoft Azure / Google Cloud Platform (GCP) / Amazon Web Services (AWS). Experience in implementing various types of data modeling techniques - relational, dimensional modeling, building Entity-Relationship diagram with commendable understanding in relationship building, referential integrity, etc. Well versed in data warehousing with proficiency in designing various kind of fact tables, dimension tables and putting them all together in star schema, snowflake schema, etc. based on business requirements. Experience in defining data loading strategy, SCD types, CDC methodologies. Good hands-on experience on Enterprise Data Modeling and Retail Data Modeling with proven track record to implement relevant KPIs of Retail industry will be a plus. Ability to understand data relationships and can design data models that reflects these relationships and facilitates efficient ingestion, processing, and consumption of Data. Experience in implementation of multiple indexing strategies, partitioning techniques (preferable in Azure SQL Data Warehouse (Synapse)) as part of optimization. Experience in certain industry leading data modeling tools will be an added advantage. Excellent problem solving and communication skills; experience in interacting with technical and nontechnical stakeholders at all levels. Experience gathering business requirements and understanding and translating business needs into data models, creating logical and physical data models using best practices to ensure high data quality and reduced redundancy of Product Information. Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks. Create logical and physical data models using best practices to ensure high data quality and reduced redundancy. Understand and translate business needs into data models supporting long-term solutions. Working closely with the data analyst and data platform teams to Analyze and evaluate existing data systems and continuously updating and optimizing data models. Working closely with Business and Analytics team to understand business needs and translate them into long-term solution data models. Working with the data ingestion teams from different business areas to understand the data availability and format and to create conceptual data models and data flows. Jointly accountable, together with Platform and Development teams, for the performance of the reporting solutions produced. Developing best practices for data coding naming conventions, default values, semantics, data dictionary, etc. to ensure consistency within the system and act as an educator and ambassador for best practices when it comes to the data modelling. Recommend opportunities for reuse of data models in new environments. Develop data models according to company standards. Perform reverse engineering of physical data models from databases and SQL scripts. Evaluate data models and physical databases for variances and discrepancies. Validate business data objects for accuracy and completeness. Analyze data-related system integration challenges and propose appropriate solutions

Qualification & ExperienceWhy Join Tredence?There is a reason we are one of the fastest growing private companies in the country! You will have the opportunity to work with some of the smartest and fun-loving people in the data analytics space. You will work with the latest technologies and interface directly with the key decision stakeholders at our clients, some of the largest and most innovative businesses in the world. Our people are our greatest asset and we value every one of them. Come see why we're so successful in one of the most competitive and fastest growing industries in the world.

Tredence