Business Intelligence Analyst II

Mapfre

432d • Hybrid

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.

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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Insurance Carriers and Related Activities
• Education Level: Associate degree