Business Intelligence Analyst
Remote, South Africa Remote, South AfricaJob Description
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.
Key Responsibilities
- 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
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.
About You
- Background in mental health, wellbeing, health, employee assistance programmes will be an advantage
- Ability to function effectively under pressure
- Ability to multi-task
- Excellent ability to communicate in English (both written and verbal)
- Professional and quality orientated approach to work
- Structured approach to work
- Willingness to learn
- Ability to receive constructive feedback.
- Enthusiastic, self-motivated and able to work within a project based environment
- Able to work independently and as part of a team
- Adaptable and open to change
- Aware of impact of own actions on workload of others and the business (self-responsibility)
- Quality oriented.
Why Lyra?
- Holidays: 21 days per year + public holidays (Full time)
- Discretionary bonus scheme
- Group Life Cover
- Disability Cover
- Employee Assistance Programme
"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."
The benefits available to those located in the South Africa. will be consistent with South Africa law and may vary from those located in other countries. Benefits will be provided in a manner consistent with applicable law.
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.
Key Responsibilities
- 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
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.
About You
- Background in mental health, wellbeing, health, employee assistance programmes will be an advantage
- Ability to function effectively under pressure
- Ability to multi-task
- Excellent ability to communicate in English (both written and verbal)
- Professional and quality orientated approach to work
- Structured approach to work
- Willingness to learn
- Ability to receive constructive feedback.
- Enthusiastic, self-motivated and able to work within a project based environment
- Able to work independently and as part of a team
- Adaptable and open to change
- Aware of impact of own actions on workload of others and the business (self-responsibility)
- Quality oriented.
Why Lyra?
- Holidays: 21 days per year + public holidays (Full time)
- Discretionary bonus scheme
- Group Life Cover
- Disability Cover
- Employee Assistance Programme
"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."
The benefits available to those located in the South Africa. will be consistent with South Africa law and may vary from those located in other countries. Benefits will be provided in a manner consistent with applicable law.
Job Description
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.
Key Responsibilities
- 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
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.
About You
- Background in mental health, wellbeing, health, employee assistance programmes will be an advantage
- Ability to function effectively under pressure
- Ability to multi-task
- Excellent ability to communicate in English (both written and verbal)
- Professional and quality orientated approach to work
- Structured approach to work
- Willingness to learn
- Ability to receive constructive feedback.
- Enthusiastic, self-motivated and able to work within a project based environment
- Able to work independently and as part of a team
- Adaptable and open to change
- Aware of impact of own actions on workload of others and the business (self-responsibility)
- Quality oriented.
Why Lyra?
- Holidays: 21 days per year + public holidays (Full time)
- Discretionary bonus scheme
- Group Life Cover
- Disability Cover
- Employee Assistance Programme
"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."
The benefits available to those located in the South Africa. will be consistent with South Africa law and may vary from those located in other countries. Benefits will be provided in a manner consistent with applicable law.
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.
Key Responsibilities
- 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
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.
About You
- Background in mental health, wellbeing, health, employee assistance programmes will be an advantage
- Ability to function effectively under pressure
- Ability to multi-task
- Excellent ability to communicate in English (both written and verbal)
- Professional and quality orientated approach to work
- Structured approach to work
- Willingness to learn
- Ability to receive constructive feedback.
- Enthusiastic, self-motivated and able to work within a project based environment
- Able to work independently and as part of a team
- Adaptable and open to change
- Aware of impact of own actions on workload of others and the business (self-responsibility)
- Quality oriented.
Why Lyra?
- Holidays: 21 days per year + public holidays (Full time)
- Discretionary bonus scheme
- Group Life Cover
- Disability Cover
- Employee Assistance Programme
"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."
The benefits available to those located in the South Africa. will be consistent with South Africa law and may vary from those located in other countries. Benefits will be provided in a manner consistent with applicable law.
Related Content
Jobs for you
Featured Jobs
You have no Recently Viewed Jobs
You have no Saved Jobs