NEW JOB OPENING
BUSINESS SYSTEMS ANALYST - DATA MAPPING, SQL & ADOBE CDP
IN Boston, MA, USA!

 

Date Posted: 10/08/2026
Hiring Organization: Rose International
Position Number: 508922
Industry: Insurance
Job Title: Business Systems Analyst - Data Mapping, SQL & Adobe CDP
Job Location: Boston, MA, USA, 02116
Work Model: Onsite
Shift: M-F, 8 to 5 (Hybrid 3 days onsite)
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 7
Min Hourly Rate($): 60.00
Max Hourly Rate($): 75.00
Must Have Skills/Attributes: Adobe, Agile, Data Analysis, Marketo
Experience Desired:
Experience working in Agile/Scrum environments, including backlog refinement (3+ yrs),
SQL Proficiency: Complex joins, window functions, CTEs, aggregation, set operations (3+ yrs),
Data Analysis (3+ yrs),
Data Lineage (1+ yrs),
SQL Proficiency (1+ yrs),
Relational Database Skills (1+ yrs),
Proficiency with Microsoft Office, JIRA, and MarTech/AdTech-related tools (1+ yrs)
Required Minimum Education: Bachelor’s Degree

**C2C is not available**

 

Job Description
Required Education:

• Bachelor's degree required



Required Experience and Skills:

• Strong understanding of modern Marketing Technology ecosystems, including customer data management, audience segmentation, preference/consent management, and digital activation platforms.

• Experience working in Agile/Scrum environments, including backlog refinement, user story development, and sprint delivery.

• Proficiency in systems analysis, data analysis, systems design, and testing methodologies; ability to translate business marketing goals into technical workflows and data requirements.

• Data Lineage: Mapping data from operational databases to key business applications (front-end)

• Data Analysis: "Reading" a database to look for common data points to find logical points and requirements for logic and necessary joints between flat RDBMS tables

• SQL Proficiency: Complex joins, window functions, CTEs, aggregation, set operations, and performance considerations.

• Relational Database Skills: Indexing, transactions, isolation levels, partitioning, and query optimization basics.

• Strong analytical and organizational skills with the ability to support multiple concurrent projects across marketing and technology domains.

• Effective communication skills with the ability to align data, engineering, and marketing stakeholders across geographically dispersed teams.

• Ability to work independently while also thriving in highly collaborative, cross-functional environments.

• Proficiency with Microsoft Office, JIRA, and MarTech/AdTech-related tools; SQL or data profiling experience is a plus.

• Demonstrated ability to leverage emerging technologies including Generative AI to enhance requirements development, data analysis, documentation, and marketing workflow optimization.

• Ability to manage competing priorities and adapt to the pace and evolution of digital marketing and data platforms.

• Awareness of organizational dynamics, informal networks, and cross-functional dependencies that influence marketing and data outcomes.



Preferred Skills and Experience:

• Broader Marketing Technology / MarTech experience

• Customer Data Platform experience

• Adobe Target

• Marketo

• Audience segmentation

• Preference / consent management

• Data quality / data cleansing

• Testing / QA collaboration

• Experience with financial services or insurance



Business Systems Analyst Responsibilities:

We are seeking a talented and experienced Data Business Systems Analyst to join our dynamic team. You will work closely with cross-functional teams to deliver transformative and impactful digital solutions.



Join the Marketing Technology team to support the evolution of personalization utilizing data from Admin systems, Data Lake, Customer Data Platform and Marketo.



This role offers a dynamic opportunity to collaborate with various partners to elicit and understand business needs. The Data Business Systems Analyst (BSA) will act as a key liaison between business and technology, translating data specifications into actionable technical requirements and ensuring successful delivery of system functionalities and product development.



Key Responsibilities

• Partner with Product Owners, Engineers, Data Architects, Marketing Operations, and cross-functional business partners to define Epics, Features, and detailed User Stories that support digital marketing, customer engagement, and data activation capabilities.

• Translate marketing strategy, customer experience requirements, and preference/consent policies into clear technical requirements, data models, and system integrations across the MarTech ecosystem.

• Collaborate with engineering and QA teams to develop and execute test strategies, acceptance criteria, and test plans to validate data flows, customer journeys, audience segmentation logic, and system enhancements.

• Lead test planning and execution across system, integration, regression, and user acceptance testing, ensuring accuracy of customer data, segmentation, and campaign orchestration outcomes.

• Analyze complex data transformations, audience logic, customer lifecycle rules, and platform configurations to identify issues, diagnose root causes, and recommend scalable solutions.

• Work closely with internal technology teams and external vendors to ensure MarTech platforms integrate seamlessly with enterprise data sources, CRM systems, and analytics environments.

• Support customer data governance in alignment with enterprise data and technology strategy.

• Manage multiple initiatives concurrently across marketing, data, and engineering teams—navigating ambiguity with a customer-centric, data-driven mindset.

• Create and maintain documentation for data mapping flows, technical designs, business rules, MarTech configurations, and release deliverables to ensure transparency and maintainability.

  • **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

  • **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**


 

Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).

 

Apply Now

 

About Rose

  • Founded in 1993
  • Office Locations Across the U.S.
  • 150+ Clients: Corporations and Government Agencies
  • Employee Oriented Company
  • Challenging Assignments Across the U.S.
  • Continuous Professional Development

I have been very pleased with my experience with Rose International. Everyone that I encountered was very helpful and courteous.

Stephanie, Consultant

As a contractor, I have to say that Rose International was by far the best agency I have worked for.

Q'testdalir, Consultant

It is a great pleasure being a part of the Rose International Team.

Toni, Consultant

Any time I did have a question and called, the phone was always answered, and my question/concern was immediately resolved.

Sally, Consultant

It was great working for Rose International. Everyone was extremely helpful.

Rosann, Consultant

EMPLOYEE COMMENTS

  • We want you to work with us, but don't take our word for it. Take a look at this sampling of employee comments. They speak for themselves.