Key Facts

Remote From:

South Africa

Full time

Mid-level (2-5 years)

English

Hard Skills

SQL (Programming Language) Python (Programming Language) Data Engineering Data Modeling Star Schema

Other Skills

•
Social Skills

Roles & Responsibilities

3+ years of experience in data engineering, ideally including cloud migration to Snowflake
Strong SQL skills (CTEs and window functions)
Proficiency in Python for building pipelines with Snowpark
Experience designing multi-dimensional data models with star schema and Type 2 SCDs

Requirements:

Report to the team lead and be a key contributor to our migration from a legacy SQL Server data stack to a modern cloud data stack consisting of Snowflake, dbt and Tableau
Design and build data pipelines using Snowpark and/or Snowpipe where native connectors do not exist for Snowflake for various data sources
Contribute to designing and building a new multi-dimensional data model in Snowflake
Work closely with our Business Intelligence Analytics team - monitoring and implementing enhancement requests for the data warehouse to meet the reporting demands of stakeholders

Lyra Health

About Lyra Health

Lyra Health is a leading provider of innovative mental health benefits for more than 2.5 million global employees and dependents and is transforming mental health care by creating a frictionless experience for members, providers, and employers. Using matching technology and an innovative digital platform, Lyra quickly connects companies and their employees — plus spouses and children — to world-class therapists, mental health coaches, and personalized medication prescribing. Leading employers partner with Lyra to deliver tailored, value-driven mental health benefits to their people. With Lyra, benefits leaders can offer employees fast, reliable access to providers who practice evidence-based mental health care treatments. For more information, visit lyrahealth.com and follow us on LinkedIn, Facebook, and Twitter. Please be cautious of potential recruitment fraud. If you are interested in exploring opportunities at Lyra, please go directly to our Careers Page: https://lnkd.in/gKEGj8uy Lyra Health will never ask you to download software, purchase equipment, or pay a fee of any sort to explore employment opportunities with our company. In addition, Lyra will not ask for your personal banking information until you are ready to be onboarded as an employee, which will only occur after several rounds of interviews with our company, the completion of necessary onboarding paperwork, and the issuance of an offer letter for employment. Our recruiting emails come from @lyrahealth.com or @lyraclinical.com addresses and will never originate from gmail.com, yahoo.com, or other commercial email services.

Company type: SME

Industry:

Founded: 2018

Company size: 501 - 1000

Website LinkedIn See all jobs →

Job description

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.

Key Responsibilities:

Report to the team lead and be a key contributor to our migration from a legacy SQL Server data stack to a modern cloud data stack consisting of Snowflake, dbt and Tableau
Design and build data pipelines using Snowpark and/or Snowpipe where native connectors do not exist for Snowflake for various data sources
Contribute to designing and building a new multi-dimensional data model in Snowflake
Work closely with our Business Intelligence Analytics team - monitoring and implementing enhancement requests for the data warehouse to meet the reporting demands of stakeholders

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 of experience in data engineering, ideally including cloud migration to Snowflake
Strong SQL skills (CTEs and window functions)
Proficiency in Python for building pipelines with Snowpark
Experience designing multi-dimensional data models with star schema and Type 2 SCDs
Experience with dbt for building robust ELT processes

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

Ready to apply?

APPLY

Share ·