Responsible for the development of the conceptual, logical, and physical data models on Cloud Data Warehouse, data marts, and data lakes on target platforms like Redshift, Snowflake,Neo4J
Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
Skills & Experience
10+ years of hands-on design and implementation of Data Warehouse, Dimensional model and business semantic models
Should have hands-on experience in designing and build data models from scratch on Cloud Data Warehouse's like Redshift or Snowflake
Experience in using data modeling tools like Erwin or ER Studio or others is required.
Experience on Graph Data model is preferable
Should have knowledge of Inmon or Kimball data models patterns
Knowledge of any ETL tool like Talend, Informatica is preferable