Database Architect - Gonzer Associates, L. J.
Delmar, NY
About the Job
L.J. Gonzer Associates is looking for individuals to join our pool of qualified candidates for potential assignment as a Database Architect. Responsibilities will include:
- 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.
Source : Gonzer Associates, L. J.