Senior Database Architect for HMIS & Data Excellence

Greycell Labs Inc; Town of Cobleskill (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Greycell Labs Inc in Albany, NY is seeking a Backfill / Database Architect to upgrade and consolidate aged systems into a single HMIS. You will design, implement, maintain, and secure databases to ensure performance, reliability, and data integrity, collaborating with developers, analysts, and IT teams.

The role involves generating and distributing standard and complex reports and dashboards, maintaining detailed logs of data management activities, and aligning data operations with business

Qualifications

• Bachelor’s degree in a related field.
• 7 years of experience designing logical and physical database models.
• 7 years experience designing Oracle databases including triggers and packages.
• 7 years experience in ETL techniques and flagging any failures.
• 5 years experience with SSIS design and development.
• 5 years experience using SQL Reporting Services (SSRS).
• 5 years experience in SQL programming including writing complex queries utilizing JSON in Oracle.
• 3 years experience participating in meetings to understand data needs and maintain detailed logs of data management activities and issues.

Responsibilities

• Upgrade and consolidate aging systems into one comprehensive HMIS.
• Design, implement, maintain, and secure organization databases for performance, reliability, and data integrity.
• Collaborate with developers, analysts, and IT teams to support business operations and strategic initiatives.
• Generate and distribute standard and complex reports and dashboards.
• Maintain detailed logs of data management activities and issues.

Skills

Database modeling

SQL proficiency

Data integrity

Team collaboration

ETL design

Education

Bachelor's Degree

Tools

Oracle databases

SSIS

SSRS

SQL

JSON in Oracle

ETL

Job description

Greycell Labs Inc in Albany, NY is seeking a Backfill / Database Architect to upgrade and consolidate aged systems into a single HMIS. You will design, implement, maintain, and secure databases to ensure performance, reliability, and data integrity, collaborating with developers, analysts, and IT teams.

The role involves generating and distributing standard and complex reports and dashboards, maintaining detailed logs of data management activities, and aligning data operations with business