Data Integration Specialist

Job Description

About YTS Wealth Management

YTS Wealth Management is a rapidly growing wealth management firm built on a foundation of exceptional client service, long-term relationships, and a collaborative team culture. Our firm provides comprehensive wealth management solutions including investment management, retirement planning, tax-efficient strategies, insurance, and estate planning guidance.

About the Role

YTS Wealth Management is seeking a Data Integration Specialist to own data integrity across Black Diamond and all connected firm systems. This is a remote role reporting to our COO, responsible for ensuring accurate, reliable, and consistent data flow across our technology stack - from portfolio management and CRM platforms to reporting and client-facing tools. The ideal candidate combines strong technical data skills with the judgment to catch and resolve issues before they affect clients or advisors.

Key Responsibilities

\n
• Own end-to-end data integrity across Black Diamond and all connected/integrated systems (CRM, portfolio management, custodial feeds, reporting tools)
\n
• Design and maintain data integration workflows and reconciliation processes between Black Diamond and upstream/downstream systems
\n
• Identify, investigate, and resolve data discrepancies, sync failures, and quality issues before they impact reporting or client-facing output
\n
• Establish and document data governance standards, validation rules, and quality-control checkpoints
\n
• Partner with Operations, Client Service, and IT/vendor teams to troubleshoot integration issues and improve data flow across the technology stack
\n
• Monitor scheduled data feeds and imports; proactively flag and remediate failures or anomalies
\n
• Support system implementations, upgrades, and new integrations from a data-integrity standpoint
\n
• Document data flows, mappings, and integration architecture
\n

Qualifications

\n
• 3+ years of experience in data integration, data management, or a related analytical role — ideally within wealth management, financial services, or fintech
\n
• Hands-on experience with Black Diamond and/or comparable portfolio management or CRM platforms (Orion, Salesforce, Redtail, etc.) is a strong plus
\n
• Strong SQL skills; familiarity with ETL tools and data pipeline concepts
\n
• Demonstrated ability to identify root causes of data quality issues and implement lasting fixes, not just workarounds
\n
• Excellent attention to detail and comfort owning accuracy for a firm's core data systems
\n
• Strong written and verbal communication skills — able to explain data issues to non-technical stakeholders
\n
• Bachelor's degree in a related field (Computer Science, Information Systems, Finance) or equivalent practical experience
\n

Physical Requirements

\n
• Prolonged periods of sitting, computer use, and phone communication
\n
• Ability to attend in-person meetings and events
\n
• Occasional lifting of light materials up to 20 pounds
\n
• Ability to communicate effectively in both in-person and virtual environments
\n

Compensation & Benefits

Compensation

\n
• Salary Range: $80,000 – $90,000 (commensurate with experience)
\n

Benefits & Perks

\n
• Growth and leadership development opportunities
\n
• 9 paid company holidays
\n
• Flexible scheduling for personal appointments
\n
• Travel expense reimbursement
\n
• 10 days of Paid Time Off
\n
• 401(k) with dollar-for-dollar match up to 4%
\n
• Medical, Dental, Vision insurance
\n
• Health Reimbursement Arrangement (HRA)
\n
• Life Insurance
\n
• Maternity & Paternity Leave
\n

Observed Holiday's:

\n
• New Year's Day
\n
• Martin Luther King, Jr. Day
\n
• Presidents' Day
\n
• Good Friday
\n
• Memorial Day
\n
• Juneteenth
\n
• Independence Day
\n
• Labor Day
\n
• Thanksgiving Day
\n
• Day After Thanksgiving
\n
• Christmas Eve
\n
• Christmas Day
\n
• New Year's Eve
\n

Schedule & Work Environment

\n
• Monday–Friday (Daylight hours)
\n
• Occasional evenings/weekends for client events and networking
\n
• Remote role
\n

Legal & Compliance Disclosures

\n
• Equal Employment Opportunity: We are an equal opportunity employer and do not discriminate based on race, color, religion, sex, national origin, disability, or age.
\n
• At-Will Employment: Employment at YTS Wealth Management is at-will. Either party may terminate employment at any time with or without cause or notice, unless law specifies otherwise.
\n
• Background/Drug Screening: Employment is contingent upon successful completion of a drug test, state background check, and federal fingerprinting.
\n
• Disclaimer: This job description is not intended to be all inclusive. Additional duties may be assigned as needed.
\n

Job Type: Full-time