Finance Data Engineer
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
Basic Qualifications :
· Minimum of 7 years of experience in data-engineering and database design
· 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)
· Authorized to work in the United States with or without sponsorship now or in the future
Preferred Qualifications :
· 10 years preferred of database design and experience in data-engineering
· Hands-on experience for a minimum of 3 years in Cloud technology – AWS EMR, Spark, Python, Vertica preferred
· Advanced degree in Computer Science preferred
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.