Data Engineer

Atreo develops SaaS RTSM technology for clinical trials. The Data Engineer executes data changes, builds client-specified CSV and SAS transfers, implements SQL integrations, and investigates production incidents while collaborating with Client Services and Product.

Responsibilities:

• Execute and own data change requests end-to-end: assess impact, write and peer-review scripts, apply in production, document outcome
• Build CSV and SAS data transfers independently from a client spec with full validation before delivery
• Implement integrations with external platforms by translating specs into SQL scripts and database objects, tested before production
• Investigate and resolve production incidents: identify root cause, apply fix, follow up with CS on resolution, and create bug ticket if needed
• Debug environment-specific issues raised by CS by reproducing them locally across the relevant product version
• Create and maintain template scripts for recurring manual tasks; document usage so the team can self-serve

Requirements:

• Solid SQL: writes complex queries, stored procedures, data updates, and validates data integrity before/after execution
• Independently creates CSV and SAS data transfers end-to-end: spec review, script creation, validation, and delivery
• Follows integration specs to design and implement SQL-based integrations with external platforms independently
• Understands RTSM project configuration: randomization algorithms, stratification factors, depot/kit logic, and visit schedules
• Debugs production incidents across multiple product versions, read logs, identifies root cause, applies fix, and coordinates with CS
• Familiar with version release notes: can identify functional changes, assess impact on existing scripts/templates, and make adjustments
• Strong communication skills with the ability to convey technical findings to Client Services and non-technical stakeholders
• Familiarity with Agile methodologies and sprint-based delivery
• Able to independently solve problems, identify root causes, and propose efficient, value-adding solutions
• Keeps up to speed on RTSM product releases and incorporates changes into templates and scripts proactively
• Takes ownership of work end-to-end: from spec review through production execution and CS follow-up
• SQL (complex queries, stored procedures, data updates, integrity validation)
• CSV and SAS data transfer construction and validation
• Integration implementation via SQL scripts and database objects
• Source control usage (git preferred)
• Log reading, incident triage, and environment reproduction across product versions
• Bachelor's degree in Computer Science, Information Systems, or related field
• 2–4 years of software development or data engineering experience
• Authorized to work in the United States