Sub-Saharan AfricaJob DescriptionSub-Saharan Africa

Sub-Saharan AfricaWe are seeking a SQL expert to write custom queries and generate detailed reports for our clients who are boutique fitness studios (yoga, Pilates, barre, etc). Your role will involve not only writing SQL queries but also ensuring data accuracy and consistency to meet client expectations.Sub-Saharan Africa

Sub-Saharan AfricaKey Responsibilities:Sub-Saharan Africa

• Sub-Saharan AfricaWrite custom SQL queries to retrieve and compile data from our PostgreSQL database.Sub-Saharan Africa
• Sub-Saharan AfricaGenerate comprehensive reports for clients, outputting results in CSV format.Sub-Saharan Africa
• Sub-Saharan AfricaGenerate reports including metrics such as:Sub-Saharan Africa
• Sub-Saharan AfricaNumber of prospective clients ("leads") generated by the studio, segmented by source (e.g., organic, Facebook Ads, Instagram, etc.).Sub-Saharan Africa
• Sub-Saharan AfricaConversion of these leads into class bookings.Sub-Saharan Africa
• Sub-Saharan AfricaNumber of outreaches made by studio staff to these leads that resulted in the lead actually purchasing a trial with the fitness studio and making their first booking.Sub-Saharan Africa
• Sub-Saharan AfricaConversion of trialers to purchasers of a membership with the studio.Sub-Saharan Africa
• Sub-Saharan AfricaMember retention rates and average lifetime spend.Sub-Saharan Africa
• Sub-Saharan AfricaRe-enrollment rates of former members.Sub-Saharan Africa
• Sub-Saharan AfricaEnsure data consistency and accuracy across multiple studio locations, each with potentially different naming conventions and membership definitions.Sub-Saharan Africa
• Sub-Saharan AfricaCollaborate directly with fitness studios to clarify reporting requirements and ensure alignment with their internal reports generated by their booking platform’s front end.Sub-Saharan Africa
• Sub-Saharan AfricaAdjust reports based on feedback from fitness studios to ensure data accuracy and relevance.Sub-Saharan Africa
• Sub-Saharan AfricaReview and utilize our documentation to understand our database structure and the necessary calculations.Sub-Saharan Africa
• Sub-Saharan AfricaResearch and integrate new endpoints from third-party APIs as needed.Sub-Saharan Africa
• Sub-Saharan AfricaInteract with third-party API support for troubleshooting and additional information.Sub-Saharan Africa
  
  

Sub-Saharan AfricaClient Interaction:Sub-Saharan Africa

• Sub-Saharan AfricaConduct an initial one-hour call with each client to understand their reporting needs.Sub-Saharan Africa
• Sub-Saharan AfricaFollow up with another call to present initial results, review discrepancies, and make necessary adjustments to ensure data accuracy.Sub-Saharan Africa
• Sub-Saharan AfricaThis will differ from client to client based on the data they require, the manner in which their instance was originally configuredSub-Saharan Africa
  
  

Sub-Saharan AfricaSupport Provided:Sub-Saharan Africa

• Sub-Saharan AfricaAccess to detailed database documentation, including table structures and linkages.Sub-Saharan Africa
• Sub-Saharan AfricaDocumentation explaining the intricacies of required data calculations.Sub-Saharan Africa
• Sub-Saharan AfricaOngoing support from our team to ensure the reports you generate are accurate.Sub-Saharan Africa
• Sub-Saharan AfricaInteraction with third-party API support teams as needed.Sub-Saharan Africa
  
  

Sub-Saharan AfricaRequirements:Sub-Saharan Africa

• Sub-Saharan AfricaProven experience in writing complex SQL queries and generating reports.Sub-Saharan Africa
• Sub-Saharan AfricaFamiliarity with PostgreSQL and querying APIs.Sub-Saharan Africa
• Sub-Saharan AfricaExcellent communication skills for client interactions and requirement gathering.Sub-Saharan Africa
• Sub-Saharan AfricaAbility to work with complex data structures and ensure data accuracy.Sub-Saharan Africa
• Sub-Saharan AfricaStrong problem-solving skills to address discrepancies and data inconsistencies.Sub-Saharan Africa
• Sub-Saharan AfricaExperience with fitness studio operations and sales processes is a plus.Sub-Saharan Africa
  
  

Sub-Saharan AfricaJob Duration:Sub-Saharan Africa

• Sub-Saharan AfricaThis is an ongoing position. Initially, you will have more work as you learn the database structure and specific definitions of the data. Over time, client interactions will become more sporadic, but you will receive all necessary support from us to ensure the accuracy of the reports.Sub-Saharan Africa

Sub-Saharan Africa