Data Warehouse Architect

Overview

On Site
Depends on Experience
Full Time
No Travel Required

Skills

Data Warehouse
OCI
ETL
SAP BI Reports

Job Details

Miracle Software Systems Inc is looking for Data Warehouse Architect position at Audubon, PA. Please find the below Job details

Requirement Details:
Position: Data Warehouse Architect
Location: Audubon, PA
Duration: Longterm
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.

Miracle Software Systems, Inc. is a Global System Integrator; a Technology Solution Provider headquartered in Novi, MI. Established in 1994, Miracle has over 30 years of history helping Fortune 1000 companies through Business Transformation Initiatives with innovative technology Products and Solutions driven by Data Science and Analytics, Enterprise Cloud, Mobility, Virtual Reality, Digital Experience, Machine Learning, AI, Enterprise Application Integration and more. We are a Premier Partner of IBM and a National Implementation Partner of SAP. Miracle s team spans four continents and includes 2000 IT Professionals working across the globe, our teams run on the core principles of Quality Delivery, Thought Leadership and Affordable Innovation

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.