Database Coordinator

Job Description

Job Description

Position Summary:

As the Database Coordinator, you will steward business systems and data architecture, ensuring their reliable operation, accurate reporting, and continuous improvement. Collaborating with diverse technical and non-technical teams, you will translate complex data into actionable insights that empower informed decision-making and seamless program execution. Ultimately, your proactive problem-solving and analytical expertise will optimize processes, elevate client experience, and drive continued growth.

Essential Functions

• Analyze and organize customer data processes, managing multiple client requests with minimal supervision while ensuring accuracy and adherence to technical protocols.
• Monitor data file exchanges for errors, ensuring proper technical requirements, file transmission protocols, and resolving discrepancies.
• Develop, maintain, and distribute comprehensive reports and dynamic dashboards to track key business metrics, revenue, and KPIs utilizing Google Sheets, Post Affiliate Pro, HubSpot, SamCart, Shopify, BigQuery, and SQL.
• Leverage advanced generative AI tools, such as Claude, to optimize data analysis, streamline the report generation process, and summarize complex data narratives effectively.
• Leverage BigQuery and SQL to query, organize, validate, and analyze cross-system data. Identify trends, data integrity issues, and uncover opportunities for workflow optimization.
• Monitor data file exchanges for accuracy and technical compliance, setting up automated alerts to proactively address errors, discrepancies, or potential issues before they impact clients.
• Champion and document process improvement initiatives designed to minimize data errors, enhance reporting accuracy, and increase operational efficiency.
• Train end-users on system access, security protocols, and the effective customization and use of internal reporting tools.
• Support the technical onboarding process by preparing, configuring, and distributing laptops, equipment, and technology accessories for new employees.
• Provide basic IT support, including equipment setup, replacements, troubleshooting, and laptop wiping, resetting, and reconfiguration as needed.

What You Bring (Qualifications & Skills)

• Education: High school diploma or equivalent required; a degree in Data Management, Information Technology, Business Analytics, or a related field is highly preferred.
• Core Experience: 2+ years of hands-on experience operating within the following systems (or their equivalents): Google Sheets, Post Affiliate Pro, HubSpot, SamCart, Shopify, BigQuery, and SQL.
• Technical & AI Proficiency: Demonstrated experience utilizing BigQuery and SQL to manipulate and query data for business intelligence, alongside a comfort level with utilizing AI (e.g., Claude, ChatGPT) to aid in reporting and logic-building.
• Holistic Thinking: A natural curiosity for how different departments operate and the ability to map those operational realities into logical, user-friendly data reporting structures.
• Attention to Detail: Exceptional organizational skills with a keen eye for identifying data discrepancies and ensuring absolute accuracy across multiple, simultaneous projects.
• Communication: Strong interpersonal skills with the ability to interpret data and communicate findings clearly and positively to both technical and non-technical stakeholders.

Bonus Points (Highly Beneficial Skills for this Role):

• Data Visualization: Familiarity with advanced BI and visualization tools (e.g., Tableau, Lightdash, Power BI) to bring data to life.
• Automation: Understanding of API integrations or workflow automation tools (e.g., Zapier, Make) to streamline data passing between systems.
• Data Privacy: A foundational understanding of data privacy best practices and compliance standards (e.g., CCPA, GDPR) to ensure customer data remains secure.
• E-commerce/Wellness Acumen: Prior experience working with subscription models, affiliate marketing data, or within the health and wellness industry.