Apply Now

Database Architect

Albany, NY, US • Posted 1 day ago • Updated 1 day ago

Full Time

No Travel Required

On-site

$70 - $85/hr

Bits & Bytes Technology Solutions

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

Data Warehouse
Database Architecture
Database
Dimensional Modeling
Data Management
Access Control
Auditing
Collaboration
Computer Hardware
Computer Science
Billing
Business Intelligence
Cloud Computing
Informatica Powercenter Etl
Information Technology
Informatica Administration
Informatica PowerCenter
Finance
HIPAA
HP-UX
Health Care
Data Dictionary
ER/Studio
Extract, Transform, Load
Migration
OBIEE
Operating Systems
Meta-data Management
Microsoft Power BI
Microsoft SQL Server
FTP
Informatica
Team Leadership
Telecommuting
Payroll
Pharmacy
Science
Scripting
Linux
Medicaid
Optimization
Oracle
PEARL
Star Schema
Unix
Workflow

Data Warehouse
Database Architecture
Database
Dimensional Modeling
Data Management
Access Control
Auditing
Collaboration
Computer Hardware
Computer Science
Billing
Business Intelligence
Cloud Computing
Informatica Powercenter Etl
Information Technology
Informatica Administration
Informatica PowerCenter
Finance
HIPAA
HP-UX
Health Care
Data Dictionary
ER/Studio
Extract, Transform, Load
Migration
OBIEE
Operating Systems
Meta-data Management
Microsoft Power BI
Microsoft SQL Server
FTP
Informatica
Team Leadership
Telecommuting
Payroll
Pharmacy
Science
Scripting
Linux
Medicaid
Optimization
Oracle
PEARL
Star Schema
Unix
Workflow

Summary

Job Title & Skill Level: Database Architect (Expert)
Agency: Office of Information Technology Services (ITS) / Office of Mental Health (OMH)
Request ID: HBITS-08-15032
Project Name: Enterprise Data Warehouse and various Health Cluster projects within OMH
Number of Positions: 1
Target Start Date: 11/17/2026
Engagement Length: 30 monthsLocation & Telecommuting: Located at 800 N. Pearl Street, Albany, NY 12204 (Home Base Region 1). Telecommuting is allowed up to 50%.
Interview Format: Webcasting (candidate is required to be on camera).

Role Description & Responsibilities

Primary Objective: Support the OMH Data Warehouse using Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC) for ETL processes, administration, and the redesign and implementation of current and future OMH projects.
Day-to-Day Tasks:

Analyze and translate patient health data business requirements (such as admission, discharge, census, financial, billing, HR, payroll, Medicaid, and pharmacy data) into complex ETL code.
Participate in data warehouse design and architecture planning using Kimball methodologies (Star schema design and dimensional data modeling).
Collaborate with developers as a team lead in designing Informatica PowerCenter ETL and database architecture.
Extract and interpret Informatica Metadata repository data.
Implement Fine Grain Access Control Audit (FGACA) to protect healthcare data like Medicaid, pharmacy, and HIPAA Protected Health Information (PHI).
Analyze and code complex UNIX scripts to validate and FTP files, and monitor Informatica workflows.
Perform Informatica Administration, including installation, patching, and deployment of ETL code across platforms.

Software & Hardware: Typically uses Oracle, Informatica PowerCenter and IDMC, ER Studio, PowerBI, OBIEE, SQL Server, HP-UX, and Linux.

Qualifications & Requirements

Experience Requirements:

120 months of experience using Informatica PowerCenter 10.5.x or higher and IDMC in a data warehouse environment.
120 months of experience with Informatica PowerCenter and IDMC administration (installation, patching, metadata analysis, code migration, repository optimization).
120 months of experience analyzing and converting heterogeneous health systems data into complex ETL code.
120 months of experience in relational data management and Oracle technologies, including designing and implementing Oracle VPD and FGACA in an Enterprise Data Warehouse.
120 months of experience working with UNIX and/or Linux operating systems.
120 months of experience collaborating with developers as a team lead in designing Powercenter ETL and database architecture.

Preferred Education:

Bachelor’s degree in computer science, business intelligence, information science, or a related field.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10324752
Position Id: 15032
Posted 1 day ago

Company Info

About Bits & Bytes Technology Solutions

At Bits & Bytes, we believe IT and ITES to be a conduit for a better business environment, both for humanity at a macro level and financial sheets at a micro level.

Based on confidence and trust, we've built valuable long-term relationships with our customers. Our demonstrated performance in technology fields has fostered these relationships, as has our industry specific expertise, product knowledge, and proven consulting and project management methodologies for every consumer and engagement.

Go to company profile

Contact the job poster

Sharad Srivastava

Recruiter @ Bits & Bytes Technology Solutions

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Engineer

New York, New York

•

Yesterday

Position OverviewPosition Title: IT Specialist (Expert)Agency: Department of Financial Services (DFS)Location: 1 State St, New York, NY 10004Engagement Length: 30 monthsTelecommuting: Allowed up to 50%, at the discretion of the hiring manager.Short DescriptionThe Department of Financial Services is looking for a technical expert to build data workflows, validate financial data, and enforce data quality. You will actively engineer data solutions, automate manual reporting, and query datasets to s

Easy Apply

Full-time, Third Party

65 - 78

Search all similar jobs

More jobs at Bits & Bytes Technology Solutions in Albany, NY