Work with the business, users, lead architect, and designers to define the data requirements and structure for the application(s).
Evaluate existing database and create conceptual, logical and physical data models and data flows
Model and design DW schema for redshift based on the current use cases.
Evaluate existing Postgres DB model and design and build an Olap model and data flows.
Lead the database analysis and design optimized for all consumption patterns.
Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth.
Assist in determining the cross-application data standards, data distribution standards, and tuning strategies.
Establishes and maintains a data modeling repository and ensures that it is implemented according to standards and that all required personnel have appropriate access to it.
Ensuring compliance of data with regulations and identify training needs for all data users.
Minimum of bachelor’s or equivalent experience is required.
7+ years of Data modelling experience within data and analytics domain including experience in automation.
Ability to develop relational, hierarchical and dimensional data models including graph technologies.
Ability to develop or revise the database architecture per data requirements.
Able to convert data and related techniques to acquire data needed to support testing, training, and other application development activities.
Strong capabilities to review project deliverables for completeness, quality, and compliance with established architecture standards.
Proficient in documenting and communicating progress against plans, taking corrective action as necessary.
Experience with Amazon AWS EC2/S3/RDS/Redshift
Strong experience with multiple database technologies for relational and unstructured data
Experience working with data verification, data management, and data maintenance and experience of remediation data gaps.
The ability to perform work with a high degree of independence in terms of self-management of a large variety of tasks and initiatives regarding Quality
Previous experience working in an Agile environment
Excellent communication (written and verbal) and interpersonal skills.
Integrations with Data catalogs (business, functional, technical and operational)