companyArete Technologies, Inc. logo

Data Warehouse Architect

On-site Contract

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Unlock Your Potential

Generate Job-Optimized Resume

One Click And Our AI Optimizes Your Resume to Match The Job Description.

Is Your Resume Optimized For This Role?

Find Out If You're Highlighting The Right Skills And Fix What's Missing

Experience Level

Mid to Senior

Qualifications

Local candidates will be prioritized.

About the job

Join our team as a Data Warehouse Architect, where you will play a key role in the development and maintenance of our Oracle Data Warehouse, facilitating OBIEE and BIP reporting tools for ABC.

You will be responsible for delivering crucial business intelligence information across the organization, leveraging your expertise in Data Warehousing and Business Intelligence development and implementation. Your responsibilities will include gathering business requirements and creating technical designs.

This role involves designing, developing, and supporting new and existing ETL processes, adhering to industry standards and best practices to enhance data loading from various source and target systems. You will provide vital support to meet the business requirements in the application and utilization of information from the Data Warehouse.

As part of the team, you will review, analyze, modify, and create ETL processes, performing testing, debugging, integration, and implementation tasks. Responsibilities also encompass documenting technical requirements for ETL processes and databases, ensuring optimal technical infrastructure is utilized.

This position requires the execution of large-scale data integration projects, necessitating the application of best practices, expertise, and technology know-how during implementation.

Key Responsibilities:

  • Proficient SQL and PL/SQL developer on the Oracle database platform.
  • In-depth understanding of data warehousing and star schema design.
  • Develop ETL scripts and write PL/SQL code based on data models, data flow diagrams, and technical design specifications.
  • Ability to manage a wide range of development needs, from simple to complex queries and multidimensional analysis.
  • Adhere to best coding standards and practices.
  • Expert in performance tuning of ETL and SQL code.
  • Analyze and resolve production data issues effectively.
  • Familiarity with Unix shell scripting and job automation.
  • Build and implement BI dashboards and analyses using OBIEE.
  • Generate reports utilizing BI Publisher.

About Arete Technologies, Inc.

Arete Technologies, Inc. delivers a range of innovative consulting and outsourcing services, bridging the gap between the requirements and outputs of adept companies worldwide. We focus on delivering exceptional services while providing cost-effective solutions to our clients. Understanding the current business landscape, we aim to offer world-class services that enable organizations to thrive while maintaining a healthy work-life balance. Our global delivery model is designed to provide seamless solutions for all workforce needs, supported by our team's extensive experience of over 30 years in the IT consulting and staffing industry.

Similar jobs

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.