The Opportunity

Do you want to be part of a team that encourages your growth, supports your ambitions and makes it a priority for you to reach your goals? Is helping people part of who you are?

As a Business Systems Analyst, you’ll help deliver high-quality data assets that enable the success of MassMutual’s marketing teams.

Job Description

The Business Systems Analyst will report to an IT Delivery Manager from Romania.

They 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.

The 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.

Responsibilities

• 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.