Oracle Data Warehouse Architect with Snowflake and Analytics Tools Expertise Job at Pharmatek Consulting Inc, Dallas, TX

UkFpL2x4WWZIY2RwbXZYTVFUMC95b3NB
  • Pharmatek Consulting Inc
  • Dallas, TX

Job Description

Oracle Data Warehouse Architect with Snowflake and Analytics Tools Expertise

Location – Dallas, TX (Onsite)

Experienced Oracle Data Warehouse Architect with Snowflake and Analytics Tools Expertise

Job Summary:

We are seeking an experienced Oracle Data Warehouse Architect with a strong background in Snowflake and various analytics tools. The ideal candidate will be responsible for architecting and designing data warehouse solutions that support our business intelligence and analytics needs. This role requires a deep understanding of data architecture and warehousing principles, data modeling, ETL processes, and proficiency in Oracle and Snowflake environments.

Key Responsibilities:

  • Data Warehouse Architecture: Design, develop, and maintain scalable data warehouse solutions using Oracle and Snowflake.
  • Data Modeling: Create and optimize logical and physical data models for data warehousing and analytics purposes.
  • ETL Processes: Develop, implement, and manage ETL processes to ensure accurate and timely data integration from various sources.
  • Performance Optimization: Monitor and optimize data warehouse performance, ensuring high availability and scalability.
  • Analytics Tools Integration: Integrate data warehouse solutions with various analytics tools (e.g., Oracle Analytics, Power BI, Tableau etc) to support business intelligence initiatives.
  • Data Governance: Implement data governance and best practices to ensure data quality, consistency, and security.
  • Collaboration: Work closely with business stakeholders, data analysts, and other IT teams to understand data requirements and deliver effective solutions.
  • Documentation: Maintain comprehensive documentation of data architecture, models, processes, and configurations.

Requirements

Experience:

  • Minimum of 7-10 years of experience in data warehousing and data architecture.
  • Extensive experience with Oracle databases and Snowflake data warehousing solutions.
  • Proven experience with ETL tools and processes.
  • Strong background in integrating data warehouses with analytics tools such as Oracle Analytics, Power BI, Tableau etc.

Technical Skills:

  • Proficient 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 is a plus.

Soft Skills:

  • Excellent problem-solving skills and attention to detail.
  • Strong communication and collaboration skills.
  • Ability to work independently and as part of a team.
  • Strong project management and organizational skills.

Job Tags

Contract work,

Similar Jobs

University of California San Francisco

Physician Assistant (Redwood City) | University of California San Francisco Job at University of California San Francisco

 ...Full-time Inpatient General Orthopaedic Physician Assistant position. This role will be split between our Parnassus and Mount Zion campuses...  ...will include Hand and Upper Extremity, Foot and Ankle, Sports Medicine, and potentially Trauma. This is a crucial position, supporting... 

JPMorgan Chase & Co.

Public Finance Associate - Western Region - Associate Job at JPMorgan Chase & Co.

 ...Job Description J.P Morgans Public Finance team is looking for experienced public finance associate candidates for positions in our San Francisco office to work with our Infrastructure Team We are looking for a candidate who can be adaptable, able to manage projects... 

The Garden Foundation

Special Education Coordinator Job at The Garden Foundation

 ...The Garden Foundation'sSpecial Education (Program) Coordinator ( Part- Time and Full Time available(20-40 hours per week) Salary (Full time at 40k)and Hourly ($18 per hour+)positions available Room for growth within the organization The Garden Foundation... 

Tufts Medicine

Specialist Job at Tufts Medicine

 ...role that typically requires little to no prior knowledge or experience, work is routine or follows standard procedures, work is closely...  ...data. Responsible for collecting and documenting in hospital registration system demographic and financial information for... 

Boston Services

Registered Nurse - Interventional Radiology (Nursing) - Interventional Radiology Job at Boston Services

 ...15Local Rate: $107Reporting to the IR Section Leader, the Radiology Staff Nurse will provide quality-nursing care to both in and out patients...  ...changes, and initiates appropriate nursing interventions.4.Recognizes, documents, and assists in the treatment of contrast...