Data Operations Assistant (SQL and Database Management)

We’re Hiring: Data Operations Assistant (SQL and Database Management)

Looking for a role that fosters collaboration, creativity and career growth in a vibrant office environment? We got you covered!

We are currently on the lookout for a Data Operations Assistant (SQL and Database Management) to join our team at Cloudstaff, the #1 workplace everywhere! Think you qualify for the role? Attach a 1-2 minute video intro and introduce yourself to us so we can meet you virtually. Attach this together with your updated CV to become a priority applicant!

Role: Data Operations Assistant (SQL and Database Management)

Work Arrangement: Work from Home

Location: Colombia

Schedule: Night Shift

Job description:

The Data Operations Assistant supports the company’s bordereaux (BDX) data intake process, ensuring that incoming data from MGAs and TPAs is accurate, complete, and ready for downstream processing. This role is central to Everspan’s data quality discipline — catching errors early, maintaining documentation, and enabling the Operations team to move quickly and confidently.

There are two focus areas within this role: Premium and TPA (Claims/Losses). Each assistant specializes in one track, though both tracks share a common foundation of BDX quality control and pattern tracking.

Core Responsibilities:

The following responsibilities apply to both the Premium and TPA focus tracks. Track-specific duties are detailed in the section below.

BDX Layout Comparison

• Compare each incoming BDX file against the prior month’s layout

• Flag any fields that have been added, removed, renamed, reordered, or are missing

• Document changes and escalate to the Operations UW Analyst before the file moves forward

Mapping Documentation

• Maintain and update mapping documentation across similar business types

• Document column names, expected data types, and field-level definitions

• Ensure mapping tables remain current as MGA file formats evolve

Code Value Tables

• Monitor coverage code tables for new or unrecognized values

• Flag any codes that do not currently exist or do not match Everspan’s coverage mappings

• Route flagged codes to the Operations UW Analyst for resolution

BDX Quality Control

• Run a quality check on every incoming BDX file prior to processing

• Identify and document missing fields, duplicate records, out-of-range values, and formatting problems

• Ensure all issues are flagged and documented before the file is advanced

Error Summary & Correction Tracking

• Prepare a structured error summary for each file reviewed

• Route the error summary to the Operations UW Analyst

• Once data corrections are received, update the BDX record accordingly and confirm resolution

Recurring Error Pattern Tracking

• Track and report recurring data quality issues by MGA or TPA

• When the same issue appears repeatedly, document the pattern with enough detail to support a systemic fix

• Provide pattern reports to the Operations UW Analyst on a regular cadence

TRACK-SPECIFIC RESPONSIBILITIES

Premium Track

In addition to core responsibilities, the Premium Track assistant focuses on:

• Reviewing high-priority Premium-related BDX rejections

• Assisting in the analysis of rejection root causes specific to premium data (e.g., written premium, earned premium, commission fields)

• Reporting findings and recommendations to the Operations UW Analyst

TPA Track (Claims / Losses)

In addition to core responsibilities, the TPA Track assistant focuses on:

• Maintaining Claims/Losses-specific mapping documentation across TPA file types

• Reviewing high-priority Claims/Losses-related BDX rejections

• Assisting in the analysis of rejection root causes specific to claims data (e.g., paid losses, LAE, loss outstanding, reserve fields)

• Reporting findings and recommendations to the Operations UW Analyst

Non-negotiable skills and requirements:

• Strong experience with SQL and database management
• Strong attention to detail and comfort working with structured data files (CSV, Excel, delimited text)
• Ability to identify patterns in data and communicate findings clearly in writing
• Proficiency in Excel or Google Sheets; familiarity with data comparison and validation techniques
• Organized and self-directed — able to manage a queue of files and maintain documentation with minimal supervision
• Clear written communication skills; comfortable drafting structured error summaries and escalation note

Perks & Benefits:

Comprehensive Legal Benefits (Colombia)

As part of your contract, we ensure all legally mandated benefits are covered—because your well-being is our priority! Here's what you can count on:

• Health Insurance (EPS)
• Pension Coverage
• Severance Pay (Cesantías)
• Family Compensation Fund (CCF)
• Occupational Risk Insurance (ARL)

Exclusive Perks That Go Beyond

We believe in giving more than just the basics. With us, you’ll enjoy:

• Premium Health Insurance (Prepagada)
• Life Insurance, starting from your 16th day with us.
• Flexible Work Setup options—Hybrid, On-site, or Remote. (This can change according to the role you are applying to)
• Access to the CloudStaff Dream Points Program.
• Exciting Growth Opportunities to fuel your career aspirations

Cloudstaff : Build Your Career, Anywhere

Established in 2005, Cloudstaff is a leading outsourcing company that empowers businesses to thrive through smarter talent solutions. We're passionate about creating a work environment that fosters your professional growth and overall well-being.

Why Cloudstaff is the #1 Workplace?

• Award-winning Culture: We're committed to building the #1 Workplace Everywhere, with a proven track record of staff engagement initiatives and industry recognition
• Invest in You: We support your development through comprehensive training programs, mentoring and opportunities for career advancement
• Thrive as an Individual: We offer a strong work-life balance with flexible schedules, meaningful perks and a collaborative team environment.

**To become a priority applicant, please share a 1-2 minute video introduction detailing you experience in this specific role. You can upload your video to the CSJobs platforms. Please use a clean, distraction-free background and speak clearly and articulately.**