Ontrakhealth. is making a positive impact on people’s lives every day. We use predictive analytics to identify health plan members with unaddressed behavioral health conditions that worsen chronic disease, then engage, support, and guide these members to better health with a personalized, human-centered approach. This has led us to where we are today: growing fast and saving lives as we do.

Excellent compensation
In addition to a competitive wage, we offer comprehensive benefits including medical, dental and vision insurance; a 401(k) plan; paid holiday, vacation and sick time; flexible spending accounts; Basic Life/AD&D, Employee Assistance Program and Travel Assistance Program and more.

Join Ontrakhealth Team!

Ontrak, Inc. is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status.

Notice to candidates: Please visit our fraud alert to protect yourself from scams targeting job seekers: https://www.ontrak-inc.com/fraud-alert.html

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

Required:

• 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

• 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.