Mercury Insurance is looking to solve its most challenging data integration problems and create production data pipelines for advanced analytics and data science teams
Requirements
- 3 or more years of experience in development of big data/data lake solutions on Cloud platforms, preferably AWS (S3, Glue/EMR, Athena, AppFlow) or Snowflake
- 3 or more years of experience in Python, Java and/or Scala programming
- 3 or more years of experience in writing SQL statements and query performance tuning
- 3 or more years of experience in RDMS or MPP databases, preferably AWS Redshift or Snowflake
- Experience with MDM (Master Data Management), preferably Reltio
- 1 or more years of experience working with AI technologies in a production environment
- Expert skills in data mining and data analytics
Responsibilities
- Design, build, and launch collections of high-quality big data/data lake solutions on Cloud platform preferably AWS, Snowflake that support multiple use cases across all departments, all products, and all states
- Solve our most challenging data integration problems, utilizing optimal ETL patterns, frameworks, query techniques, sourcing from structured and unstructured data sources
- Assist in owning existing processes running in production, optimizing complex code through advanced algorithmic concepts
- Collaborate with teams of data analysts and data scientists, who research and integrate algorithms to develop solutions to address complex data problems
- Leverages existing data infrastructure to fulfill all data-related requests, perform necessary data housekeeping, data cleansing, normalization, hashing, and implementation of required data model changes
- Analyze data to spot anomalies, trends and correlate similar data sets
- Design, develop and implement natural language processing software modules
Other
- Bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or related field
- 3 or more years of experience in data analytics, data engineering, and/or data science
- Ability to multitask, prioritize, and manage time effectively
- Excellent problem-solving skills required
- Excellent written and verbal communication skills required
