Data Engineer

Somatus - McLean, VA

Full-time - Entry Level

McLean, VA

1,001-5,000 employees

Ambulatory Health Care Services

About the position

The Data Engineer at Somatus plays a crucial role in developing, testing, and maintaining ETL solutions that drive clinical operations, advanced analytics, and machine learning models. This position collaborates with various teams to ensure high-quality data processing and integration from diverse sources, ultimately supporting the company's mission of improving the lives of patients with chronic kidney disease.

Responsibilities

• Ensure that data processed into our data warehouse is of high quality and reliability, avoiding 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 processes.
• 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 solutions, ensuring the accuracy of Data Analytics and ETL pipelines.
• Responsible for the technical design, development, testing, maintenance, and optimization of cloud-native data and ETL solutions.
• Contribute to workstream planning processes 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 process, using tools such as JIRA, Confluence, and video communication to enhance collaboration, documentation, and transparency.
• Follow DevOps/DataOps best practices throughout the Software Development Life Cycle (SDLC).

Requirements

• 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.
• 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).
• Proficient in writing SQL Code for SQL queries, views, stored procedures, etc.
• Experience using industry standard Python libraries for data exploration, analysis, and transformation (e.g., Pandas, Numpy, etc.).
• Experience using REST APIs.

Nice-to-haves

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

Benefits

• Subsidized personal healthcare coverage (medical, dental, vision)
• Flexible PTO
• Professional Development, CEU, and Tuition Reimbursement
• Curated Wellness Benefits supporting teammates' physical and mental well-being
• Community engagement opportunities