分析工程师
Analytics Engineer
关于Lyra
Lyra Health是全球雇主心理健康解决方案的领先提供商，为超过2000万人提供服务。公司已提供1300万次心理健康护理，发表了20多篇同行评审研究，并在可及性、临床效果和成本效率方面取得了无与伦比的成果。大量经过同行评审的研究证实，Lyra的创新护理模式使人们恢复速度提高一倍，并导致整体医疗费用每年减少26%。Lyra通过Lyra Empower平台，彻底改变了获得改变生活的心理健康护理的途径，这是唯一一个完全集成的、人工智能驱动的平台，结合了最高质量的护理和科技解决方案。
职位概述
国际数据团队正在对其数据架构进行全面转型，从传统的SQL服务器、Azure Data Factory、SSAS和Power BI技术栈迁移到Snowflake、dbt、Airflow、Tableau和Sigma。
此次机会将使成功候选人有机会与团队分享Snowflake和dbt的最佳实践经验，同时也有机会从零开始构建数据基础设施。
我们是一家平等机会雇主。我们不会基于种族、肤色、宗教、性别（包括怀孕）、国籍、年龄、残疾、基因信息或任何受法律保护的其他类别进行歧视。
申请此职位即表示您确认您的个人信息将按照Lyra Health员工隐私声明进行处理。通过此申请，根据法律规定，我们将收集您的个人信息，包括但不限于您的姓名、电子邮件地址、性别认同、就业信息和电话号码，用于招聘和评估您是否适合、具备能力、技能、资格和兴趣从事Lyra的工作。我们还可能收集有关您种族、族裔和性取向的信息，这在《加州隐私权利法案》（CPRA）下被视为敏感个人数据，在英国和欧盟GDPR下被视为特殊类别的数据。提供这些信息是可选且完全自愿的，如果您提供这些信息，即表示您同意Lyra按照收集时说明的目的对其进行处理，例如用于多元化和包容性计划。如果您是加利福尼亚州居民并希望限制我们使用这些信息，请使用“限制我敏感个人信息的使用”功能。
查看英文原文
About Lyra
Lyra Health is the leading provider of mental health solutions for employers supporting more than 20 million people globally. The company has delivered 13 million sessions of mental health care, published more than 20 peer-reviewed studies, and delivered unmatched outcomes in terms of access, clinical effectiveness and cost efficiency. Extensive peer-reviewed research confirms Lyra’s transformative care model helps people recover twice as fast and results in a 26% annual reduction in overall healthcare claims costs. Lyra is transforming access to life-changing mental health care through Lyra Empower, the only fully integrated, AI-powered platform combining the highest-quality care and technology solutions.
Role OverviewThe international data team is undergoing a complete transformation of their data architecture, migration from a legacy SQL server, Azure Data Factory, SSAS and Power BI stack to Snowflake, dbt, Airflow, Tableau and Sigma.
This opportunity will give the successful candidate a chance to share knowledge about best practices with Snowflake and dbt with the team, as well as a chance to build data infrastructure from scratch.
"We are an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex (including pregnancy), national origin, age, disability, genetic information or any other category protected by law.
By applying for this position, you acknowledge that your personal information will be processed as per the Lyra Health Workforce Privacy Notice. Through this application, to the extent permitted by law, we will collect personal information from you including, but not limited to, your name, email address, gender identity, employment information, and phone number for the purposes of recruiting and assessing suitability, aptitude, skills, qualifications, and interests for employment with Lyra. We may also collect information about your race, ethnicity, and sexual orientation, which is considered sensitive personal information under the California Privacy Rights Act (CPRA) and special category data under the UK and EU GDPR. Providing this information is optional and completely voluntary, and if you provide it you consent to Lyra processing it for the purposes as described at the point of collection, for example for diversity and inclusion initiatives. If you are a California resident and would like to limit how we use this information, please use the Limit the Use of My Sensitive Personal Information form. This information will only be retained for as long as needed to fulfill the purposes for which it was collected, as described above. Please note that Lyra does not “sell” or “share” personal information as defined by the CPRA. Outside of the United States, for example in the EU, Switzerland and the UK, you may have the right to request access to, or a copy of, your personal information, including in a portable format; request that we delete your information from our systems; object to or restrict processing of your information; or correct inaccurate or outdated personal information in our systems. These rights may be subject to legal limitations. To exercise your data privacy rights outside of the United States, please contact globaldpo@lyrahealth.com. For more information about how we use and retain your information, please see our Workforce Privacy Notice."
Key Responsibilities:
- Build and maintain pipelines to ingest data from Salesforce and various other data sources
- Build and maintain dbt models to transform data using Medallion architecture for use by business intelligence tools
- Work closely with our Business Intelligence team - monitoring and implementing enhancement requests for the data warehouse to meet the reporting demands of stakeholders
- Work collaboratively with team members in different timezones
The successful candidate will also be given the opportunity to develop mentoring skills as we look to expand the team’s skillset to match those of our counterpart US team. As we work collaboratively with team members in different time zones, it is important that the candidate has strong interpersonal skills.
Requirements:
- 3+ years experience in data engineering
- Experience in development of pipelines to ingest and transform data from sources using REST APIs, AWS S3 and Airflow
- Experience in building dbt models to transform data using Medallion architecture
- Experience in maintaining dimensional data models with Type 2 SCDs and star schemas
- Experience in maintaining data warehouses on SQL Server
- Experience working with Snowflake, dbt and Tableau is essential