Business Intelligence Data Consultant I

RELX; Quezon City; On-site; PHP 800,000 - 1,000,000; Full time

Job summary

RELX is seeking a Business Intelligence Data Consultant I to collaborate with the REPH DRV AD and DRV Actionable data teams (Alpharetta) on reports and studies for customers and sales reps. You will pull data from Essbase and PowerBI, respond to seller requests, and ensure timely submission of reports.

The role emphasizes data extraction, analysis, and documentation with a focus on quality and process improvements, while supporting operational excellence initiatives across multiple data sources.

Qualifications

• Bachelor's degree required or equivalent
• Experience with data analytics and reporting
• Proficiency in Power BI and SQL
• Familiarity with Essbase and data extraction
• Attention to detail and ability to work with large datasets
• Ability to learn and apply enterprise AI tools

Responsibilities

• Extract and validate data from Essbase vs PowerBI dashboards
• Provide data analysis and research support for stakeholders
• Run data statistics, coverage stats, and profile data
• Create data documentation including mappings and quality thresholds
• Investigate and report data issues and ensure timely corrections
• Document data processes and maintain quality standards

Skills

Data analysis

Power BI

SQL

Excel

Attention to detail

Python basics

Communication

Teamwork

Education

Bachelor's degree

Tools

Essbase

SQL scripting

UNIX

Linux

XML

Job description

The Business Intelligence Data Consultant I works with REPH DRV AD and DRV Actionable data (Alpharetta) team in creating and completing Reports and Studies for our Customers (Carriers) and Sales Reps base from the following sources: DB360 Blindspot report, ADRC, Harnessing the power of DB360 report.

Core tasks are composed of (but not limited to): Pulling data from Essbase, Responding and reacting to Sellers requests and queries, pulling data from and to PowerBI dashboard, Peer to peer audit and ensuring that reports are submitted on a timely manner.

Core Responsibilities

• Data Extraction, Data validation from Essbase vs PowerBI dashboard Data.
• Business support through data analysis and research.
• Independently run data statistics, including coverage stats, field populations, etc.
• Run data profiles.
• Complete new data evaluations for diverse audiences.
• Create data documentation including mappings and quality thresholds.
• Investigate, track, and report data issues.
• Conducts data review and verification and ensures corrections/clarifications are made in a timely manner.
• Provide clear documentation for data and processes performed.

Process Improvement & Best Practices

• Communicate information effectively through written statements or suggestions.
• Assist in enhancing methodologies for test planning, execution, defect tracking, and reporting.
• Participate in Operational Excellence (OPEX) initiatives.

Compliance & Quality Assurance

• Support process improvement and compliance initiatives to ensure consistent delivery of high-quality products.
• Adhere to QA and Operation standards and procedures to maintain quality benchmarks.
• Escalate issues and decisions to Supervisor or BU counterpart when necessary.
• Meet key performance indicators (KPIs) related to 50 accounts accuracy, task completion, and adherence Quality standards and timeliness.

Flexibility & Adaptability

• Perform other duties as assigned, demonstrating adaptability in a dynamic and fast-paced environment.
• Show initiative in learning new tools, systems, and processes to support team goals.

Qualifications

• Bachelor's Degree holder
• Any professional data qualification/accreditation is preferred but not required – Python,
• Able to demonstrate a nuanced understanding and experience of the difference between online panel research and other types of online quantitative research.
• Insurance knowledge or industry experience a plus
• Proficient in Microsoft Office
• Analytical and creative thinking while adhering to established process guidelines
• Strong attention to detail with the ability to spot discrepancies, missing information, errors, trends and areas of concern
• Proficient knowledge in computer, operating systems, basic programming and testing concepts
• PowerBi technical knowledge (end-user capability).
• Proficiency with various data types and formats including, but not limited to: XML, flat files, delimited, etc.
• Proficiency with development languages such as SQL, UNIX, Linux, XML, HPCC, etc. a plus
• Flexibility and adaptability to changes in workloads, requirements and stakeholder or management direction
• Work in collaborative environment
• Must not have any pending/ active disciplinary action, attendance, and performance issues in the past 12 months for internal applicants
• Ability to quickly learn and apply enterprise AI tools and technologies to support technical workflows and business objectives.

We know your well-being and happiness are key to a long and successful career. We are delighted to offer country specific benefits. Click here to access benefits specific to your location.