Data Architect

| Greater Boston Area

We are looking for an experienced data architect who can map business requirements to scalable, extensible and accessible database design as part of our Cloud based data & analytics platform.

The data architect is an engineering role within the data management and architecture team of the CFO organization and is responsible for designing & deploying the underlying database structures. The data architect must bring a deep technical background, must be well-versed in Cloud (modern & full stack) technology, and should possess hands-on expertise in distributed-data-management technologies (Apache/open-source). The data architect’s primary responsibility is to create a cohesive, logical and physical data model that is extensible and scalable and that covers all of Corporate Finance data.


Key Responsibilities
 

  • Own the conceptual, logical and physical data model across all of CFO finance data
  • Ensure the physical data model meets all the business requirements in supporting dashboards and reports and ad hoc analytics
  • Ensure the physical data model is tuned for optimal performance throughput with respect to the underlying DBMS – preferably Vertica
  • Ensure the integrity of the underlying data is maintained in terms of primary-keys, foreign-keys and unique-indices etc.
  • Ensure appropriate best-practices database design for master data management & conforming dimensional data (Type 1,2,3,4) management
  • Collaborate in delivering data-driven analytical solutions & timely insights via dashboards and reports to the CFO leadership team
  • Publish domain specific data models across the user community
  • Be a trusted database advisor for the CFO user community
  • Collaborate with the leadership team to prioritize business use-cases and estimating duration and effort
  • Follow agile development methodology to deliver timely solution
  • Follow CICD (continuous-integration and deployment) pipeline to ensure seamless migration across development, QA and production environments
  • Conduct periodic data model reviews covering data architecture, data load patterns and design 
  • Publish and communicate standards and technology evaluations
     

Skills and Qualifications:

  • 10 years of experience in data-engineering and database design
  • Hands-on experience in Cloud technology – AWS EMR, Spark, Python, Vertica preferred
  • Hands-on experience for a minimum of 7 years with SQL
  • Experienced in enabling and supporting data analysts in complex data science projects
  • Deep proficiency in data modeling and data management principles – traditional RDBMS, MPP appliances, columnar repositories and distributed-data technologies
  • Experienced in agile & waterfall project-management methodologies
  • Prior experience in modeling Corporate Finance or Insurance data sets preferred
  • Exceptional communication skills (written and verbal)
  • Must be authorized to work in the US without sponsorship now and in the future.
Read Full Job Description

Technology we use

  • Engineering
  • Product
    • .NETLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PythonLanguages
    • RLanguages
    • 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

We currently have Boston office locations at both 470 Atlantic Ave and One Marina Park.

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
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Finance
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Operations
new
Boston
Data + Analytics
new
Boston
Operations
new
Boston
Data + Analytics
new
Boston
Product
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Project Mgmt
new
Boston
Design + UX
new
Boston
Data + Analytics
new
Boston
Design + UX
new
Boston
Product
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Finance
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Marketing
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Finance
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Product
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Developer
new
Boston
Project Mgmt
new
Boston
Operations
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Sales
new
Boston