What are the responsibilities and job description for the Database Architect position at Gonzer Associates, L. J.?
Configure database, including schema creation, schema management, table creation, user management, and security.-Develop and maintain documentation surrounding the governance standards of the database.-Design, develop, and maintain data pipelines using ETL tools and best practices.-Configure and maintain ETL tools to automate data flows.-Identify, troubleshoot, and solution any technical issues related to the data pipeline.-Build and maintain data warehouses and data marts specific to analytics needs.-Ensure data quality and consistency throughout the data pipeline.-Create detailed data maps and lineage diagrams.-Support the creation and maintenance of a data catalogue.-Maintain up-to-date data documentation.
- 5 years of experience in database administration, including schema creation, schema management, table creation, user management, and security.
- 5 years of experience in designing, developing, and maintaining data pipeline using ETL / ELT tools.
- 5 years of experience related to the creation and maintenance of data warehouses and / or datamarts specific to supporting data analytics.
- 3 years of experience creating and maintaining data mapping and documentation. Specifically creating detailed data maps and / or data lineage diagrams.
- 3 years of experience creating and maintaining technical data dictionary or data catalogue.
- 3 years of experience in ensuring data quality and consistency throughout the data pipeline.
- 2 years of experience with data integration and API development.
- Bachelor's Degree in Computer Science, Computer Engineering, or a related field.
- 2 years of experience working with Tableau Prep.
- 2 years of experience working with Oracle SQL Developer.
