Data Integration Specialist

Data Integration Specialist Royal Oak, MI Job Details Full-time $59,871.74 - $75,000.00 a year 1 day ago Benefits Health savings account Disability insurance Health insurance Dental insurance 401(k) Flexible spending account Paid time off Parental leave 401(k) 5% Match Vision insurance Life insurance Pet insurance Qualifications Customer inquiry handling Full Job Description

LOCATION

Fully Remote - FL, IL, KS, MI, OH, PA, TX, UT, & WI only

POSITION SUMMARY

We are seeking a Data Integration Specialist to hands-on integration and implementation efforts for our SaaS-based technology products. This role focuses on configuring system integrations, mapping and validating data, and troubleshooting technical issues while partnering with internal teams, client HR/IT stakeholders, and third-party vendors.

DUTIES & RESPONSIBILITIES

Lead client and partner integration setup and execution, including secure credential configuration, data mapping, and

SFTP/API

connections. Support ETL-style data flows to transform and load data across formats such as CSV, JSON, and XML. Configure and monitor API-based integrations using supported tools; manage secure

SFTP/FTPS

file transfers. Write and execute approved SQL queries to extract data and perform data quality validation and reconciliation. Partner day-to-day with Customer Success and internal support teams to perform frequent database lookups and provide timely, accurate data needed to resolve client inquiries. Develop and execute integration test plans; monitor job logs and dashboards. Troubleshoot integration issues, including authentication errors, missing files, data mismatches, and API failures. Support production integrations through incident response, issue analysis, and escalation when needed. Maintain documentation for integration configurations, mappings, and support procedures. Ensure integrations align with established data security and privacy requirements, including encryption, secure authentication, and proper handling of PII. Assist with single sign-on (SSO) setup and validation using PingFederate and PingOne tools.

SKILLS & ABILITIES

Strong SQL skills with experience working in relational databases and maintaining data integrity. Hands-on experience with ETL concepts, RESTful APIs, and data formats (JSON, XML, CSV). Experience configuring and troubleshooting SFTP/FTPS and API-based integrations. Ability to read API documentation and diagnose request/response issues. Knowledge of secure authentication, encryption, and privacy standards for sensitive data. Proven ability to analyze logs, identify issues, and resolve integration failures.

QUALIFICATIONS

Bachelor's degree in Computer Science, Information Systems, or equivalent experience. 2-4 years of experience in data integration or software implementation roles; SaaS or HR Tech experience preferred. Experience working directly with customers or cross-functional teams on technical implementations, with a professional and proactive approach to client service. Familiarity with HRIS/Payroll platforms. High attention to detail, strong organization skills, and ability to adapt quickly in a fast-paced environment. Ability to troubleshoot issues under time constraints while following established processes. Clear written and verbal communication skills; ability to explain technical concepts to non-technical stakeholders. TRAVEL Position may require travel as needed to support clients and/or attend company events.

SUPERVISORY RESPONSIBILITIES

The position has no direct reports.

Total Rewards:

We offer a comprehensive and competitive benefits package designed to support your well-being and work-life balance.

Health Coverage:

Medical, dental, and vision insurance; short- and long-term disability; life insurance; HSA and FSA options. You don't need health insurance? No problem! An opt-out credit will be provided to you for waiving coverage.

Retirement Savings:

401(k) plan with 5% company contribution

Paid Time Off:

Vacation, volunteer time, parental leave, and holidays—including floating holidays for days that matter most to you

Compensation Rewards:

Discretionary year-end bonuses and annual merit increases based on performance. In alignment with pay transparency laws and our compensation philosophy, the expected hiring range for this position is $59,871.74 - $75,000 annually. This range reflects our commitment to internal equity and external competitiveness. Actual pay will depend on experience, qualifications, and budget considerations.

Work-Life Balance:

Flexible remote and hybrid work options

Professional Growth:

Ongoing learning and development opportunities

Wellness & Lifestyle:

Wellness programs, pet insurance, and team member discounts

Community & Connection:

Opportunities to engage, connect, and make an impact

The Company Itself:

CUSG offers leading products and services in the areas of Martech, HR Performance and Financial Empowerment. Our company's dedication to excellence is reflected through superior service to our longstanding clients and our trusted, renowned partners. We are an equal opportunity employer committed to diversity in the workplace. We do not discriminate on the basis of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or any other protected status. We welcome and encourage applications from all qualified individuals. The above information has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.