Data Operations Specialist

Job Description

Job Description

Position Title :   Data Operations Specialist

Department :    IT

Reports to :    Director of IT

Location :     Within 30 miles of Tulsa

Position Summary :

We’re seeking a Data Operations Specialist who thrives on customer interaction, excels at managing complex tasks end-to-end, and loves diving into SQL to solve data challenges. In this role, you’ll oversee new-customer implementations, monitor ongoing data feeds, and partner closely with internal teams and external clients to ensure data accuracy, timeliness, and reliability. If you’re eager to take ownership, drive process improvements, and grow your skills in a fast-paced environment, this is the job for you.

Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States

Key Responsibilities :

You’ll manage the end-to-end lifecycle of customer data transmissions. By establishing and managing SFTP connections, collaborating with clients to design and finalize data layouts, architect transmission schedules, and rigorously validating each initial file delivery for accuracy and timeliness

Serve as the Dedicated Customer Data liaison, proactively communicating progress, swiftly reporting issues, and ensuring stakeholders feel informed and confident

You’ll champion the investigation and escalations the moment a data discrepancy is detected, via automated alerts, audits, or user reports to ensure nothing slips through the cracks

Use Jira, Confluence, or Pipedrive to log every open and resolved data issue, complete with status updates, assigned ownership, and resolution timelines. Give internal teams on-demand access to progress dashboards and key metrics, ensuring full transparency and accountability

Develop and update comprehensive guides for data processes, workflows, and troubleshooting procedures

Craft advanced SQL queries and analytical scripts to dissect complex datasets, pinpoint root-cause issues, and surface actionable insights that drive smarter decisions

Collaborate across teams to refine our task-management framework to eliminate blockers and boost team efficiency

Pitch and implement creative solutions to enhance data accuracy, delivery speed, and customer satisfaction

Required qualifications :

Education :

Bachelor’s Degree in Computer Science, Information Systems, or a related field; or equivalent hands-on experience driving data operations

Proven expertise configuring and securing SFTP connections

Deep familiarity with Fixed-Width, CSV, JSON, XML, and other formats—plus mastery of validation tools to catch anomalies before they propagate

Craft complex queries, optimize stored procedures, and troubleshoot massive datasets with surgical precision

Hands-on experience crafting end-to-end data extraction, transformation, and load workflows using T-SQL and SQL Server Integration Services

Outstanding written and verbal skills, able to translate technical nuances into clear action plans for both internal teams and external partners

A detective mindset for root-cause analysis, paired with the creativity to design permanent fixes that elevate data quality

Comfortable navigating WinSCP, FileZilla, or other FTP clients—and quick to adopt new platforms and dashboards

Thrives in fast-paced environments, expertly balancing multiple projects and deadlines without missing a beat

Data Transmission Experience : 3-5 years

Medical / Healthcare background Experience : 1 year

About SmartLight Analytics

SmartLight Analytics was formed by a group of industry insiders who wanted to make a meaningful impact on the rising cost of healthcare. With this end in mind, SmartLight works for self-funded employers to reduce the wasteful spend in their healthcare plan through our proprietary data analysis. Our process works behind the scenes to save money without interrupting employee benefits or requiring employee behavior changes.

Powered by JazzHR

yBS66A2389