Data Warehouse Architect - BI & ETL Leader

Arete Technologies, Inc.; Richmond (VA); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading technology services firm in Virginia seeks a Data Warehouse Developer to support Oracle Data Warehouse for business intelligence reporting. The ideal candidate will develop ETL scripts, analyze data issues, and ensure best practices in data integration. Applicants should have strong SQL and PL/SQL skills along with experience in data warehouse methodologies. This role requires collaboration in delivering BI solutions and maintaining optimal data processes.

Qualifications

• Proven experience with ETL processes and data integration projects.
• Ability to develop ETL scripts and write PL/SQL code from specifications.
• Familiarity with data model and dataflow diagrams.

Responsibilities

• Support development and maintenance of Oracle Data Warehouse.
• Gather business requirements and create technical designs.
• Review, analyze, modify, and create ETLs.
• Document technical needs for ETL processes.
• Deliver large data integration projects utilizing best practices.

Skills

Experienced SQL and PL/SQL development

Deep understanding of data warehouse and star schema

Performance tuning of ETL/SQL code

Ability to analyze and resolve production data issues

Unix shell scripting and job automation

Building BI dashboards using OBIEE

Job description

A leading technology services firm in Virginia seeks a Data Warehouse Developer to support Oracle Data Warehouse for business intelligence reporting. The ideal candidate will develop ETL scripts, analyze data issues, and ensure best practices in data integration. Applicants should have strong SQL and PL/SQL skills along with experience in data warehouse methodologies. This role requires collaboration in delivering BI solutions and maintaining optimal data processes.