Job Title

Role: Data Modeler/Data ArchitectAbout Tredence:Tredence focuses on last-mile delivery of powerful insights into profitable actions by uniting its strengths in business analytics, data science and software engineering. The largest companies across industries are engaging with us and deploying their prediction and optimization solutions at scale. Head quartered in the San Francisco Bay Area, we serve clients in the US, Canada, Europe, and South East Asia.Tredence is an equal opportunity employer. We celebrate and support diversity and are committed to creating an inclusive environment for all employees.Visit our website for more details: for Data Modeler- Design and maintain conceptual, logical, and physical data models to align with evolving business requirements. - Develop detailed Entity Relationship (ER) diagrams and database designs using tools such as ERWIN. - Translate business needs into structured data solutions through close collaboration with stakeholders and technical teams. - Gather and analyse requirements to inform effective data modelling strategies. - Create comprehensive data mapping documentation and functional specifications for data engineering teams working within - Databricks. - Uphold data integrity, security, and quality across systems. - Define and advocate for best practices in data modelling standards and methodologies. - Support data governance, data lineage, and master data management (MDM) initiatives. - Conduct data profiling and remediate data quality issues proactively - Worked as a Data Modeller in one or two implementations in creating and implementing Data models and Data Base designs using Dimensional models. - Good knowledge and experience in modelling complex scenario’s like many to many relationships, SCD types, Late arriving fact and dimensions etc. - Hands on experience in any one of the Data modelling tools like Erwin, ER/Studio, Enterprise Architect or SQLDBM etc. - Experience in working closely with Business stakeholders/Business Analyst to understand the functional requirements and translating it into Data Models and database designs. - Experience in creating conceptual models and logical models and translating it into physical models to address the both functional and non functional requirements. - Strong knowledge in SQL, able to write complex queries and profile the data to understand the relationships and DQ issues. - Very strong understanding of database modelling and design principles like normalization, denormalization, isolation levels. - Experience in Performance optimizations through database designs (Physical Modelling). - Good communication skills.NP: Immediate to 15 Days