200+ applicants

Company

Ontrak Health · 2 days ago

Director of Data Integration

United States

Full-time

Remote

Director/Executive

$180K/yr - $198K/yr

7+ years exp

Maximize your interview chances

Artificial Intelligence (AI)Health Care

H1B Sponsor Likely

Insider Connection @Ontrak Health

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Supervise subject matter experts in ETL/EDI processes, merging data from diverse sources and designing scalable integration processes. Oversee troubleshooting and resolution of issues using various tools (Informatica, T-SQL/SSIS, Python, R, Microsoft Fabric, x12 HIPAA EDI).

Conduct routine system monitoring, ensuring reliability, health, and availability. Validate data mapping quality between canonical models and various data formats (X12 EDI, FHIR, JSON, XML, proprietary).

Manage data ingestion and processing from multiple sources and file types (SQL, Flat-Files, RDBMS, APIs, FTPs, cloud storage). Handle common EDI standards and formats including XML and cXML. Document data systems configurations, test plans, and functional specs.

Execute database administration tasks to ensure SQL databases' high availability. Identify automation opportunities to boost business efficiency and support complex data-related problems.

Represent architecture and development teams in Data Governance Council & present Data Integration approval requests at HITRUST Change Advisory Board (CAB) meetings, ensuring seamless data integration and flow across organizational systems.

Collaborate with stakeholders to determine project requirements and develop ETL workflows using Informatica, Microsoft Data Fabric and other similar tools.

Work with the data team to manage batch and real-time data engineering needs, integrating data pipelines and ETL processes into the CI/CD framework. Promote data integrity, security, and continuous improvement of data quality through robust data management solutions.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data ETL developmentX12 HIPAA EDISQLT-SQLPythonRInformaticaMicrosoft FabricAPIsRelational databasesDatabase administrationHealth Care dataData processing flowchartingHIPAA data privacyAgile environmentData Management toolsVersion controlNetsmart productsTeamwork abilities

Required

Bachelor's Degree in Computer Science, Information Systems, or a related technical discipline

7-10 years of experience in the direct supervision and management of staff responsible for Data ETL development, specifically using the EDI x12 transactions.

Advanced proficiency in SQL, T-SQL, Python, R, and other ETL tools

Public company experience with a SOX and/or HITRUST control environment is preferred.

Proven experience as an Engineering Manager with a focus on cloud-based solutions.

Experience with ETL, x12 HIPAA EDI transaction sets and APIs.

A solid understanding of relational database structures, theories, principles, and practices.

Proficiency in data processing flowcharting techniques.

A strong grasp of organizational goals and objectives to drive team member performance.

Awareness of applicable HIPAA data privacy practices and laws.

Exceptional problem-solving and analytical skills.

Excellent communication and teamwork abilities.

Experience working in an Agile environment.

Strong knowledge of Microsoft SQL Server, T-SQL programming, and database administration.

Comfortable working with large raw data files (Csv, Txt , EDI) is necessary editing, manipulating, searching.

Experience working with Health Care data, or Behavioral Health Data and processes.

Tech-savvy, passionate, and inquisitive about Data Management tools, technologies, strategies, trends, and solutions.

Motivated, creative, and committed to ensuring the success of Data Management initiatives.

Preferred

Relevant certifications (e.g., Microsoft Certified: Data Analyst Associate, Microsoft Certified: Azure Data Engineer Associate, Microsoft Certified: Power BI, etc.)

Experience working with Microsoft Fabric, PowerShell, Python, SSIS, Informatica or other ETL tools.

Experience using GitHub for version control and deployment.

A solid grasp of SSAS-based data modeling principles.

Experience with Health Insurance or Health Care related data EDI X12 Formats

Preference for experience with Netsmart’s suite of products including myEvolv

Company

Ontrak Health

Glassdoor

2.6

Ontrak Health is an AI and technology-enabled behavioral health company.

Founded in 2003

Henderson, Nevada, USA

201-500 employees

https://ontrakhealth.com

H1B Sponsorship

Ontrak Health has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2021 (3)

2020 (1)