Business Intelligence Analyst II

At MAPFRE, our commitment to care is not just our purpose; it’s the driving force behind everything we do. We care about the things that resonate with the needs of our employees, our customers and the community. 

• For Employees: We cultivate an inspiring and dynamic workplace where collaboration and innovation fuel the success of our high-performing teams. 

• For Customers: In addition to being Massachusetts’ #1 home and auto insurer, we provide unmatched peace of mind to our customers across the U.S. 

• For the Community: Our culture of care extends to impactful community engagement and environmental initiatives locally and globally. 

This is who we are at MAPFRE, and we invite you to be part of a movement that cares deeply and acts boldly. Together, we make a difference. 

Position is Hybrid in Webster MA

Candidates must be authorized to work in the US without requiring sponsorship. 

Primary Responsibilities

▪ Develop datasets that serve as sources for various reports and enterprise data marts.

▪ Analyze datasets – perform exploratory analysis, data manipulation, or data modeling for deliverables.

▪ Leads or facilitates meetings to translate business needs into clearly defined, well-documented, high-quality requirements to support future reporting and visualizations.

▪ Provides consultative assistance to cross-functional teams and external departments working with data.

▪ Assists in the development of complex ad hoc reporting.

▪ Exercises discretion and applies critical thinking relative to analysis, planning, and/or implementation of critical business initiatives.

▪ Provides prescriptive recommendations for action as part of reporting based on analysis of requested data. ▪ Applies data best practices to ensure the quality and accessibility of assembled datasets

Knowledge, Skills and Abilities
Education: Bachelor's Degree or professional level of knowledge in a specialized field, or equivalent, related experience. Degree in Economics, Finance, Engineering, Mathematics, Science, Information Technology, Computer Science, Business Administration or a related quantitative analytical field.
Experience: 2 - 4 years - or Associates Degree equivalent plus 4 - 6 years.

Basic Qualifications:

- Experience in working with comparative rater applications and understanding of relational application practices
- Strong ability to analyze user requirements and build front-end BI applications according to specifications.
- Understanding of relational database structures, theories, principles, and practices.
- Excellent interpersonal, communication, organizational, and problem-solving skills.
- Ability to coordinate concurrent projects.
- Ability to prioritize and execute tasks in a high-pressure environment.
- Programming skills in SQL, SAS, VBA, EXCEL
- Proficient in merge/purge, query, and reporting in SAS, DBMS (e.g. Oracle, DB2, ACCESS), and other systems.
- Proficient quantitative and qualitative analysis skills.

 

Preferred Qualifications:
- Experience in insurance, banking, credit card or other financial industries, or comparable consulting experience.
- Experience working within multiple platforms on various databases, i.e. VCGI04, AS400, Diamond, TronWeb.
- Strong analytical, communication, and time management skills required.
- SQL Server, Teradata, UNIX, LINUX, MVS, R, Congos
- C, C++, JAVA, or other programming languages
- Database design

Thank you for considering MAPFRE Insurance as part of your career journey. 

We're proud to be rated "A" (Excellent) by A.M. Best Company. We offer property and casualty insurance, working with over 3,000 independent agents and brokers in 11 states.  

If you require an accommodation for a disability so that you may participate in the selection process, you are encouraged to contact the MAPFRE Insurance Talent Acquisition team at talentacquisition@mapfreusa.com.

We are proud to be an equal opportunity employer.