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 FunctionsAnalyze 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.
Job Posted by ApplicantPro