What are the responsibilities and job description for the Database Administrator position at Honeyguide?
As our Database Administrator, you'll be supporting our data operations, managing our modern data stack centered around Airtable and Softr. Your mission will be to ensure the seamless flow of customer data while maintaining the highest standards of data integrity and accessibility.
Data Intake & Management
• Spearhead client data onboarding processes, managing the seamless integration of data files into our Airtable environment
• Develop and maintain comprehensive documentation for data procedures
• Provide expert guidance to the data team while continuously improving operational processes
• Orchestrate weekly and monthly data synchronization schedules
Data Validation & Quality Assurance
• Ensure data integrity through meticulous review of upload queues and relationship mappings
• Collaborate with clients to resolve data discrepancies and maintain clean datasets
• Oversee the data warehouse architecture, including field dependencies and labeling conventions
• Manage QuickBooks Online data integration, including W-9 compliance workflow
Analytics & Reporting
• Drive data-driven insights through custom Airtable views and advanced reporting
• Design and implement complex data fields using lookups, rollups, and conditional logic
• Perform thorough data reconciliation and validation before stakeholder delivery
• Create and maintain client-facing data portals using Softr
Operational Excellence
• Maintain pristine internal financial records through weekly check register reviews
• Execute invoice creation and management in QuickBooks Online
• Oversee bill processing through Melio
• Ensure robust data backup and monthly reporting procedures
Salary : $40,000 - $50,000