DATA ARCHITECT

We're searching for a Data Architect to join our team and play a crucial role in elevating the quality of data within our in-house application databases.
This is your chance to make a real impact by ensuring seamless data flow and empowering informed decision-making across the organization.
You will be responsible to work with database owners/stewards to learn and collect the semantics of the databases and help them with data quality and data modeling.
ur goal is to update our platforms to contain high data quality before being loaded into our ELT data engineering pipelines.
Responsibilities.
Work with in-house application Data Stewards lead the Data Contract process Work with existing systems / application owners to optimize existing databases with referential integrity and triggers to maintain consistency and data quality Guide Data Stewards to create database documentation that goes into the Data Catalog Collaborate with stakeholders to understand business requirements of new systems and design database models that meet those requirements Work with cross-functional teams to identify and address database related issues Collaborate with developers to optimize database performance and query optimization Define database design guidelines to help application designers Contribute to the development of technical documentation and guidelines to define the system components, development environment and implementation planning/strategies Stay current with new database technologies and incorporate them into development projects as appropriate Requisitos Expertise & Skills.
OLTP relational modeling and schema design expertise is a must SQL query optimization is a must OLAP dimension modeling experience is a plus Writing dbt models and Airflow DAGS a plus Bachelor’s or master’s degree in Computer Science, Information Technology, or a related field 5 years of relevant experience 5 years of experience in database architecture, design and modeling Proficiency in English is a must