Softwareentwickler in Business Intelligence bei MID, Nürnberg oder Home Office. Entwicklung von Datenbanken, Datenaufbereitung und Implementierung von BI - Lösungen.
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
Softwareentwickler:in für Business Intelligence bei MID in Nürnberg. Verantwortlich für Softwareentwicklung, Datenbanken und Datenaufbereitungsprozesse mit einem agilen Team.
Business Intelligence Lead harnessing data insights to optimize marketing effectiveness and customer engagement at Medisca. Working collaboratively across departments to support strategic decision - making.
Business Intelligence Senior Analyst providing data insights and analytics for decision - making in a talent lifecycle context. Collaborating with stakeholders to deliver effective reporting and analysis.
Financial Reporting Analyst at City of Hamilton, overseeing accounting and reporting functions. Collaborate with departments to ensure financial compliance and accurate reporting.
BI Analytics Intern building analytics systems for Bedrock Data. Involved in Salesforce analytics, data insights and collaboration with finance and sales teams.
Business intelligence role supporting data analysis at a global digital marketing agency. Responsibilities include data visualization and technical support for users in the team.
Power BI Analyst developing and maintaining dashboards for U.S. Customs and Border Protection. Supporting decision - making and performance reporting with analytics and insights.
Financial Reporting Analyst preparing and reviewing financial reports in compliance with regulations. Analyzing data and collaborating with stakeholders to support business decisions.
BI Program Manager driving analytics delivery and governance at TDCX. Supporting global teams and clients in the analytics platform using AI - powered insights.