As a Data Analyst at 9amHealth, you'll be responsible for designing and maintaining dashboards using Tableau and Looker, analyzing data through advanced SQL techniques, and collaborating with the Data & Backend Engineer to refine data structures. Your goal is to transform complex data into actionable insights that drive decision-making for internal teams and clients.

To qualify for the Data Analyst position at 9amHealth, you should have a minimum of five years' experience in data analysis, particularly within health tech. Essential skills include advanced SQL proficiency, experience with AWS infrastructure, and mastery of dashboarding tools like Tableau and Looker. A collaborative mindset and strong analytical abilities are crucial.

At 9amHealth, data analytics plays a pivotal role in enhancing cardiometabolic care by informing product development and optimizing user experiences. Our Data Analyst leverages tools like Mixpanel to track user behavior, ensuring that our decisions are rooted in solid data and ultimately resulting in better health outcomes for our members.

As a Data Analyst at 9amHealth, you should be familiar with Tableau and Looker for dashboard creation, advanced SQL for data manipulation, and Mixpanel for product analytics. Experience with AWS infrastructure and a grasp of event-based analytics concepts are also highly beneficial in this role.

9amHealth offers a dynamic and collaborative work environment typical of a startup, yet grounded by the expertise of seasoned founders. You'll have the opportunity to work remotely or in-office, with a strong focus on continuous learning, improvement, and celebrating diversity among our team members.

Addressing missing or corrupt data starts with identifying the issue's extent. I prioritize data integrity by applying techniques such as imputation, where appropriate, or excluding certain data points if they significantly affect results. Clear communication with stakeholders on the implications of this data is vital for informed decision-making.

I have extensive experience creating interactive dashboards in Tableau. I focus on designing visuals that tell a story, ensuring that data insights are easily understandable and actionable for stakeholders. I also regularly gather feedback to refine these dashboards, tailoring them to user needs.

Finding trends begins with thorough data exploration using techniques such as exploratory data analysis (EDA). I would use statistical methods and visualizations to uncover patterns and outliers, and then apply SQL to query the dataset for deeper insights, ensuring trends are statistically significant before drawing conclusions.

I have advanced SQL skills, allowing me to perform complex queries, join multiple tables, and manipulate datasets to extract meaningful information. I often use SQL to build reports and conduct analyses that support business decisions across various teams. Continuous learning through new SQL functionalities is a priority for me.

I prioritize tasks based on the impact and urgency of each project. I utilize project management tools to track progress and communicate with stakeholders, ensuring that I focus on high-priority analyses while remaining flexible to accommodate urgent requests. Clear prioritization helps in balancing workloads effectively.

I firmly believe in clear and concise communication with stakeholders. I tailor my approach based on audience understanding, whether through visual dashboards, presentations, or informal discussions. I always aim to provide context around the data, encouraging questions to foster deeper engagement and understanding.

Accuracy in data analysis is achieved through meticulous data validation processes. I cross-reference findings with original datasets and use systematic checks for consistency. Furthermore, I document my methodologies to provide transparency, so stakeholders can trust the insights presented.

Creating a user behavior tracking plan starts with defining key metrics aligned with business objectives. I would identify events to track, outline user journeys, and set up Mixpanel to gather granular data. Regularly reviewing and optimizing this tracking plan ensures it evolves with product changes.

I have hands-on experience with various AWS services, particularly AWS Glue for data transformation and management. Familiarity with the broader AWS ecosystem enables me to efficiently work with large datasets, setting up pipelines that facilitate seamless data integration into our analytics platforms.

I stay current in data analysis through continuous education—participating in online courses, attending industry webinars, and actively engaging with data communities. This commitment allows me to integrate the latest techniques and tools into my work, providing the best insights and value to my team.