Data Warehouse Architect (Oracle OBIEE / Informatica / Healthcare Analytics)

Maagsoft Inc.
Albany, United States of America
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Albany, United States of America

Tech stack

Data analysis
Application Integration Architecture
Health Informatics
Computer Programming
Data Governance
Data Integrity
ETL
Data Mart
Data Migration
Data Warehousing
Relational Databases
Database Design
Oracle Business Intelligence Enterprise Edition
Oracle Applications
Performance Tuning
System Availability
Data Analytics
Star Schema

Job description

Requested Qualifications:84 Months Experience developing and maintaining logical and physical dimensional data models, including star schema, snowflake schema, and data migration strategies in enterprise data warehouse and business intelligence environments.

Requirements

84 Months Experience using data modeling tools (e.g., Erwin) for data model design, documentation, and review to ensure compliance with enterprise data standards and development best practices. 84 Months Experience in relational data management, database design, and development using Oracle technologies, including advanced SQL programming for data analysis, optimization, and reporting in data warehouse environments. 72 months of experience supporting healthcare analytics environments, including maintenance and troubleshooting of OBIEE reporting solutions and ETL processes to ensure data availability, accuracy, and business continuity. 48 Months Experience in designing enterprise data integration architecture using Informatica, including implementing best practices and mentoring team members for data warehouse and reporting solutions. 48 Months Experience participating in business analysis and requirements gathering sessions, including translating business requirements into data and reporting requirements. 48 months of experience using business intelligence tools (e.g., OBIEE 11g) to support data analytics, reporting, and enterprise decision-support solutions. 24 Months Experience designing and implementing enterprise OBIEE dashboards and reports, including repository (RPD) development, metadata modeling, and performance tuning for high-volume data mart environments. 24 Months Experience establishing and enforcing enterprise data governance, lineage, and data quality frameworks to ensure data integrity, compliance, and reliable reporting across data marts and reporting environments. Bachelor's degree in IT field Required Documentation: Resume Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) Thanks & Regards.

Apply for this position