Define the analytical data architecture principles, standards and guidelines and put controls in place to ensure these are followed
Have an in-depth knowledge of physical data modeling approaches including but not limited to kimball
Have experience of developing and managing conceptual, logical and physical data models
Critically assess the performance, scalability, access, governance etc. of the data architecture and put key indicators in place to monitor
Continuously review current data modeling principles and initiate any improvements to enable the implementation of the intended architecture
Create a shared understanding between the business teams and the data teams
Review and improve the data system as a whole, inclusive of data model designs, process flows, and end use cases
Have a strong understanding of building a compliant and secure data warehouse
Have a strong understanding of data access and control strategies
Applying knowledge of best data architecture practice and architecture documentation to manage current state of architecture and manage implementation of future state
Collaborate with people in the business to collect business requirements, design the conceptual and logical data models
Create automated governance processes that assures adoption, monitors and enforces the adoption of best practices in data architecture
Monitor the usage of the data warehouse and identify areas for improvement
Update key stakeholders on any changes to the data architecture
Approve key data model changes as a Reviewer and code owner for database and data model schemas
Contribute towards the Data Catalog, a scalable resource to support Self-Service and Single-source-of-truth analytics
Lead governance projects related to the architecture
Ensuring the most appropriate security and compliance practices are embedded in the data architectural strategy
Knowledge of the various data architectures that can be implemented (Warehouse, Lakehouse, Data Mesh, Data Fabric, Data Vault etc.)
Knowledge of the various types of physical data modeling approaches including kimball
Have led the strategy and implementation of a data architecture in a previous role
Bachelor’s or Master’s degree in technical discipline; Master’s preferred
Ability to thrive in a fully remote organization
Positive and solution-oriented mindset
Comfort working in a highly agile, intensely iterative environment
Self-motivated and self-managing, with task organizational skills
Great communication: Regularly achieve consensus amongst technical and business teams
Demonstrated capacity to clearly and concisely communicate complex business activities, technical requirements, and recommendations
3+ years managing the same data model system over time, evolving the model to meet new business requirements
Experience working with commercial data warehouses, ETL tools, data visualization and Data Dictionary tools (Redshift, Meltano, Dbt & Python scripts, Thoughtspot, Looker, Tableau, HEX, Atlan)
Demonstrated experience leading 2 or more multi-department analytics projects from inception to operationalization
Demonstrated proficiency with data system design, including databases, schema, marts, aggregates, and views
Experience with data access and security techniques, both inside and outside of a data warehouse
Experience with data pipelines in support of near real-time event stream processing
Created and presented multi-quarter development roadmaps to non-technical audiences