Business Intelligence Developer II

Established nearly two centuries ago, FM is a leading mutual insurance company whose capital, scientific research capability and engineering expertise are solely dedicated to property risk management and the resilience of its policyholder-owners. These owners, who share the belief that the majority of property loss is preventable, represent many of the world's largest organizations, including one of every four Fortune 500 companies. They work with FM to better understand the hazards that can impact their business continuity to make cost-effective risk management decisions, combining property loss prevention with insurance protection.

The Data Visualization & Reporting team at FM is responsible for extracting insights out of our data to help our leaders make better business decisions. As a Business Intelligence Developer, you will help us provide innovative, consistent, and effective solutions so FM can make informed decisions. You will accomplish this through reporting and analytical solutions that bring value to the business. You will extract and transform data from various relational databases and data collection pipelines.

You will gather data through multiple channels including various internal sources via the company's underwriting, engineering, client services, marketing, claims, and operations data. You will be expected to understand, interpret, and communicate the impact to stakeholders through various forms of communication. We also aim to create and share guidelines across the organization for data visualization and reporting best practices. You will act as an ambassador to help grow adoption of these guidelines across FM.

The ideal candidate shall possess 1-10+ years of professional experience in data extraction, report modeling, data analysis, and visualization utilizing various modern technologies. Insurance knowledge and experience is a plus.

Analytical, troubleshooting, and problem-solving skills paired with intellectual curiosity and aptitude in learning new technical skills. Proficient in data storytelling : transforming data into actionable insights.

Excellent verbal and written communication skills with the ability to collaborate successfully with other colleagues and stakeholders. Analyze new and existing data to understand, interpret and communicate results effectively. Perform analyses to identify trends, gaps and potential risks.

Proficiency in Microsoft Excel (pivot tables / charts, power pivot, advanced formulas, etc.)

Data literacy : understanding database fundamentals, including SQL.Data visualization literacy : understanding when to use proper chart types to effectively convey a message.

Experience with data visualization tools such as Power BI, Tableau, etc. is required.

Experience with industry report writers such as Power BI Paginated Reports, SSRS, or other BI reporting solutions is a plus.

Ability to organize and prioritize concurrent projects. Effectively manages change and can quickly adapt to competing priorities.

Ability to work effectively both autonomously and collaboratively.

Professional experience and / or knowledge in any of the following is desired : SQL, DAX, M language, Figma, and GitHub.

Compensation Grade and Job Title will be determined based on qualifications, experience, and technical skillset.

Education

A Bachelor of Science or equivalent degree is required in Information Technology, Computer Science, Business Administration, Analytics, Engineering, Mathematics / Statistics, or related field.

Compensation, Grade, and Job Title will be determined based on qualifications, experience, and technical skillset.

The position is eligible to participate in FM's comprehensive Total Rewards program that includes an incentive plan, generous health and well-being programs, a 401(k) and pension plan, career development opportunities, tuition reimbursement, flexible work, paid time off allowances and much more.

FM is an Equal Opportunity Employer and is committed to attracting, developing, and retaining a diverse workforce.

LI-TA1