Lead Database Developer

Govserviceshub; United States; On-site; USD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled Database Administrator to lead the development and management of data pipelines crucial for the NYS JC Data Strategy Initiative. This role demands extensive experience in database management and ETL processes, where you will configure databases, ensure data quality, and create detailed data maps. You will be instrumental in troubleshooting technical issues and developing documentation to uphold governance standards. If you are passionate about data integrity and excited to make a significant impact, this opportunity is perfect for you.

Qualifications

• 12+ years of experience in database management and ETL development.
• Strong technical skills in data pipeline configuration and troubleshooting.

Responsibilities

• Develop and manage data pipelines for the NYS JC Data Strategy Initiative.
• Configure databases and ensure data quality throughout the pipeline.

Skills

Database Management

ETL Development

Data Quality Assurance

Technical Support

Data Mapping

Tools

ETL Tools

Job description

Delmar, United States | Posted on 12/30/2024

Job Location: Delmar, NY 12054, 100% Onsite.

Mandatory Requirements:

1. Experience (12+ Years)

Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

Job Description:

This role will provide technical support developing and managing the data pipeline needed to support the primary objectives of the NYS JC Data Strategy Initiative.

Database Administration:

1. Configure database, including schema creation, schema management, table creation, user management, and security.
2. Develop and maintain documentation surrounding the governance standards of the database.
3. Design, develop, and maintain data pipelines using ETL tools and best practices.
4. Configure and maintain ETL tools to automate data flows.
5. Identify, troubleshoot, and solution any technical issues related to the data pipeline.
6. Build and maintain data warehouses and data marts specific to analytics needs.
7. Ensure data quality and consistency throughout the data pipeline.

Data Mapping and Documentation:

1. Create detailed data maps and lineage diagrams.
2. Support the creation and maintenance of a data catalogue.