Europe, Middle East and AfricaJob DescriptionEurope, Middle East and Africa

Europe, Middle East and 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.Europe, Middle East and Africa

Europe, Middle East and AfricaKey Responsibilities:Europe, Middle East and Africa

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

Europe, Middle East and AfricaClient Interaction:Europe, Middle East and Africa

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

Europe, Middle East and AfricaSupport Provided:Europe, Middle East and Africa

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

Europe, Middle East and AfricaRequirements:Europe, Middle East and Africa

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

Europe, Middle East and AfricaJob Duration:Europe, Middle East and Africa

• Europe, Middle East and 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.Europe, Middle East and Africa

Europe, Middle East and Africa