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-5 years of experience as a business analyst, business systems analyst, or data analyst
- SQL: 4-5 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