About this Data Analyst role at Steamship Insurance Management Services Ltd
About the company
Steamship Mutual is a P&I insurance company, with 250 employees worldwide. The main office is based near Liverpool Street station, London. We have offices in Bermuda, Brazil, Cyprus, Greece, Hong Kong, New York and Japan, and Singapore.
Overall Job Purpose:
Reporting to the Data Manager, the Data Analyst will design, develop, migrate and support business reporting solutions as Steamship modernises its data and reporting platform. A major initial focus will be the transition from SAP Business Objects to Microsoft Fabric and Power BI, including the rationalisation and redevelopment of existing reports.
The role will work closely with business stakeholders, the Data Engineer, database specialists and third-party delivery partners to translate reporting requirements into accurate, maintainable and governed semantic models, Power BI reports, dashboards and paginated reports.
Requirements
- Semantic modelling: Build, extend and maintain governed Power BI semantic models using sound dimensional modelling principles, including hierarchies, reusable measures and business-friendly metadata.
- Power BI development: Design, build, test and maintain accessible, high-quality Power BI reports and dashboards.
- Paginated reporting: Develop parameterised, structured and print-ready Power BI paginated reports where fixed layouts and repeatable outputs are required.
- Business Objects migration: Review the purpose and usage of existing SAP Business Objects reports and migrate, redesign, consolidate, simplify or retire them according to verified business needs.
- Requirements analysis: Work with users and subject-matter experts to document business terminology, measures, filters, parameters and expected outputs.
- DAX development: Create accurate, efficient and maintainable DAX measures, including calculation logic and time-based calculations.
- Validation and reconciliation: Formally reconcile new reporting against legacy outputs and source data, investigate discrepancies and obtain business sign-off before replacing legacy reports.
- Reporting standards: Apply consistent standards for layout, navigation, visualisation, accessibility, naming and usability.
- Performance: Monitor and optimise reports, DAX measures and semantic models to provide an effective user experience.
- Security and governance: Ensure reports and semantic models follow agreed access, security, data protection and governance controls.
- Testing and release: Participate in peer review, testing and controlled promotion across development, UAT and production.
- Documentation: Maintain proportionate documentation covering reporting logic, business definitions, measures, model design, report purpose and support needs.
- Support and continuous improvement: Support production reporting, investigate issues, help users adopt Power BI and improve reports as business requirements and the platform evolve.
- Knowledge sharing: Share knowledge with colleagues and business users and contribute to a sustainable internal reporting capability.
Other
- Attend courses and seminars when required.
- Undertake business travel as and when required.
- Keep up to speed with industry best practices and trends.
Person Specification:
- Friendly, approachable, empathetic and sincere with excellent written and spoken communication skills.
- Flexible, dependable and willing to support colleagues to achieve shared objectives.
- Organised, attentive to detail and able to manage competing priorities effectively.
- Collaborative and customer-focused, with a commitment to continuous learning and improvement.
Essential Skills
- Experience designing, developing and supporting production Power BI reports and dashboards.
- Experience building and maintaining governed semantic models using dimensional modelling principles.
- Strong practical skills in DAX, SQL and data analysis.
- Ability to gather reporting requirements and translate them into effective technical solutions.
- Experience testing and reconciling reporting solutions to ensure accurate and reliable outputs.
- Ability to optimise report, model and calculation performance.
- Ability to produce clear documentation and maintain accessible reporting standards.
- Strong communication skills and the ability to work effectively with technical and non-technical stakeholders.
Desirable Skills
- Hands-on experience with Microsoft Fabric and Fabric semantic models.
- Experience developing Power BI paginated reports.
- Experience migrating reports from SAP Business Objects or another legacy BI platform.
- Experience with Power Query and data transformation.
- Understanding of Row-Level Security and enterprise BI security concepts.
- Experience with source-controlled or governed BI deployment processes.
Benefits
What you will get:
- Joining our collaborative, supportive and friendly working environment, you will enjoy a rewarding career with the opportunity to build on your existing skills and knowledge.
- We offer great work life balance initiatives, including competitive hybrid working policy.
- Clear and transparent career pathway – offering you continued support with enhancing your skills and creating employment development opportunities.
- We offer free educational access to the Protection & Indemnity Qualification, created by the International Group of P&I Clubs.
- An attractive benefits package which includes private healthcare.
- We also provide competitive health subsidy, and access to our comprehensive wellbeing and savings programme throughout the year, to create an environment that supports everyone’s mental and physical health.
Company Values
Mutuality - ensuring fairness amongst Club Members
Integrity - upholding high ethical, legal, and regulatory standards
Safety and Sustainability - contributing to safety of life at sea and the preservation of the environment.
Transparency - building strong relationships based on trust and open communication.
Excellence - enabling our people to realise their full potential as team members, industry experts, leaders, and managers.
Collaborative - embracing flexibility, diversity, and inclusivity.
**Steamship Insurance Management Services Ltd is committed to providing a great service to all our members. We pride ourselves on offering a people-centred culture that provides mutual respect and support for all our staff, and we welcome and encourage you to apply**