BSA - Marketing Data

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

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.