Lyra Health

Business Intelligence Analyst

Lyra Health

full-time

Posted on:

Location Type: Remote

Location: South Africa

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ETLSQLSSISTableau

About the role

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

Requirements

  • Tertiary degree or diploma in Social Sciences/Humanities, Sociology, Health Sciences, Data Analytics, Science, Data Science, Finance or Business Management
  • 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.
Benefits
  • Holidays: 21 days per year + public holidays (Full time)
  • Discretionary bonus scheme
  • Group Life Cover
  • Disability Cover
  • Employee Assistance Programme
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLT-SQLdata analysisdata miningreport writingdata transformationETL processesdata warehousingSSASExcel
Soft Skills
communicationproblem-solvingcollaborationattention to detailanalytical thinking