View all jobs

Data Architect – (Dimensional & Relational Modeling)

Hyderabad, Telangana
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)
  • Proven analytical skills & Problem-solving attitude

Powered by