Business Intelligence Data Consultant

Reed Elsevier Philippines; Quezon City; Hybrid; PHP 550,000 - 850,000; Full time

Benefits offered by this job

Flexible hybrid work

IT equipment provided

HMO Day 1 coverage

Free dependents

Retirement package

Life and Accident Insurance

PTO and years-based increases

Merit increases

Training & certifications

Job summary

Reed Elsevier Philippines seeks a Business Intelligence Data Consultant I to join the DRV AD and DRV Actionable data team in Quezon City, building reports for carriers and sales reps from sources like DB360 and ADRC.

You will pull data from Essbase, validate against Power BI dashboards, and ensure timely delivery of analyses with strong documentation and quality checks.

Qualifications

• 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.

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.
• 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.
• 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.
• 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 KPIs related to 50 accounts accuracy, task completion, and adherence Quality standards and timeliness.

Skills

Power BI

SQL

MS Office

Data analysis

Attention to detail

Unix

Linux

XML

HPCC

Tools

Power BI

SQL

Excel

UNIX

Linux

XML

HPCC

Job description

Join us and enjoy benefits designed to help you thrive:

• Flexible hybrid work setup (1-2 days/month onsite reporting)
• IT Equipment provided
• HMO coverage starting from Day 1 for you and FOUR FREE dependents
• Attractive retirement package with company matching
• Life and Accident Insurance starting Day 1
• 24 Annual PTOs, additional 6 once you reach your 5th year with us
• Competitive benefits with annual merit increase and incentives
• Continuous improvement for our employees (workshops, certification programs, learning sessions, etc.)

Work Arrangement:

• Set-Up: Hybrid (1-2/month onsite reporting)
• Location: UP AyalaLand Technohub, Commonwealth, Quezon City

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.
• 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:

• 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.