Remote or Springfield, Massachusetts
Data Analytics Data Modeling Big Data
Springfield, MA - must work ONSITE once site reopens
18 Month Contract
Bachelor’s degree in computer engineering, computer science, information systems, or related field.
5+ years experience with data analytics, data modeling or data architecture and database design.
Experience in data modeling or data architecture in transactional and operational reporting and analytical (EDW, Data Lake, NoSQL) solutions.
Experience with capacity planning, database scripting and package deployment
Good knowledge of data replication methodology.
Good knowledge of data warehouse, data mart and Data Lake
Experience with AWS and cloud-based databases and data warehouses.
Authorized to work in the United States with or without sponsorship now or in the future.
Advanced knowledge of application, data and infrastructure disciplines.
Experience with Vertica Database.
Experience with Life Insurance or any insurance related products
Expertise in tuning and debugging SQL and resolving application specific bottlenecks.
Experience facilitating meetings and providing presentations to stakeholders and senior leaders.
Experience using (Erwin, TOAD, or any other data modeling tool) for data modeling.
Data modeling, data warehousing, dimensional modeling, data modeling for big data and
Data Lake and Big Data modeling experience.
Excellent communication, problem solving, organizational and analytical skills
Understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, schema on read, irregular dimensions, and surrogate, compound and intelligent keys.
Advanced degree in computer engineering, computer science, information systems, or related field.
Able to work independently.
Experience with Hadoop, Spark, and Kafka
Experience in data modeling and design in the insurance and financial industries.