Job Information
MAPFRE Insurance Data Engineer in Webster, Massachusetts
Data Engineer
Date: Dec 11, 2024
Location:
Webster, MA, US
Company: MAPFRE
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.
Job Summary
Augment and maintain the existing repositories and data structures within AWS (used to process and store large amounts of data from unrelated sources)
Experience with several formats and means for data ingestion. Including, data types (structured, semi-structured, and unstructured), and sources (on premise, and in the cloud) using the most appropriate techniques in each case
Continue to expand and enhance the model, utilizing best practices, in regards to the organization of data and the various relationships
Optimize existing and future models for fast and scalable queries (while maintaining performance and related price thresholds)
Work with the team to define, construct, and maintain self-service dashboards for the Business and Advanced Analytics teams within PowerBI
Implement scalable and flexible, high performance data pipelines for AWS to support analytics
Develop and maintain data maps and their relationships
Generate associated technical documentation including follow-up reports
Work with Data Governance to implement quality rules and data governance measures (data dictionary, metadata, traceability, ...)
Propose improvements and actions based on provided results
Communicate results effectively with required teams
Knowledge, Skills and Abilities:
Bachelor's Degree with 6+ years of experience.
Advanced knowledge and experience using Python, Airflow, Spark, AWS, and Snowflake
Database architectures: SQL, NoSQL, graph databases
CI/CD and Orchestration: Jira, Jenkins, Bit Bucket, Terraform, and Airflow
Past experience with data modeling tools, ETL tools (e.g. Informatica Power Center)
Computer languages, data query and transformation tools: AWS Athena, Jupyter notebooks, Spark, Pyspark, Python, and EMR Studio
Algorithm analysis (for working with our Data Scientists)
Understanding of multidimensional modeling for quantitative and fact related data storage
OS: Linux, and MS Windows
Code IDE: Microsoft Visual Code, Jupyter notebooks
Artificial intelligence, machine learning, and deep learning are a plus
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.
Nearest Major Market: Worcester
Job Segment: Recruiting, Database, Data Modeler, Engineer, SQL, Human Resources, Technology, Data, Engineering
Apply now »