Finance Data Engineer at MassMutual

| Greater Boston Area
!Sorry, this job was removed at 12:07 p.m. (EST) on Friday, February 21, 2020

Finance Data Engineer

Boston or Springfield, MA

Full-Time

Corporate Finance Data and Analytics

Do you want to be part of a team that encourages your growth, supports your ambitions and makes it a priority for you to reach your goals? Is helping people part of who you are? At MassMutual, we help millions of people find financial freedom, offer financial protection and plan for the future. We do this by building trust with our customers by being knowledgeable problem solvers and prioritize their needs above all else. We Live Mutual.

If this sounds like a fit, we’re looking to hire a Finance Data Engineer to join our Corporate Finance data and analytics team.

Why we need you.

We’re growing and our clients deserve the best. As a finance data engineer you’ll have an opportunity to work with the latest and greatest cloud technology tools to onboard and transform finance data as part of our Amazon cloud-based technology platform. The primary objective of the data management platform is to onboard, process and serve MassMutual’s corporate finance data to enable MassMutual CFO data strategy. The finance data engineer is an engineering role within the data-management team of the CFO organization and is charged with onboarding & transforming data, analyzing data-load patterns and persisting data for business reporting and analytics. The data engineer must bring a deep technical background, must be well-versed in AWS Cloud technology, and should possess hands-on expertise in distributed-data-management technologies (Apache/open-source) and expert level knowledge in SQL and Python. The primary responsibility of a data engineer is to transform, load and build cohesive data schemas that are extensible and scalable to meet Corporate Finance’s end-user reporting and analytics requirements. In this role, as well as all roles within MassMutual, you will demonstrate accountability, agility, a dedication to be inclusive, a strong business acumen, and will show courage, even in the most difficult situations. We also highly value strong communication skills, a passion for learning, leadership traits, resilience and self-awareness.

What success looks like.

  • Design and develop data-onboarding pipelines end-to-end – from data ingestion through persisting the data in the data store
  • Design appropriate data load patterns and pick the right data-processing context between Python, PySpark and SQL (Vertica)
  • Ensure transformed data meets all the business requirements in supporting dashboards and reports and ad hoc analytics
  • Ensure data loads are 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.
  • Exhibit key MassMutual core competencies as below:
    • Business Acumen: Demonstrates knowledge of the underlying domains of data supporting financial dashboards and reports
    • Critical Thinking: Critically and logically evaluates performance benefits vs. academic approach in thinking of alternatives in data load patterns
    • Execution/Results: Takes ownership of problems and stays on top of them until resolved. Makes quick decisions and keeps track of Technical Debts. Fosters a personal commitment to the work.
    • Engage and Inspire: Engage with the broader audience who consume data to continuously refine and enhance the underlying data model to suit various data-access patterns.
    • Collaborate: Conducts periodic reviews with the business community and encourages feedback towards continuous improvement
    • Learning: Constantly learns about industry best-practices around distributed-data-management technologies and applies that to the data consumption patterns.
    • Communications: Ability to engage constructively with the dashboard & reports developers to help understand technology trade-offs

What your days and weeks will include.

  • Ensure best-practices design for master data & conforming dimensional data (Type 1,2,3,4) load management
  • Collaborate in delivering data-driven analytical solutions & timely insights via dashboards and reports
  • Publish data-load patterns and best practices across the data-engineering community
  • Be a trusted engineer for the end-user reporting and analytics community
  • Collaborate with business analysts to prioritize business use-cases and deliver on them
  • Follow agile development methodology to deliver timely solution
  • Follow CICD (continuous-integration and delivery) 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 technology standards and guidelines 

    The skills that make you a great fit.

  • Authorized to work in the US with or without sponsorship.
  • Minimum of 7 years of experience in data-engineering and database design – 10 years preferred
  • Hands-on experience for a minimum of 3 years in Cloud technology – AWS EMR, Spark, Python, Vertica preferred
  • Hands-on experience on Python programming language
  • Hands-on experience for a minimum of 5 years in advanced SQL
  • Experienced in various flavors of Linux Operating System
  • Experienced in enabling and supporting data analysts in complex data science projects
  • Deep proficiency in data architecture and data management principles – traditional RDBMS, MPP appliances, columnar repositories and distributed-data technologies
  • Experienced in agile & waterfall project-management methodologies
  • Advanced degree in Computer Science preferred
  • Exceptional communication skills (written and verbal)

    Why Join Us.

    We’ve been around since 1851. During our history, we’ve learned a few things about making sure our customers our top priority. In order to meet and exceed their expectations, we must have the best people providing the best thinking, products and services. To accomplish this, we celebrate an inclusive, vibrant and diverse culture that encourages growth, openness and opportunities for everyone. A career with MassMutual means you will be part of a strong, stable and ethical business with industry leading pay and benefits. And your voice will always be heard.

    Does this sound like a great fit? Apply today!

MassMutual is an Equal Employment Opportunity employer Minority/Female/Sexual Orientation/Gender Identity/Individual with Disability/Protected Veteran. We welcome all persons to apply. Note: Veterans are welcome to apply, regardless of their discharge status. 

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .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
    • WordpressCMS
    • HubSpotCRM
    • SalesforceCRM
    • SendGridEmail

Location

We currently have two 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.

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.
Intracompany committees
Daily stand up
Team owned deliverables
Open office floor plan
Diversity
Dedicated Diversity/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.
Unconscious bias training
Diversity manifesto
Someone's primary function is managing the company's diversity and inclusion initiatives
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 Benefits
Basic Dental covers preventive and basic restorative care; Major Dental covers all that Basic covers, plus restorations and orthodontia (limits apply).
Vision Benefits
Health Insurance Benefits
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
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
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
Match charitable contributions
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.
Child Care & Parental Leave Benefits
Child Care 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.
Flexible Work Schedule
Flexible work arrangements, including telecommuting, are available in many departments across the company.
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
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.
Perks & Discounts
Casual Dress
Commuter Benefits
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Lunch and learns
Cross functional training encouraged
Promote from within
Online course subscriptions available
Customized development tracks
Paid industry certifications

Additional Perks + Benefits

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

More Jobs at MassMutual72 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Operations
Product
Project Mgmt
Sales
Developer
new
Boston
Finance
new
Boston
Developer
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Project Mgmt
new
Boston
Data + Analytics
new
Boston
Project Mgmt
new
Boston
Developer
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Finance
new
Boston
Project Mgmt
new
Boston
Data + Analytics
new
Boston
Operations
new
Boston
Design + UX
new
Boston
Data + Analytics
new
Boston
Operations
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Design + UX
new
Boston
Product
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Product
new
Boston
Finance
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Product
new
Boston
Data + Analytics
new
Boston
Operations
new
Boston
Data + Analytics
new
Boston
Project Mgmt
new
Boston
Developer
new
Boston
Finance
new
Boston
Developer
new
Boston
Operations
new
Boston
Finance
new
Boston
Finance
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Developer
new
Boston
Finance
new
Boston