Were searching for a Data Architect to join our team and play a crucial role in elevating the quality of data within our inhouse application databases. This is your chance to make a real impact by ensuring seamless data flow and empowering informed decisionmaking 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.Our goal is to update our platforms to contain high data quality before being loaded into our ELT data engineering pipelines.
Responsibilities:
- Work with inhouse 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 crossfunctional 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
Requirements
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
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