Summary:
Data Modeler plays a critical role in data and analytics life cycle and significantly contributes to production grade data and analytics solutions. The role requires one to demonstrate expertise in conceptual, logical and physical data modeling and translate business requirements to data. This role mentors Data modelers. It is an individual contributor role, expected to solve wide ranging business problems.
Requirements:
8-10+ years of relevant experience
Bachelors degree in computer science, information technology or equivalent educational qualification
Role & responsibilities:
• Translate business requirments into scalable data model designs.
• Design and maintain logical, physical data models to support business and analytics needs.
• Ensure data model consitency, integrity and adherence to best practices
• Develop and optimze dimensional data models for performance, scalaibility and deployment in on-prem and cloud (Azure Synapse, Databricks) for analytical processing
• Perform data profiling and validation to ensure models accuracy & completeness
• Build and maintain data dicitonaries, metadata respositories and ER diagrams.
• Mentor Data Modelers
• Independently lead design, solutioning & estimations
• Collaborate with multiple partners from Business,Technology, Operations and D&A capabilities (Data Governance, Data Quality, Data Modeling, Data Architecture, Data science, DevOps, BI & insights)
Technical skills:
• Data modeling tools such as ERwin
• SQL/NOSQL for schema design , validation and optimization
• Dimensional modeling (3NF,star schema, snowflake)
• Relational databases (SQL, Oracle) Cloud platforms (Azure Synapes, Databricks, Cosmos DB)
• Designing models for ETL and analytics workflows
• API Design and Ingestion (REST, SOAP, JSON, XML).
• Normalization, denormlization principles and performance tuning techniques
• Domain based modelling
• Mentorship experience
• Communication skills, analytical skills, structured problem-solving skills.
• Storytelling, Partner, Stakeholder engagement experience
Never miss an opportunity! Create an alert based on the job you applied for.
