BSA - Marketing Data

Who We Are - MassMutual India
Since 1851, MassMutual's commitment has always been to help people protect their families, support their communities, and help one another. Therefore, we want to inspire people to Live Mutual. We at MassMutual value diversity and inclusion. We're people helping people
A career with us means you will work alongside exceptional people and be empowered to reach your professional and personal goals. Our employees are the foundation of what makes MassMutual a strong, stable, and ethical business. We seek and value unique and varied perspectives and experiences because we believe we are stronger when all voices are heard. We invite you to bring your bright, innovative ideas to MassMutual as we continue to help millions of Americans rely on each other.
At MassMutual, our vision is to help people secure their future and protect the ones they love. As a Business Systems Analyst, you'll help deliver high-quality data assets that enable the success of MassMutual's marketing teams.
This role will work within the Marketing Data team, which is responsible for the end-to-end delivery and management of trusted, relevant, and governed data assets that drive and measure marketing activity. Among other things, our team builds ETL pipelines that gather data and integrate them into both our data warehouse and external destinations.
Your day-to-day work will help produce clear, rationalized information and specifications necessary to deliver our data pipelines, which integrate information from multiple sources. These deliverables include scope definitions, business requirements, specifications of data relationships, and source-to-target (S2T) mappings.
Primary Responsibilities:
The person we hire for this role will support work in the following areas:

• Scope: Help identify the technical scope of work
• Requirements: Independently gather prioritized requirements, and decompose into well-written user stories with acceptance criteria
• Data subject matter expertise: Serve as an initial point of contact to determine availability and fitness of our data to support business questions and analyses
• Specifications: Produce clear information needed to deliver our data pipelines, e.g.: data and process flows, data relationships, source to target (S2T) mappings
• Coordination: Liaise with business stakeholders and technical resources during development, and help align technical execution with our peer teams
• Analysis and validation: Help profile and analyze multiple data sources to support pipeline development, and coordinate user acceptance testing

Requirements:

• Bachelor's Degree, preferably in Business or an analytical field such as Economics, Mathematics, Engineering, Computer Science
• Business / data analysis: 4-6 years of experience as a business analyst, business systems analyst, or data analyst
• SQL: 4-6 years of experience using SQL
• Data warehousing and ETL: Knowledge of database and data warehousing solutions (e.g.: Vertica, Postgres, Oracle DB, Teradata, Redshift), along with ETL / ELT pipelines
• File formats: Experience working with several file format sources (JSON, AVRO, Parquet, CSV)
• Requirements-gathering: Ability to isolate and elicit expected vs. actual experience and recommend the best action plan / solution, with little to no guidance
• Communication: Strong interpersonal communication, coordination, requirement gathering and planning skills with cross functional teams

Nice to have:

• Agile methodology: Familiar with Agile delivery process and related ceremonies
• Marketing business knowledge: Experience or familiarity with marketing processes
• Testing: Familiarity with manual and automated testing methods
• API querying: Familiarity / experience with querying REST APIs, either manually (Postman) or with libraries (Python requests library)

Scripting: Exposure to one or more scripting languages, such as Python or Shell scripting
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, Great Place to Work® certified and India's Best Workplaces in BFSI 2023 - Top 50 organization 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!