Driving digital transformation and operational efficiency across Investment Management at MassMutual
Requirements
- 8+ years of experience with data analytics, data modeling, and database design.
- 5+ years experience with ELT methodologies and tools.
- 5+ years experience in designing, developing, tuning and troubleshooting SQL.
- 3+ years of coding and scripting (Python, Java, Scala) and design experience.
- 2+ years of experience with Spark framework.
- Knowledge of Informatica Power center and Informatica IDMC.
- Knowledge of distributed, column- orientated technology to create high-performant database technologies like - Vertica, Snowflake.
Responsibilities
- Design, build, and measure complex ELT jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
- Executes 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, and systems.
- Develop comprehensive data quality standards and implement effective tools to ensure data accuracy and reliability.
- Collaborate with various Investment Management departments to gain a better understanding of new data patterns.
- Collaborate with Data Analysts, Data Architects, and BI developers to ensure design and development of scalable data solutions aligning with business goals.
- Translate high-level business requirements into detailed technical specs.
Other
- Bachelor’s degree in Computer Science, Engineering, Information Systems or related technical field.
- Ability to influence and motivate teams without direct authority.
- Excellent time management and organizational skills, with the ability to prioritize multiple initiatives.
- Exceptional communication and interpersonal skills.
- Domain knowledge of Investment Management operations including Security Masters, Securities Trade and Recon Operations, Reference data management, Pricing.
