Data Architect – (Dimensional & Relational Modeling)
We are looking for a Data Architect having 12-18 years of experience to build, optimize and maintain conceptual, logical database and physical data models. With exposure to Sales/Finance, Manufacturing, Quality, Engineering, Supply Chain, Finance, After-sales/Credit and Digital workplace Domain exposure.
For this role, you should know how to analyse business requirements and derive conceptual model by identifying entities and the relationship between them. You should be able to identify attributes and create logical and physical models. You should be able to demonstrate proficiency in choosing the right architecture that would solve the business problems.
Hands-on experience with multiple databases like Snowflake, Amazon Redshift, Oracle, MSSQL Server, Teradata, NOSQL, MongoDB is also required. You should have mandatory knowledge of various data modelling techniques and should be hands on with Data Modelling tools like ERWin, TOAD, PowerDesigner, etc. You should be familiar with Data-warehousing concepts, data extraction and transformation, predictive analysis and data visualization techniques using relevant tools (e.g. Tableau, D3.js, Qlikview)
At least 7-8 years of experience in Data Modeling (Dimensional & Relational Modeling)
Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable conceptual and subsequently, logical & physical data models
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
Demonstrable experience in developing, publishing, and maintaining all documentation for data models
Ability to quickly learn and adapt modeling methods from case studies or other proven approaches
Strong knowledge on Modeling tools such as Erwin or ER Studio, MS Visio etc.,
Strong experience in Reverse engineering and Forward Engineering and generating DDLs considering all the performance aspects
Strong knowledge on Data Warehousing, Data Modeling Concepts, Data Architecture, Database design etc
Strong experience in source data analysis and source to target/ETL mappings
Very good SQL knowledge and ability to write complex queries
Proficient in creating flowcharts, process flows and data flow diagrams
Collaborate with application development and support teams on various IT projects
Assist in setting strategic direction for database, infrastructure and technology
Create and maintained technical documentation for complex operational, web, business intelligence, and analytical applications
Migrate data from legacy systems to new solutions
Design conceptual and logical data models and flowcharts
Provide operational support for Management Information Systems (MIS)
Design ETL/ELT process and orchestration of data flows
Monitoring performance and advising any necessary infrastructure changes
Defining data retention policies
Mentoring junior engineers and working with other architects to deliver best in class solutions
Strong understanding of open source technologies and databases (SQL & NoSQL)
Experience with integration of data from multiple data sources
Ability to architect end-to-end data products and make the right choice of technology stack based on the use case
Optimize new and current database systems
Proven work experience as a Data Architect, Data Modeler or similar role
At least 3 years of experience on Snowflake and AWS related technologies.
Knowledge of data mining and segmentation techniques
Hands on with Data Modelling tools like ERWin, TOAD, PowerDesigner
Experience on any of the Cloud databases (Snowflake, Redshift etc.,)
Expertise in Structured Query Language
Proficiency in MS Excel
Familiarity with data visualization tools (e.g. Tableau, D3.js, Qlikview etc)