Business Intelligence Analyst II

Mapfre

Full-time - Mid Level

Hybrid

Insurance Carriers and Related Activities

About the position

The Business Intelligence Analyst II position at MAPFRE involves developing and analyzing datasets to support reporting and visualization needs. The role requires collaboration with cross-functional teams to translate business requirements into actionable insights, ensuring data quality and accessibility. This hybrid position is based in Webster, MA, and is suited for candidates with a strong analytical background and experience in business intelligence applications.

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.
• Lead or facilitate meetings to translate business needs into clearly defined, well-documented, high-quality requirements.
• Provide consultative assistance to cross-functional teams and external departments working with data.
• Assist in the development of complex ad hoc reporting.
• Exercise discretion and apply critical thinking relative to analysis, planning, and/or implementation of critical business initiatives.
• Provide prescriptive recommendations for action based on analysis of requested data.
• Apply data best practices to ensure the quality and accessibility of assembled datasets.

Requirements

• Bachelor's Degree or professional level of knowledge in a specialized field, or equivalent related experience.
• 2 - 4 years of experience, or Associates Degree equivalent plus 4 - 6 years.
• 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 and prioritize 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.

Nice-to-haves

• 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.
• Familiarity with SQL Server, Teradata, UNIX, LINUX, MVS, R, Congos.
• Knowledge of C, C++, JAVA, or other programming languages.
• Experience in database design.