Location: Remote (Philippines, but not required)
Engagement Type:Full-Time Contract-Based Role
Salary Range:40,000 60,000/month ($690 - $1,035) (commensurate with Experience)
The Data Analyst is a crucial and hands-on role responsible for transforming raw data into actionable insights that drive business decisions. You will be instrumental in analyzing various data sources, including marketing, sales, customer behavior, and specifically, patient engagement data from our product for healthcare practices, to identify trends, measure performance, and optimize strategies. This role will heavily leverage our suite of data analysis and reporting tools, including SQL, Google BigQuery, Looker Studio, and HubSpot Reporting, and will also utilize AI tools like Gemini and ChatGPT to enhance efficiency and insights, all managed within ClickUp.
Key Responsibilities:
- Design, develop, and maintainSQLqueries to extract, transform, and load (ETL) data from various sources, ensuring data accuracy and integrity.
- UtilizeGoogle BigQueryto perform complex data analysis on large datasets, identifying key trends, patterns, and anomalies.
- Develop and maintain interactive dashboards and reports inLooker Studioto visualize key performance indicators (KPIs) and present actionable insights to stakeholders.
- Develop comprehensive reports and dashboards specifically for healthcare practices, analyzing their patient engagement (product) data to provide actionable insights into patient interactions, outcomes, and opportunities for improvement.
- Extract and analyze marketing and sales performance data usingHubSpot Reporting, identifying opportunities for optimization and improvement in campaigns and customer journeys.
- Collaborate with cross-functional teams (e.g., marketing, sales, product, and potentially client success/account management for healthcare clients) to understand their data needs and provide data-driven recommendations.
- Perform ad-hoc data analysis to support specific business initiatives and answer critical questions.
- Monitor and analyze data quality, identifying and resolving discrepancies to ensure reliable reporting.
- Stay up-to-date with the latest data analysis trends, tools, and best practices, including advancements in AI for data.
- Leverage AI tools (Gemini, ChatGPT) for tasks such as:
- Automating data cleaning and pre-processing scripts.
- Generating complex SQL queries or formulas based on natural language prompts.
- Summarizing large datasets or reports to extract key insights.
- Drafting concise and impactful narratives for data presentations.
- Manage and track data analysis tasks, projects, and deadlines usingClickUp, ensuring efficient workflow and clear communication.
Required Skills & Qualifications:
- Experience:2+ years of proven experience in a data analyst role with a strong focus on data extraction, analysis, and reporting.
- Data Analysis & Interpretation:Strong ability to interpret complex datasets, identify meaningful trends, and translate data into clear, actionable insights.
- Analytical & Problem-Solving Mindset:Ability to approach problems systematically, identify root causes, and propose data-driven solutions.
- Attention to Detail:Meticulous attention to detail in data validation, analysis, and reporting.
- Communication:Excellent verbal and written communication skills with the ability to present complex data insights clearly and concisely to both technical and non-technical audiences, including potential client-facing interactions.
- Collaboration:Proven ability to work effectively with cross-functional teams and take direction.
- Domain Knowledge (Bonus):Familiarity with healthcare data or patient engagement metrics is a strong plus.
Tool Proficiency:
- SQL:Advanced proficiency in writing complex SQL queries for data extraction, manipulation, and analysis.
- Google BigQuery:Hands-on experience with querying and analyzing large datasets within Google BigQuery.
- Looker Studio (formerly Google Data Studio):Proven experience in developing, maintaining, and customizing interactive dashboards and reports.
- HubSpot Reporting:Strong experience in extracting, analyzing, and reporting on marketing and sales data within the HubSpot platform.
- Google Sheets/Excel:Proficient in data organization, analysis, and reporting using spreadsheets.
- AI Tools (Gemini/ChatGPT):Practical experience leveraging AI for data analysis tasks, code generation, summarization, and insight extraction.
- ClickUp:Experience with project management tools for organizing tasks and collaborating with a team.
While not strictly required, candidates possessing the following experience will be highly regarded:
- Familiarity with Pythonfor data manipulation, analysis and reporting
- Experience with version control systems (e.g., Git).
- Exposure to cloud environments (GCP, AWS, Azure)
