MassMutual
We help people secure their future and protect the ones they love.
Boston, MA
Hybrid

Finance Data Architect

Sorry, this job was removed at 1:43 p.m. (EST) on Thursday, January 30, 2020
Find out who's hiring remotely in Greater Boston Area.
See all Remote Data + Analytics jobs in Greater Boston Area
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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.
See More
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

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.

Culture
Volunteer in local community
Every action supporting a common cause is meaningful, and our employees make a difference in their own communities through our Matching Gift, Matching Time and Volunteer Time Off Programs.
Partners with nonprofits
Every year, MassMutual and the MassMutual Foundation invest more than $20 million focused on advancing economic opportunity. https://www.massmutual.com/about-us/corporate-responsibility/foundation
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Employee resource groups
Employee-led culture committees
Hybrid work model
In-person all-hands meetings
Employees can either attend the in-person all-hands meeting, watch live via Zoom, or watch the recording. All employees are invited to submit questions.
Employee awards
Flexible work schedule
Flexible work arrangements, including telecommuting, are available in many departments across the company.
Remote work program
In addition to two remote days per week, MassMutual offers employees four full remote weeks of their choice per year.
Diversity
Documented equal pay policy
Dedicated diversity and inclusion staff
Highly diverse management team
More than half of our Board of Directors are comprised of women and people of color, making it one of the most diverse groups in the industry.
Mandated unconscious bias training
Diversity manifesto
Diversity employee resource groups
Hiring practices that promote diversity
Diversity recruitment program
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
A health care flexible spending account (FSA) allows employees to save money on a before-tax basis for eligible medical, dental and vision expenses, subject to IRS limits.
Disability insurance
For details on short term and long term disability insurance please visit https://www.massmutual.com/-/media/files/employee_benefits.pdf
Dental insurance
Basic Dental covers preventive and basic restorative care; Major Dental covers all that Basic covers, plus restorations and orthodontia (limits apply).
Vision insurance
Health insurance
To learn more about our Health and Welfare Benefits please visit: https://www.massmutual.com/-/media/files/employee_benefits.pdf
Life insurance
For more information about our Life Insurance Benefits please visit: https://www.massmutual.com/-/media/files/employee_benefits.pdf
Pet insurance
Wellness programs
Team workouts
Mental health benefits
Transgender health care benefits
Wellness days
Abortion travel benefits
Our general medical travel benefit covers abortion-related travel.
Financial & Retirement
401(K)
In addition to our 401(k), MassMutual a cash balance plan that provides an account-based pension benefit based on accruals of pay credits and interest credits.
401(K) matching
Performance bonus
Charitable contribution matching
Every action supporting a common cause is meaningful, and our employees make a difference in their own communities through our Matching Gift and Matching Time Programs.
Pay transparency
Child Care & Parental Leave Benefits
Childcare benefits
Dependent care flexible spending account to allow you to set aside before tax dollars to pay for certain eligible child care expenses.
Generous parental leave
Leave for birth mothers of 18 weeks of fully paid leave. Non-birth mothers, fathers and adoptive parents eight weeks of fully paid parental leave.
Family medical leave
Caregiver leave: Up to two weeks paid leave to care for a loved one. Bereavement Leave: 15 days of paid time off to grieve the loss of a loved one with the employee defining who the loved one is.
Adoption Assistance
Company sponsored family events
MassMutual offers many opportunities for family events, from group volunteer experiences and chances to attend Red Sox games to business resource group-sponsored outings like annual pride parades.
Fertility benefits
Vacation & Time Off Benefits
Generous PTO
Paid holidays: 9 fixed and 1 floating. Vacation: starts at 19 vacation and personal days per calendar year, with increases at 5-year service intervals.
Paid volunteer time
Three days of paid time off is available to employees annually to give back to their communities, by sharing their time and talent with a cause close to their heart.
Paid holidays
Paid sick days
Occasional illness: up to 5 days per calendar year.
Flexible time off
Floating holidays
Bereavement leave benefits
Hardship benefits
320 hours of caregiver leave to take of loved ones when it matters most.
Office Perks
Commuter benefits
Free daily meals
Free snacks and drinks
Some meals provided
Onsite office parking
Recreational clubs
Relocation assistance
Fitness stipend
Home-office stipend for remote employees
MassMutual's wellness wallet is a stipend available to all employees, and can be used for myriad wellness-related purchases, including home-office purchases.
Meditation space
Mother's room
Onsite gym
Professional Development Benefits
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Mentorship program
Continuing education stipend
Continuing education available during work hours
Online course subscriptions available
Customized development tracks
Paid industry certifications
Personal development training
Virtual coaching services

Additional Perks + Benefits

To learn more about our comprehensive benefits please visit: https://www.massmutual.com/-/media/files/employee_benefits.pdf

More Jobs at MassMutual

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about MassMutualFind similar jobs like this