Companies you'll love to work for


Data Architect



Virginia, USA · McLean, VA, USA · United States
Posted on Sunday, June 23, 2024

As the largest and leading value-based kidney care company, Somatus is empowering patients across the country living with chronic kidney disease to experience more days out of the hospital and healthier at home.

It takes a village of passionate and tenacious innovators to revolutionize an industry and support individuals living with a chronic disease to fulfill our purpose of creating More Lives, Better Lived. Does this sound like you?

Showing Up Somatus Strong

We foster an inclusive work environment that promotes collaboration and innovation at every level. Our values bring our mission to life and serve as the DNA for every decision we make:

  • Authenticity: We believe in real dialogue. In any interaction, with patients, partners, vendors, or our teammates, we are true to who we are, say what we mean, and mean what we say.
  • Collaboration: We appreciate what every person at Somatus brings to the table and believe that together we can do and achieve more.
  • Empowerment: We make sure every voice gets heard and all ideas are considered, especially when it comes to our patients’ lives or our partners’ best interests.
  • Innovation: We relentlessly look for ways to improve upon the status quo to continuously deliver new solutions.
  • Tenacity: We see challenges as opportunities for growth and improvement — especially when new solutions will make a difference for our patients and partners.

Showing Up for You

We offer more than 25 Health, Growth, and Wealth Work Perks to help teammates learn, grow, and be the best version of themselves, including:

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

Somatus, the leader in value-based kidney care, has an immediate opening for a Data Architect to create impact among Somatus’ clients and leadership by building data warehouse and 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.

This role will require you to be on-site at our HQ in McLean, VA.


  • Drive innovations by keeping current on emerging technology and Data Trends.
  • Plan, develop, improve, and maintain complex components of the logical/physical Enterprise Data Warehouse and related models.
  • Ensure alignment and collaboration with technology, infrastructure, and business stakeholders, taking ownership for essential data strategy decisions.
  • Establish, maintain, and enforce Enterprise Data Modeling and Data Integration standards.
  • Responsible for the data integration and solution design for ingesting data from various sources to the data warehouse.
  • Mapping of relational entities to use cases or business requirements and assisting in the development of data services.
  • Influence projects to make decisions related to data strategies including data quality, data architecture and data management best practices.
  • Work closely with the other Data Engineers, Data Analytics, and Scientists to deliver results.
  • Understanding of large database mining tools and statistical languages utilized to efficiently build approaches and execute on analytical use cases.
  • Responsible for the technical design, development, testing, maintenance, and optimization of cloud-native data and automated 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.


Required Education and Experience:

  • Bachelor’s degree in computer science, Information Technology, Engineering, Mathematics, or equivalent.
  • 10+ years of hands-on experience in Microsoft SQL Server database development and administration roles.
  • 3+ years of experience in Data Architecture, Data Security, designing ELT solution and including experience developing data governance and access policies.
  • Demonstrated experience in reviewing enterprise and data architecture artifacts, deliverables, and processes for quality standards.
  • 5+ years of experience with at least one database/data warehouse solution (e.g., MySQL, MSSQL, Synapse, Snowflake, RedShift).
  • 3+ years of experience in a Azure environment and Terraform.
  • 2+ years of experience in at least one programming language (preferably Python)
  • Must be able to research, present, and accurately articulate benefits and goals of latest technologies.
  • Experience with data virtualization technologies and visualization tools.
  • 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.
  • 1+ years of EPIC integration experience required.

Knowledge, Skills, and Abilities:

  • 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
  • Excellent communication skills
  • Problem solving aptitude and critical thinking skills.
  • Ability to thrive in a fast paced, changing environment.

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.