Data Warehouse Architect

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 6 Month(s)
No Travel Required

Skills

Oracle Cloud Infrastructure (OCI)
ETL/ELT
SAP BI
ERP systems

Job Details

Miracle Software Systems, Inc., are actively looking for Data Warehouse Architect position at Audubon, PA.

Requirement Details:

Data Warehouse Architect Audubon, PA 6 Months (2-3 days Onsite)

Description: Data Warehouse Architect to lead the design and development of a scalable enterprise data warehouse platform on Oracle Cloud Infrastructure (OCI). The ideal candidate will bring deep expertise in data modeling, ERP data integration, and analytics modernization, with the ability to guide and train technical teams through implementation and best practices.

Key Responsibilities:
Architect, design, and implement a data warehouse solution on OCI, ensuring performance, scalability, and data integrity.
Lead the migration of SAP BI reports to modern analytics environments, such as Looker or equivalent BI platforms.
Design and optimize data models that enable efficient analytics and reporting across ERP systems (Oracle and SAP).
Define and establish ETL/ELT pipelines, data flows, and integration frameworks supporting enterprise analytics.
Collaborate with business and IT stakeholders to translate data requirements into scalable technical solutions.
Provide technical mentorship and training to the development and analytics team on architecture, modeling, and governance standards.
Work onsite (2 3 days per week) to align with cross-functional teams, ensure smooth implementation, and troubleshoot complex data challenges.

Required Skills & Experience:
10+ years of experience in Data Warehousing, Data Architecture, and Enterprise Analytics.
Strong hands-on experience with Oracle Cloud Infrastructure (OCI) particularly in designing and deploying Data Warehouse platforms.
Proven expertise in data modeling (conceptual, logical, and physical) for analytical workloads.
Experience with ERP data sources, including Oracle-based ERP systems and SAP BI report migration.
Proficiency with Looker dashboards or similar BI tools for enterprise reporting.
Solid understanding of ETL/ELT processes, data governance, and metadata management.
Excellent communication and team leadership skills with ablity to train and upskill technical teams effectively.

Nice-to-Have:
Exposure to modern cloud data platforms (e.g., Snowflake, Databricks, or Azure Synapse).
Experience with Oracle Autonomous Data Warehouse or Oracle Analytics Cloud.
Familiarity with Agile methodologies and DevOps principles in data environments.

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.