Responsibilities

• Specific duties of this position include: 
• (i) developing, deploying and maintaining data warehouse models, data pipelines and data infrastructure to meet business use-cases using technologies such as SQL and Python; 
• (ii) designing and implementing scalable database systems that adapt to Lyra Health’s evolving capabilities; 
• (iii) collaborating with key partners including product management, data science, and behavioral health specialists to analyze software/data needs; and 
• (iv) ensuring that software development best practices as well as database quality and security standards are adhered to during all phases of software development. 

Qualifications

• Must have a bachelor’s degree (or foreign equivalent) in Computer Science, Information Technology, Data Informatics, or a directly related field plus a minimum of four (4) years of experience in a directly related position.
• Must also have a minimum of 4 years of experience with each of the following (can be concurrent): 
• (i) Python; 
• (ii) building fault tolerant data pipelines; 
• (iii) implementing, maintaining, and scaling data integration solutions; 
• (iv) implementing and designing data warehouses using MPP databases, such as Presto, Azure Kusto, Snowflake, BigQuery, or Redshift; and 
• (v) building data models using SQL.
• Must also have knowledge of each of the following: 
• (i) SQL; 
• (ii) data visualization tools, such as Tableau, Looker, or Power BI; 
• (iii) AWS, MS Azure, Google Cloud, or another equivalent cloud computing service; and 
• (iv) AWS S3, Azure Blob, Google Storage, or another equivalent cloud storage service.