MassMutual Data Modeler / Solution Architect (Analytical Systems) in Boston, Massachusetts
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.
Bachelor’s degree in computer engineering, computer science, information systems, or related field.
8+ 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 Dimensional Modeling / Data Warehouse Modeling
Data modeling, data warehousing, dimensional modeling, data modeling for big data and metadata management.
Experience using (Erwin, TOAD, or any other data modeling tool) for data modeling.
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.
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.
Strong Knowledge of Structured Query Language (SQL) and use in data access and analysis.
Excellent communication, problem solving, organizational and analytical skills
Strong communication and interpersonal skills.
Able to work independently.
Authorized to work in the United States with or without sponsorship now or in the future.
Master's degree in computer engineering, computer science, information systems, or related field.
Advanced knowledge of application, data and infrastructure disciplines.
Experience with Finance, Accounting Models, Enterprise Risk Management Models
Experience facilitating meetings and providing presentations to stakeholders and senior leaders.
Ability to present design of the solution to various stakeholders.
Experience with Vertica Database.
Expertise in tuning and debugging SQL and resolving application specific bottlenecks.
Data Lake and Big Data modeling experience.
Experience with Hadoop, Spark, and Kafka
Experience with Scala
Experience with Life Insurance or any insurance related products
Experience in data modeling and design in the insurance and financial industries
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.
If you need an accommodation to complete the application process, please contact us (firstname.lastname@example.org) and share the specifics of the assistance you need.
Offers of employment are contingent on the completion of satisfactory references, background investigation, and (if applicable) any federal securities law requirements/FINRA regulations (including fingerprinting) and/or passing of a drug screening.
At MassMutual, we focus on ensuring fair, equitable pay by providing competitive salaries, along with incentive and bonus opportunities for all employees. Your total compensation package includes either a bonus target or in a sales-focused role a Variable Incentive Compensation component. For more information about our extensive benefits offerings please check out our Total Rewards at a Glance. (http://www.massmutual.com/global/media/shared/doc/employee_benefits.pdf)
- MassMutual Jobs