About the job
Join our dynamic team at joinmakropro as an Oracle Retail Analytics Data Warehouse Engineer. In this pivotal role, you will design, develop, and support robust analytics and reporting solutions for our retail data. We're seeking a candidate with a proven track record in Oracle Retail Analytics, OBIEE, BI Publisher, and Oracle Data Integrator, complemented by strong data engineering expertise.
Key Responsibilities:
1) Data Warehouse & Analytics:
- Architect, implement, and sustain Oracle Retail Analytics Data Warehouse solutions.
- Create and refine dimensional models including fact and dimension tables.
- Guarantee data integrity, consistency, and high performance.
2) ETL / Data Integration:
- Design and manage ETL pipelines utilizing Oracle Data Integrator (ODI).
- Seamlessly integrate data from various retail systems such as POS, merchandising, and supply chain.
- Enforce data quality standards and enhance ETL efficiency.
3) Reporting & BI:
- Construct insightful dashboards using Oracle Business Intelligence Enterprise Edition (OBIEE).
- Generate operational and management reports via BI Publisher (BIP).
- Convert business needs into actionable analytics solutions.
4) Data Engineering:
- Demonstrate strong SQL and PL/SQL skills for data transformation and optimization.
- Efficiently manage large datasets.
- Follow best practices for data modeling and query performance.
5) Operations & Support:
- Oversee data loads and reporting functions.
- Diagnose production issues and alleviate performance bottlenecks.
