100% Remote Oracle Data Warehouse Architect || Must have LinkedIN
About The Position
The Oracle Data Warehouse Architect designs, develops, and maintains scalable Oracle-based data warehouse solutions that support business intelligence and analytics needs. The role covers data architecture and modeling, ETL processes, performance optimization, analytics-tool integration, and data governance. The architect collaborates with business stakeholders, data analysts, and IT teams to understand requirements and deliver practical solutions, while maintaining documentation of architecture, models, ETL processes, and system configurations. Snowflake experience is a plus but is not required.
Requirements
- 7–10 years of experience in data warehousing and data architecture.
- Extensive expertise with Oracle databases and tools, including Oracle Analytics.
- Proven experience designing and managing ETL processes.
- Experience integrating data warehouses with analytics platforms such as Oracle Analytics, Power BI, or Tableau.
- Proficiency in SQL and PL/SQL.
- Deep knowledge of data modeling concepts, tools, and best practices.
- Experience with cloud-based and on-premise Oracle solutions.
Nice To Haves
- Experience with Snowflake.
- Familiarity with big data technologies and frameworks.
Responsibilities
- Design, develop, and maintain robust, scalable data warehouse solutions primarily using Oracle.
- Develop and optimize logical and physical data models for data warehousing and analytics.
- Build, implement, and manage ETL processes to integrate data accurately and on time from various sources.
- Monitor and tune Oracle data warehouse performance to support high availability and scalability.
- Integrate data warehouses with analytics tools such as Oracle Analytics, Power BI, and Tableau.
- Establish and enforce data governance practices to support data quality, consistency, and security.
- Collaborate with business stakeholders, data analysts, and IT teams to understand requirements and deliver solutions.
- Document data architecture, data models, ETL processes, and system configurations.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
