SQL Data Reconciliation Specialist

Title: SQL Data Reconciliation SpecialistSalary: 7 000 – 9 000 PLN net / month (B2B) Location: Remote / Poland (any city) Company: Lion Sales Funnels LLC Tech Stack PostgresSQL Grafana GoHighLevel (CRM) OpenDental (EMR) API data integrations Role Summary Lion Sales Funnels is a Canadian-led remote company building operational reporting systems for healthcare clinics in the United States. We integrate multiple systems including: • EMR software (OpenDental) • CRM platforms (GoHighLevel) • Postgres data warehouse • Grafana dashboards We are hiring a Data Reconciliation & SQL Operations Specialist responsible for verifying that operational data matches across these systems. Your work ensures that patient procedures, appointments, and revenue figures shown in dashboards match the source systems. This is a technical operations and data verification role, not a marketing position. What You Will Do • Write SQL queries to validate operational datasets • Reconcile data between EMR, CRM, and reporting dashboards • Investigate discrepancies in patient procedures, appointments, and revenue • Verify data used in Grafana dashboards • Identify missing or inconsistent records between systems • Document findings and maintain reconciliation logs • Work with internal developers and QA to correct data issues This role is essentially data investigation and operational verification. Requirements • Strong SQL skills (JOIN, GROUP BY, filtering, aggregation) • Experience working with relational databases (Postgres preferred) • Experience verifying or auditing data across systems • Ability to identify discrepancies in reports or datasets • Strong written English (C1) • High attention to detail and structured thinking Note: Candidates without hands-on SQL experience will not be considered. Preferred Experience • Experience with analytics dashboards (Grafana, Looker, PowerBI) • Experience working with CRM systems • Experience validating operational or financial datasets • Exposure to healthcare, clinic, or appointment-based systems Team Structure • Leadership: Canada • Technical team: Southeast Asia • Clients: United States (healthcare clinics) The role is internal and technical. No client meetings. Hiring Process • 30-minute technical interview (English) • SQL and data validation discussion • Short paid task • 2-week trial period Example Interview Question During the interview we may ask questions such as: "You have a patients table and an appointments table. How would you write a SQL query to show all patients and their upcoming appointments?" Who Will Do Well in This Role This role is ideal for someone who enjoys: • investigating data problems • finding discrepancies between systems • validating reports and numbers• working with SQL to verify datasets If you enjoy tracking down why numbers do not match, you will likely enjoy this role! About Lion Sales Funnels Lion Sales Funnels builds operational data systems for healthcare clients in the United States. Our work focuses on integrating CRM platforms, operational databases, and analytics dashboards so that business decisions are based on accurate data. Apply with your CV and a short note describing your experience working with SQL or operational data verification. Important: This role requires writing SQL queries to validate operational datasets. Candidates without hands-on SQL experience should not apply.If you apply, please include a short answer to this question in your application. You have two tables: patients patient_id name appointments appointment_id patient_id appointment_date Write a SQL query that shows all patients and their upcoming appointments. Applications without the SQL question answer will not be reviewed! Only read-only queries are required. The goal is simply to understand how you think about joining tables. Good luck!