Data Integration Analyst

Data Analyst Opportunity in Financial Services

Data Integration Analyst

Location(s):

Boston, MA: 155 Seaport Blvd, Boston, MA 02210

Osaic is not considering remote candidates at this time.

Osaic has returned to the office on a hybrid schedule. Applicants should be located at one of our hubs listed above and must be willing to work this schedule.

Role Type:        Full-time

Salary: $80,000 - $100,000 per year + annual performance-based bonus

Actual compensation offered will be determined individually, based on a number of job-related factors, including location, skills, licensure, experience, and education.

Our competitive compensation is just one component of Osaic’s total compensation package. Additional benefits include health, vision, dental insurance, 401k, paid time away, volunteer days and much more. To view more details of what you can look forward to, visit our careers page: https://careers.osaic.com/Creative/Benefits.

Summary:

A Unique Opportunity at CW Advisors – an award-winning independent RIA with an amazing culture and national footprint. CW Advisors is a national investment advisory firm headquartered in Boston, MA with offices located around the country. We specialize in providing sophisticated financial planning and investment advice and we love what we do. As the firm rapidly expands, we have some amazing career opportunities for self-motivated, team-oriented professionals.

CW Advisors is seeking a Data Integration Analyst to support the firm’s private investment operations and research.

Education Requirements:

• Bachelor’s degree preferred, high school diploma (or equivalent) in combination with significant practical experience will be considered in lieu of degree.  Minimum of high school diploma or equivalent is required.   

Responsibilities:

• Ongoing data maintenance

• Black Diamond Householding

• Salesforce data cleansing and imports

Basic Requirements:

• Salesforce Proficiency: Minimum 2–3 years of experience in Salesforce administration or data operations, with a strong focus on data hygiene and bulk updates.

• M&A Data Integration: Proven experience (1–3 years) managing data migration or systems integration projects, specifically mapping disparate datasets into a unified CRM schema.

• Expert Excel Skills: Advanced proficiency in Excel, including VLOOKUPs, Pivot Tables, and complex formulas to validate and scrub data before system ingestion.

• Data Normalization: Demonstrated ability to clean, deduplicate, and normalize high volumes of "messy" data from external sources.

• High-Volume Execution: Capacity to handle multiple, overlapping projects, maintaining high accuracy and attention to detail under tight deadlines.

• Independent Project Management: Ability to drive integration tasks to completion with minimal oversight once initial mapping rules are established.

Preferred Requirements:

• Black Diamond Knowledge: Previous experience with householding, account merging, or performance reporting in Black Diamond is a strong plus.

• DemandTools Experience: Familiarity with DemandTools for advanced deduplication and data maintenance is highly desirable.

• Financial Services Context: Prior experience working in an RIA, PE firm, or investment advisory environment is preferred.

Osaic is an equal opportunity employer. We celebrate diversity in our workplace and we hire the most qualified candidates without regard for age, ethnicity, gender, gender identity or expression, language differences, nationality or national origin, family or marital status, physical, mental, and developmental abilities (or the perception of a disability), genetic information, race, religion or belief, sexual orientation, skin color, social or economic class, education, work and behavioral styles, political affiliation, military service, caste, or any other characteristic protected by law.

Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Osaic.

Osaic does not consider applications from candidates who do not meet the minimum qualifications stated in the job posting.

Osaic only accepts candidates from contracted recruiting firms and only for searches approved prior to submissions. Fees will not be paid for unsolicited submissions.