Senior Business Intelligence Analyst

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 Overview At Lyra Health, we are transforming how data drives clinical and strategic decisions. We are currently undergoing a major, high-velocity migration from legacy cube environments to a modern data stack centered on Snowflake, dbt, and Tableau (or Sigma). We are looking for a Senior Business Intelligence Analyst who is far more than a dashboard builder. We are looking for someone who can author insights. You have the technical muscle to wrangle messy data independently and the strategic intuition to translate complex logic into plain English for business leaders. You thrive in environments undergoing massive structural change, viewing tool transitions not as a disruption, but as an opportunity to build a faster, more reliable single source of truth. Location: Remote, South Africa Hours: 8am to 5pm; The role is a permanent five (5) day a week role (Monday to Friday). Wi-Fi: While working off-site/remotely, the individual is expected to have reliable backup power supply and a strong, stable Wi-Fi connection as these are essential requirements for effectively performing in a remote capacity. Flexibility: Given the global nature of the business, the successful candidate must be flexible to attend meetings outside standard local working hours to accommodate global clients and teams on occasion Responsibilities: Core SQL execution & modern data transformation: Write advanced, highly optimised SQL queries to extract, manipulate, and analyse complex datasets across changing environments Partner closely with Data Engineering and Data Science to adopt and build dbt models, ensuring business and clinical logic is modular, tested, and cleanly documented Actively participate in our migration to Snowflake, quickly mapping legacy data structures (cubes/spreadsheets) into modern cloud data warehouse topologies High-impact report building & visualisation: Own the end-to-end design and delivery of executive-ready dashboards in PBI, Tableau (or Sigma), shifting our consumers away from static sheets to interactive, self-service insights Maintain a ruthless standard for data accuracy, implementing personal audit and unit-testing processes to ensure reports are 100% accurate before they reach stakeholders The "Author" Mindset & Stakeholder Collaboration: Take vague, complex business and clinical questions and independently design the underlying data logic Deliver a crisp "Draft 1" to the hiring manager. This draft isn’t raw code; it is a plain-English flowchart of your logic, a data output sample, or a visual dashboard wireframe ready for strategic refinement Act as a translator who can communicate technical data constraints to non-technical stakeholders calmly and clearly, protecting the team’s timeline from scope-creep Required Skills & Experience: 3+ years minimum of experience in business intelligence, data analytics, or intelligence reporting Advanced SQL Mastery: Expert-level ability to write complex queries, joins, and window functions across messy, relational databases Visualiszation Expert: Proven track record of building intuitive, scalable dashboard suites (highly prefer Tableau, PowerBI, or Sigma) Adaptive Tech Stack Learner: Direct experience with, or a fierce appetite to rapidly self-teach, Snowflake and dbt as we sunset our legacy systems Rigor & Documentation: A personal philosophy that "documentation is part of the code." You naturally leave a clean paper trail (data dictionaries, wikis) so the broader team can easily scale your work. Environment: Comfortable operating across the Google Stack, Slack-driven communication, and adapting to shifting corporate data landscapes. You embrace change: You don't freeze when the underlying infrastructure moves; you jump on the learning journey alongside the team. You are collaborative: You view feedback and rigorous peer reviews as "strategic editing" that sharpens your work, not a critique of your capability. You don’t wait for a blueprint: You enjoy the autonomy of exploring data, finding the gaps, and bringing recommendations to the table rather than waiting for a micro-task list. Qualifications: Tertiary degree or diploma in Statistics and Computer Sciences, Social Sciences/Humanities, Sociology, Health Sciences, Data Analytics, Science, Data Science, Finance or Business Management Good knowledge in SSIS, SSRS, PowerBI and Tableau or Sigma Ability to develop SSAS cubes in SQL server, including Tabular models Excellent knowledge of SQL queries, stored procedures and triggers " 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 [email protected] . For more information about how we use and retain your information, please see our Workforce Privacy Notice ."