Business Intelligence Data Consultant

Hammerjack Pty Ltd; Philippines; Hybrid; PHP 400,000 - 650,000; Full time

Benefits offered by this job

Hybrid work setup

IT Equipment provided

HMO coverage Day 1 for you and four+4*

Retirement package with company match

Life and Accident Insurance Day 1

Annual PTO 24 days + 6 days after 5th年

Incentives and merit increases

Training and certification programs

Job summary

Hammerjack Pty Ltd in the Philippines seeks a Business Intelligence Data Consultant I to join the REPH DRV AD and DRV Actionable data teams in Alpharetta, delivering reports for customers and sales reps from DB360/ADRC sources.

You will pull data from Essbase, work with PowerBi dashboards, and ensure timely delivery. Strong SQL/Unix/Linux/XML skills and attention to detail are essential for accuracy.

Qualifications

• Bachelor's degree required.
• 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 ability to spot discrepancies, missing information, errors, trends.

Responsibilities

• Data Extraction and validation from Essbase vs PowerBi dashboard.
• Business support through data analysis and research.
• Independently run data statistics, including coverage stats and field populations.
• Create data documentation including mappings and quality thresholds.
• Investigate, track, and report data issues.
• Provide clear documentation for data and processes performed.

Skills

Analytical thinking

Attention to detail

Data analysis

Microsoft Office

Education

Bachelor's Degree

Tools

PowerBi

SQL

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