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

Evara Group

Data Entry Operator - (Work From Home Online) - Immediate Start Job at Evara Group

About the job Work From Home Remote Data Entry Operator The Data Entry Operator enters data from images into the data capture system. Inputs Appropriate data in prescribed format, utilizing basic knowledge of computer software or system. Cross References data to...

Adjective & Co.

Account Management Intern - Client Focused Job at Adjective & Co.

 ...specialize in brand strategy, brand identity and design, advertising, digital, social media, and...  ...for a sharp, adaptable, and proactive intern to join our Account Management team. This...  ...). Do your research, bring your A-game, and show us why you're the perfect fit.... 

Envision, Inc.

District Manager - Inside Sales Job at Envision, Inc.

 ...Extremely self-motivated. Supported by an exceptional team with a high level of autonomy. Disciplined approach to daily time management to maximize sales activity. Successful candidates will be winners by nature, enjoy a metric driven environment, and be completely... 

Foxconn Assembly LLC

Senior Tax Manager Job at Foxconn Assembly LLC

 ...inbound tax planning for large-scale foreign-invested companies in the US. Familiarity with international tax regulations and transfer pricing. Experience with tax technology tools and software. Reasons you should work at Foxconn ~ Comprehensive benefits... 

US Ghost Adventures

Comedy Writer Job at US Ghost Adventures

 ...Job Description We're looking for a Comedy Writer with a quick wit and a scroll-stopping sense of humor to join our creative team. You'll help us develop funny, fresh content for our social media channelsincluding memes, short scripts, captions, and general content...