JobRialto
Oracle Data Warehouse Architect
JobRialto, Dallas, Texas, United States, 75215
Job Summary:
We are seeking an experienced Oracle Data Warehouse Architect with expertise in Snowflake and analytics tools integration to design and maintain scalable data warehouse solutions. The role involves collaborating with business stakeholders to deliver robust data solutions while ensuring optimal performance, data quality, and compliance with governance standards.
Key Responsibilities:
• Design, develop, and maintain scalable data warehouse solutions using Oracle and Snowflake.
• Create and optimize logical and physical data models for data warehousing and analytics purposes.
• Develop, implement, and manage ETL processes for accurate and timely data integration.
• Monitor and optimize data warehouse performance to ensure high availability and scalability.
• Integrate data warehouse solutions with analytics tools like Oracle Analytics, Power BI, and Tableau.
• Implement data governance practices to ensure data quality, consistency, and security.
• Collaborate with business stakeholders and IT teams to understand data requirements and deliver solutions.
• Maintain comprehensive documentation of data architecture, models, processes, and configurations.
Required Qualifications:
• 7-10 years of experience in data warehousing and data architecture.
• Extensive experience with Oracle databases and Snowflake solutions.
• Proven expertise with ETL tools and processes.
• Strong background in integrating data warehouses with analytics tools such as Oracle Analytics, Power BI, and Tableau.
• Proficiency in SQL and PL/SQL.
• Deep understanding of data modeling concepts and best practices.
• Experience with cloud-based data warehousing solutions.
• Familiarity with big data technologies and frameworks (a plus).
• Excellent problem-solving, communication, and collaboration skills.
• Ability to work independently and within a team.
• Strong project management and organizational skills.
Location:
Dallas, TX
Education:
Bachelors Degree
We are seeking an experienced Oracle Data Warehouse Architect with expertise in Snowflake and analytics tools integration to design and maintain scalable data warehouse solutions. The role involves collaborating with business stakeholders to deliver robust data solutions while ensuring optimal performance, data quality, and compliance with governance standards.
Key Responsibilities:
• Design, develop, and maintain scalable data warehouse solutions using Oracle and Snowflake.
• Create and optimize logical and physical data models for data warehousing and analytics purposes.
• Develop, implement, and manage ETL processes for accurate and timely data integration.
• Monitor and optimize data warehouse performance to ensure high availability and scalability.
• Integrate data warehouse solutions with analytics tools like Oracle Analytics, Power BI, and Tableau.
• Implement data governance practices to ensure data quality, consistency, and security.
• Collaborate with business stakeholders and IT teams to understand data requirements and deliver solutions.
• Maintain comprehensive documentation of data architecture, models, processes, and configurations.
Required Qualifications:
• 7-10 years of experience in data warehousing and data architecture.
• Extensive experience with Oracle databases and Snowflake solutions.
• Proven expertise with ETL tools and processes.
• Strong background in integrating data warehouses with analytics tools such as Oracle Analytics, Power BI, and Tableau.
• Proficiency in SQL and PL/SQL.
• Deep understanding of data modeling concepts and best practices.
• Experience with cloud-based data warehousing solutions.
• Familiarity with big data technologies and frameworks (a plus).
• Excellent problem-solving, communication, and collaboration skills.
• Ability to work independently and within a team.
• Strong project management and organizational skills.
Location:
Dallas, TX
Education:
Bachelors Degree