Data Engineer

Overview: Atreo, a revolutionary start up SaaS RTSM company, is committed to modernizing and simplifying the Clinical Trials process through our revolutionary RTSM technology. Our mission is to create the ‘go to’ RTSM platform for the Pharmaceutical / Biotech industries, offering numerous advantages and efficiencies to both clients and internal team members, creating a solid foundation for clinical trial success in partnership with our clients.

As a Data Engineer your focus will be on independently executing data change requests end-to-end, building CSV and SAS data transfers from client specifications, implementing SQL-based integrations with external platforms, and investigating and resolving production incidents. You will work closely with Client Services and the Product team to ensure data integrity, operational reliability, and continuous process improvement.

Job Skillset:

• 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

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

Proficiencies:

• 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

Technical Proficiencies:

• 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

Professional Requirements:

• 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