Job Description
- Design and develop conceptual, logical, and physical data models for OLTP and OLAP systems.
- Collaborate with business analysts and data engineers to understand data requirements.
- Ensure models support data governance , data quality , and data integration standards.
- Maintain and update data models as business needs evolve.
- Create and manage metadata repositories and data dictionaries .
- Optimize data models for performance , scalability , and security .
- Work with database administrators to implement models in relational and NoSQL databases.
- Support ETL processes and data warehousing initiatives.
- Proven experience in data modeling tools (e.g., Erwin, SAP PowerDesigner, IBM InfoSphere).
- Strong understanding of relational databases , dimensional modeling , and normalization techniques .
- Experience with SQL , data warehousing , and ETL tools .
- Familiarity with cloud platforms (e.g., AWS, Azure) is a plus.
- Excellent communication and documentation skills.
Required Technical / Functional Competencies
Domain / Industry Knowledge :
Basic knowledge of customer's business processes- relevant technology platform or product.Able to prepare process maps, workflows, business cases and simple business models in line with customer requirements with assistance from SME and apply industry standards / practices in implementation with guidance from experienced team members.Requirement Gathering and Analysis :
Working knowledge of requirement management processes and requirement analysis processes, tools & methodologies.Able to analyse the impact of change requested / enhancement / defect fix and identify dependencies or interrelationships among requirements & transition requirements for engagement.Product / Technology Knowledge :
Working knowledge of technology product / platform standards and specifications.Able to implement code or configure / customize products and provide inputs in design and architecture adhering to industry standards / practices in implementation.Analyze various frameworks / tools, review the code and provide feedback on improvement opportunities.Architecture tools and frameworks :
Working knowledge of architecture Industry tools & frameworks.Able to identify pros / cons of available tools & frameworks in market and use those as per Customer requirement and explore new tools / framework for implementation.Architecture concepts and principles :
Working knowledge of architectural elements, SDLC, methodologies.Able to provides architectural design / documentation at an application or function capability level and implement architectural patterns in solution & engagements and communicates architecture direction to the business.Analytics Solution Design :
Knowledge of statistical & machine learning techniques like classification, linear regression modelling, clustering & decision trees.Able to identify the cause of errors and their potential solutions.Tools & Platform Knowledge :
Familiar with wide range of mainstream commercial & open-source data science / analytics software tools, their constraints, advantages, disadvantages, and areas of application.Required Behavioral Competencies
Accountability :
Takes responsibility for and ensures accuracy of own work, as well as the work and deadlines of the team.Collaboration :
Shares information within team, participates in team activities, asks questions to understand other points of view.Agility :
Demonstrates readiness for change, asking questions and determining how changes could impact own work.Customer Focus :
Identifies trends and patterns emerging from customer preferences and works towards customizing / refining existing services to exceed customer needs and expectations.Communication :
Targets communications for the appropriate audience, clearly articulating and presenting his / her position or decision.Drives Results :
Sets realistic stretch goals for self & others to achieve and exceed defined goals / targets.Resolves Conflict :
Displays sensitivity in interactions and strives to understand others’ views and concerns.Certifications
Mandatory At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale. Our Hyperlearning workplace is grounded upon four principles
Flexible work arrangements, Free spirit, and emotional positivityAgile self-determination, trust, transparency, and open collaborationAll Support needed for the realization of business goals,Stable employment with a great atmosphere and ethical corporate culture