Senior SQL Data Integration Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Develop, sustain, and analyze SQL-based data integrations from inception to completion, encompassing clinical, operational, and financial data sourced from healthcare systems.

• Troubleshoot pipeline failures, discrepancies, and data quality challenges by identifying their precise root causes.

• Navigate complex data architectures, relationships, and business logic while accommodating variations across client environments.

• Create reusable tools, such as extraction frameworks, automation scripts, and validation utilities, to expedite integrations and enhance reliability.

• Document data models, field mappings, business logic, and customer-specific configurations to ensure clarity and reusability of knowledge.

• Collaborate with platform engineers to convert integration insights into scalable infrastructure and standardized data models.

• Engage with customer technical teams to set up secure data access, translate business requirements into technical specifications, explore data structures, and address integration obstacles.

⛳️ Requirements

• Proficient SQL capabilities, including complex queries, joins, performance optimization, along with extensive experience in large relational databases.

• At least 8 years of professional experience.

• Practical experience with behavioral healthcare data systems and EHR/EMR platforms, along with a robust understanding of their underlying data structures and interrelations.

• Experience with data extraction, ETL/ELT processes, data modeling, and data quality assurance.

• Capability to independently navigate intricate data environments and tackle challenging technical issues.

• Excellent documentation skills, keen attention to detail, and an engineering-oriented mindset focused on automation and reusability.

• Ability to effectively collaborate with platform engineering, product teams, and customer technical teams in a cross-functional environment.

• Preferred: Knowledge of Python or other programming languages for data engineering and automation.

• Preferred: Familiarity with cloud data platforms (AWS, Azure, GCP).

🏝️ Benefits

• A team of exceptional individuals united by a common vision and the relentless drive to achieve it.

• Opportunity to innovate, grow, and play a pivotal role in enhancing the effectiveness of therapy through technology.

• Fully remote work setup.

• Competitive health and wellness benefits, mental health support, and life and AD&D insurance.

• Significant equity options and a 401(k) plan with up to 4% matching.

• Company-sponsored retirement plan.

• Global business travel insurance for you and accompanying dependents.

• Budget for domestic conferences and an annual learning & development allowance.

• Remote work stipend.

• Generous paid time off, additional mental health days, and paid leave for personal care and important life events.

• Coverage for fertility treatments and family planning.

• Annual learning & development allocation.

• Employee resource groups and team-led celebrations and events.