Data Analytics Engineer (OBIEE, Power BI, SSRS, RI)

Job Descriptions:

To support the day-to-day operation, monitoring, and enhancement of Client's data analytics and reporting system, covering Oracle Retail Insights (RI), Customer Insights (CI), base and custom reports, Power BI and SSRS management reports, and OBIEE operational reports sourced from the Merchandising Foundation Cloud Service (MFCS), Customer Engagement Cloud Service (CECS), and Store Inventory Operations Cloud Service (SIOCS). The role monitors batch processing runs, investigates and resolves data load and integration issues, and carries out reconciliation checks between operational systems and analytics platforms. It also builds and maintains reports and handles user support requests, so that sales, inventory, and financial data are updated on time and accurate, giving the business reliable visibility for decision-making.

REQUIREMENTS:

• Bachelors degree in Computer Science, Information Systems, or a related field.
• 3-5 years of IT experience in data analytics/business intelligence, including hands-on experience with Oracle Retail Insights (RI), Customer Insights (CI), or similar platforms.
• Hands-on experience developing and supporting OBIEE, Power BI, and SSRS reports.
• Experience with Oracle Retail applications (MFCS, CECS, SIOCS, or similar) as source systems for analytics and reporting.
• Good understanding of ETL/batch processing, data integration, and data reconciliation practices.
• Strong working knowledge of SQL and relational databases (Oracle Database), sufficient to develop, test, and troubleshoot reports, queries, and data loads.
• Familiarity with data security, data governance, and compliance practices.

ESSENTIAL FUNCTIONS AND BASIC DUTIES

• Oracle Retail Insights and Customer Insights: support the configuration, administration, and day-to-day operation of Oracle Retail Insights (RI) and Customer Insights (CI), including developing and maintaining base and custom reports built on these platforms.
• Management reporting: develop, maintain, and support Power BI and SSRS reports used for management reporting across the business, in line with agreed requirements and report definitions.
• Operational reporting (OBIEE): develop, maintain, and support OBIEE operational reports sourced from the Merchandising Foundation Cloud Service (MFCS), Customer Engagement Cloud Service (CECS), and Store Inventory Operations Cloud Service (SIOCS).
• Batch processing: monitor scheduled batch jobs and data loads across all data analytics platforms, ensuring they run successfully and on time. Investigate and resolve failures, delays, or exceptions, and escalate to the IT Manager where needed.
• Data integrity: perform data validation and reconciliation checks between operational systems (MFCS, CECS, SIOCS, and other source systems) and the data analytics platforms, ensuring sales, inventory, and financial data are accurate and updated on time. Investigate and report discrepancies.
• Integration and automation: support and monitor integrations between data analytics platforms and upstream/downstream operational systems, working with relevant technical teams to troubleshoot and resolve integration issues.
• Data security and compliance: apply access control, data governance, and information security requirements for the data analytics system, including user access setup and periodic access reviews, in line with JFs policies.
• Patch and release management: assist with patching, upgrades, and configuration changes across RI, CI, OBIEE, Power BI, and SSRS environments, including testing and validation, in line with change-management procedures.
• Production support and escalation: provide L2 support for data analytics and reporting incidents and service requests, performing root-cause analysis and resolving within agreed SLAs. Escalate critical incidents to the IT Manager.
• Documentation and governance: maintain data models, report definitions, batch schedules, integration maps, and support procedures, and keep them current.
• Team support: guide and support the Support Associate(s) - Data Analytics, as required, including knowledge sharing and handling of escalated queries.
• Cross-functional collaboration: work with merchandising, finance, store operations, and other business teams to understand reporting needs and deliver fixes and enhancements, and keep the IT Manager informed of performance, risks, and improvement opportunities.