What are the responsibilities and job description for the Data Engineer III position at Mapfre?
Data Engineer
Do you think in Python and speak in SQL? Do you appreciate a good data model as much as a good painting in a museum? Are you excited by an opportunity to solve complex problems while also having fun? Are you a team player? Do you strive for simplicity and elegance in your solutions? If so, MAPFRE USA is looking for a data engineer who will be part of the Data Engineering team building data products for our sophisticated data consumers.
As a data Engineer you will be a part of an agile team delivering value. Using modern tools and technologies. You will work closely with the data architect and stakeholders and help MAPFRE USA transform to a data driven organization.
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 :
