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.