Director of Business Intelligence at Highmark Health providing strategic leadership in BI initiatives. Collaborating with stakeholders to optimize data infrastructure and reporting technologies.
About the role
- Data & Reporting Analyst role at Mercer handling data intake, validation, and reporting for Carrier Relations Team initiatives. Seeking a mid-level candidate with strong Excel skills and experience in analytics.
Responsibilities
- Manage intake of carrier files: receive, validate, transform and load into MarketInSight workflows.
- Support Carrier Survey: help clean, reconcile, and initial analysis on responses.
- Administer Supplemental Compensation Opt-out, disclosure, and exception processes.
- Act as the initiative coordinator for projects assigned by Carrier Relations to GSD – prioritizing tasks, keep stakeholders informed with status reports, and organize meetings.
- Provide analytic support for supplemental compensation tasks (prep, reconciliation, summary tables).
- Perform data quality assurance: automated and manual checks, field-level validation, reconciliation to prior periods.
- Format data and deliver reports to set presentation standards and templates.
- Maintain and update SOPs, document process changes and runbooks.
- Work with carrier relations and US-based colleagues to triage problems and propose fixes.
- Organize data for recurring reporting so senior staff can focus on insights, not cleaning.
- Apply basic data modeling and storage best practices under guidance to protect reporting integrity.
Requirements
- Graduate with minimum 8 years of work experience
- 3–5 years analytics/data role experience (insurance/benefits preferred)
- Advanced MS Excel skills and experience handling large datasets in Excel: advanced formulas, pivot tables, Power Query, VBA/macros
- Strong data QA, reconciliation and attention to detail
- Clear written and spoken English; can communicate issues and SOPs to US stakeholders
- Problem-solver mindset; can propose practical solutions and follow through
- Self-initiator who can proactively identify any concerns and make suggestions for resolution in a timely manner
- Basic SQL (ability to run simple queries) - nice to have
- Exposure to Power BI/Tableau/Qlik or Python/pandas - nice to have
- Prior experience working with carrier data or surveys - nice to have
- Familiarity with project management applications, Smartsheet, and Vizio - nice to have
Benefits
- Professional development opportunities
- Flexible work arrangements
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Financial Reporting Analyst supporting investment activities at Manulife Investment Management. Responsible for operational and financial reporting across various investment programs.
Senior Financial Reporting Analyst providing operational support to investment teams at Manulife. Handling financial reporting requirements and ensuring compliance and accuracy in investment operations.
Senior Business Insights Analyst at Manulife transforming data sources into actionable insights. Developing dashboards and reporting structures to inform strategic initiatives and enhance operational efficiency.
Develop and maintain Power BI dashboards and reports. Collaborate with Operations and Data Engineering to standardize metrics, ensure data quality and support data - driven decisions.
Business Intelligence & Research role at HPE focused on leveraging advanced analytics for informed decision - making. Manage strategic supply chain models and lead initiatives to enhance operations.
Senior analyst in Business Intelligence building and maintaining data layers for better business decision - making. Collaborating with a tech - savvy team in a hybrid work environment.
L(
Director of IT Applications Development and Business Intelligence at LISC, a major community development organization. Leading enterprise application strategies and modernization initiatives while ensuring alignment with business goals.
Business Insights Analyst conducting analyses and deriving insights for business growth at TD. Collaborating with various functional areas to provide analytics and support business strategy.
Business Intelligence Specialist managing a diverse portfolio of business reporting and analytics for TD. Collaborates with senior leadership to design presentations and streamline reporting processes.