Data Modeler (Analytical Systems)

| Greater Boston Area

At MassMutual, we’re passionate about helping millions of people find financial freedom and this passion has driven our approach to developing meaningful experiences for our customers. The Data Engineering team, part of MassMutual’s Enterprise Technology & Experience, is comprised of highly skilled, collaborative, problem solvers who are motivated to create innovative solutions that exceed the changing needs of our customers and move MassMutual and the industry – forward.

To continue our cutting-edge work, we are hiring a Data Modeler to join our team.

What great looks like in this role

  • Our ideal Data Modeler has advanced knowledge of application, data, and infrastructure disciplines. You’ll use your skills to implement data strategies, build data flows, and develop conceptual data models. You’re capable of working independently and communicating effectively to provide feedback on policies, procedures, processes, and standards. The team culture of working collaboratively, cross-functionally, using new technologies combined with the work/life balance provided by MassMutual are core reasons people enjoy working on the Data Engineering team at MassMutual.

Objectives of this role

  • Manage database design and data models for a specific application.
  • Analyze existing data and recommend changes that lead to a reduction of stored data without impacting business requirements.

Daily and monthly responsibilities

  • Perform as a technical data steward – understanding tables, data use, data replication, data connection, and data lineage – and take accountability for data hygiene.
  • Review existing data model and recommend changes to optimize data requirements.
  • Analyze source system data and look for data redundancy and duplication.
  • Work with Application Architects to review exiting data models and suggest action to reduce input data for storage optimization.
  • Work with the development team to implement data strategies, build data flows, and develop conceptual data models.
  • Create logical and physical data models using best practices.
  • Delivers and provides feedback for data modeling policies, procedure, processes and standards.
  • Assists with capturing and documenting system flow and other pertinent technical information about data, database design, or systems.

Basic Qualifications

  • Bachelor’s degree in computer engineering, computer science, information systems, or related field.
  • 5+ years experiences 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.

Preferred Qualifications

  • 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 metadata management.
  • 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 with Scala
  • Strong communication and interpersonal skills.
  • Ability to present design of the solution to various stakeholders.
  • Experience in data modeling and design in the insurance and financial industries
Read Full Job Description

Technology we use

  • Engineering
  • Product
    • .NETLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PythonLanguages
    • RubyLanguages
    • ScalaLanguages
    • BashLanguages
    • GroovyLanguages
    • D3JSLibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • Redux SagaLibraries
    • ExpressFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SpringFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • PostgreSQLDatabases
    • SQLiteDatabases
    • TeradataDatabases
    • Google AnalyticsAnalytics
    • OptimizelyAnalytics
    • TealiumAnalytics
    • SnowplowAnalytics
    • LookerAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • Aha!Management
    • BasecampManagement
    • ConfluenceManagement
    • JIRAManagement
    • TrelloManagement

Location

470 Atlantic Avenue, Boston, MA 02110

An Insider's view of MassMutual

How do you collaborate with other teams in the company?

As a Product Owner, I spend most of my time collaborating with others across different business units. On any given day, I could be spending time brainstorming design concepts of upcoming features with our design team or assisting them with presenting these concepts to outside users as part of our user testing process.

Ryan

Digital Product Owner

What makes someone successful on your team?

Successful people on my team are: passionate, curious, receptive, and engaged. Each team member is expected to be passionate about the work that they do, and the domains in which they practice. They are always solving unique problems and must be curious about finding new solutions.

David

Digital Lead

What’s the vibe like in the office?

We work in an open floor plan, so there is a lot of opportunity for networking across roles, teams and levels. Everyone is very friendly and welcomes the opportunity to get to know other people on the floor.

Kristina

Digital Product Manager

What are MassMutual Perks + Benefits

MassMutual Benefits Overview

At MassMutual, employees have the opportunity to earn a competitive salary and bonus, enroll in an
array of benefits, and participate in programs and services that support healthy lifestyles, assist them
in building financial security for themselves and their families and help them live well-balanced lives.

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
More Jobs at MassMutual85 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Developer
new
Boston
Project Mgmt
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Design + UX
new
Boston
Finance
new
Boston
Finance
new
Boston
Sales
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Finance
new
Boston
Finance
new
Boston
Data + Analytics
new
Boston
Product
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Project Mgmt
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Design + UX
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Product
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Developer
new
Boston
Project Mgmt
new
Boston
Operations
new
Boston
Data + Analytics
new
Boston
Design + UX
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Marketing
new
Boston
Sales
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Product
new
Boston