Overview

Somatus, the leader in value-based kidney care, has an immediate opening for a Data Engineer QA to create impact among Somatus’ clients and leadership by developing and testing and maintaining ETL solutions to drive clinical operations, advanced analytics, and machine learning models. This position will work collaboratively with the technology team to support our clinical, operational, and finance teams to integrate data from diverse sources for consumption by internal and external stakeholders.

Responsibilities

• Ensure that data processed into our data warehouse is of high quality and reliability, and that we avoid functional and regression defects.

• Collaborate closely with cross-functional teams, including product managers, data engineers, BI developers, and data scientists, to identify, report, and help resolve issues in our data-driven.

• Utilize JIRA/Azure DevOps for managing work, test cases and testing execution.

• Create clear and concise defect details describing actual versus expected behaviors.

• Implement automated testing solution, and ensuring accuracy of Data Analytics, ETL pipelines.

• Responsible for the technical design, development, testing, maintenance, and optimization of cloud-native data and ETL solutions.

• Contribute to workstream planning process including inception, requirements gathering, technical design, development, testing and delivery of ETL solutions.

• Collaborate with Analytics & Reporting, Data Science, Machine Learning, Analytics Engineering, IT Infrastructure, and other Technology teams in solution design, development, and deployment.

• Implement and adhere to security guidelines to safeguard Protected Health Information (PHI) and establish secure communication channels for data transfer.

• Exercise Agile methodologies throughout the development processing, using tools such as JIRA, confluence, and video communication to enhance collaboration, documentation, and transparency.

• Follow DevOps/DataOps best practices throughout Software Development Life Cycle (SDLC).

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Qualifications

Required Education and Experience:

• Bachelor’s degree in computer science, Information Technology, Engineering, Mathematics, or equivalent.

• 2+ years professional experience in Data Engineering (or similar) role.

• Experience in designing and implementing data applications and data architectures.

• Experience with open-source data frameworks like Spark and/or experience with cloud data platforms is preferred.

• Healthcare experience in a Payer or Provider/Hospital Organization preferred.

• Experience in Azure data technologies is a bonus (Azure Data Factory, Synapse, Cosmos DB, Azure SQL).

• Experience with DevOps/DataOps practices is a bonus.

• Experience or familiar with Agile or a similar process.

Knowledge, Skills, and Abilities:

• 5+ years of experience with at least one database/data warehouse solution (e.g., MySQL, MSSQL, Synapse, Snowflake, RedShift).

• 2+ years of experience in at least one programming language (preferably Python)

• Experience using industry standard Python libraries for data exploration, analysis, and transformation (e.g., Pandas, Numpy, etc.)

• Experience using REST APIs

• Proficient in writing SQL Code for SQL queries, views, stored procedures, etc.

• Experience working with data housed in file formats including TXT, CSV, JSON, YAML, Parquet, XLSX

• Problem-solving aptitude and critical thinking skills

• Excellent communication and presentation skills

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Our priority is the health and safety of our members, colleagues, partners, and community. Proof of COVID-19 Vaccination is required for employment. If you are unable to be vaccinated for medical reasons or sincerely-held religious beliefs, we will consider requests for reasonable accommodations consistent with our policy, and where we are able to provide such accommodations without undue hardship to the company pursuant to applicable law.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Somatus, Inc. provides equal employment opportunity to all individuals regardless of their race, color, creed, religion, gender, age, sexual orientation, national origin, disability, veteran status, or any other characteristic protected by state, federal, or local law. Further, the company takes affirmative action to ensure that applicants are employed, and employees are treated during employment without regard to any of these characteristics. Discrimination of any type will not be tolerated.