Expert Database Architect

Hybrid in Albany, NY, US • Posted 1 day ago • Updated 1 day ago
Contract W2
Contract Independent
30 Months
No Travel Required
Hybrid
$75 - $80/hr
Fitment

Dice Job Match Score™

⏳ Almost there, hang tight...

Job Details

Skills

  • Data Modeling
  • Data Migration
  • ERwin
  • SQL
  • Oracle
  • OBIEE

Summary

Introduction:

This is primarily a Data Modeler position focused on designing, developing, and maintaining enterprise data models to support analytics and reporting needs. In addition, the resource will serve as backup support for OBIEE and ETL processes, assisting with troubleshooting, production support, and issue resolution as needed.

Responsibilities:

  • Perform data analysis of current and future systems to support ongoing and future data needs.
  • Collaborate with customers, vendors, and technical teams to gather requirements and prioritize reporting needs.
  • Design and maintain enterprise data architecture, including conceptual, logical, and physical data models.
  • Define and enforce data standards, naming conventions, governance practices, and ensure data quality and consistency.
  • Develop and maintain documentation of business processes, workflows, and data flows.
  • Optimize ETL processes and mappings for data migration.
  • Design and support reporting solutions, including dashboards, aligned with end-user requirements.
  • Monitor and optimize database performance through query tuning and indexing.
  • Implement and maintain database security, access controls, and auditing.
  • Evaluate implementation strategies, identify risks and issues, and support resolution planning.
  • Provide technical guidance, conduct design reviews, mentor team members, and support release planning.
  • Facilitate and document meetings, support reporting development discussions, and ensure proper tracking of outcomes.

Requirements:

  • 84 Months Experience developing and maintaining logical and physical dimensional data models in enterprise data warehouse and business intelligence environments.
  • 84 Months Experience using data modeling tools (e.g., Erwin) for data model design and documentation.
  • 84 Months Experience in relational data management, database design, and development using Oracle technologies.
  • 72 months of experience supporting healthcare analytics environments, including maintenance of OBIEE reporting solutions and ETL processes.
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: 91174515
  • Position Id: 9025372
  • Posted 1 day ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Albany, New York

Yesterday

Easy Apply

Contract, Third Party

Depends on Experience

Menands, New York

Today

Full-time

Menands, New York

Yesterday

Easy Apply

Contract, Third Party

65 - 75

Menands, New York

Today

Third Party, Contract

DOE

Search all similar jobs