ABOUT LYRA HEALTH

Lyra is transforming mental health care through technology with a human touch to help people feel emotionally healthy at work and at home. We work with industry leaders, such as Morgan Stanley, Uber, Amgen, and other Fortune 500 companies, to improve access to effective, high-quality mental health care for their employees and their families. With our innovative digital care platform and global provider network, nearly 20 million people can receive the best care and feel better, faster. Founded by David Ebersman, former CFO of Facebook and Genentech, Lyra has raised more than $900 million.
Lyra Health is recruiting a Business Intelligence Analyst to assist with Analytics for Lyra South Africa. Reporting to the Director of BI and Consulting, you will play a key role in supporting the company’s period of growth and change and be a role model for the expected behaviours and attitudes.

QUALIFICATIONS

• Tertiary degree or diploma in Social Sciences/Humanities, Sociology, Health Sciences, Data Analytics, Science, Data Science, Finance or Business Management

EXPERIENCE

• Advanced excel skills (writing macros, designing pivot tables, linking sheets and testing calculations (in Excel or where gaps) on machine data) is essential
• Strong report writing skills, preferably with Microsoft SSRS and Power BI.
• Minimum of 3 years’ experience in transforming data into intelligence – manipulating data, creating transformations, analysing data, creating reports and dashboards.
• A strong knowledge and experience of data systems, data structures and data models.
• Solid experience with T-SQL
• Familiarity with ETL processes and data warehousing concepts.
• Good knowledge in SSIS, SSRS, PowerBI and Tableau
• Ability to develop SSAS cubes in SQL server, including Tabular models.
• Excellent knowledge of SQL queries, stored procedures and triggers.

• Interact with Business Analysts and Systems Architects to understand data sources.
• Interact with the business to gather and understand requirements.
• Write code to be used in the reports and dashboards (SQL queries)
• Develop final asset (report, cube, dynamic/static dashboard) using Microsoft reporting tools.
• Perform unit testing.
• Debug and troubleshoot issues raised by our stakeholders.
• Import data into Excel and merge data sets for the analysis of information
• Understand key structures, data inputs, data relationships and data tables
• Check & maintain data for integrity
• Conduct data mining activities for the analysis of trends and other information
• Suggest further fields or data tables for future versions of reporting
• Run standard monthly customer and business-related reports