<aside>

Koho | Analytics Team | 2026 Authors: Célia Bru - Amanda Chang - Elliott Sterner - Shezan Zakriya

</aside>

Category Sub-Category Data Analyst I Data Analyst II Senior Data Analyst Principal Data Analyst
Technical Skills SQL Follows team SQL guidelines and focuses on learning best practices. Understands relevant data and asks questions to confirm assumptions. Delivers SQL work with good readability but may occasionally require corrections. Consistently writes high-quality SQL with readability and efficiency in mind. Accounts for edge cases and errors, ensuring accuracy in outputs. Deep understanding of tables and sources enables writing optimized queries. Identifies recurring SQL patterns and automates them in dbt (e.g., dashboard queries, cohort macros). Focuses on improving query runtime performance through better structuring and indexing. Same as Senior Data Analyst
Technical Skills Dashboarding Creates clear and efficient visualizations: charts are readable, properly labeled, and use the correct chart type for the data. May need support in structuring dashboards and selecting the right metrics. Follows the team's Dashboard Style Guide to ensure consistency. Produces polished dashboards with a well-organized flow of information. Ensures dashboards tell a clear story, making insights easy to interpret. Effectively selects and arranges key metrics to provide meaningful context. Drives insights through dashboarding. Dashboards do more than visualize data; they answer critical business questions. Thinks beyond the immediate request, identifying additional relevant insights that stakeholders may not have considered. Structures dashboards to support data-driven decision-making. Proactively delivers cross-functional insights, anticipating business needs before requests are made. Collaborates with stakeholders to evolve dashboards into forward-looking strategic tools.
Technical Skills dbt Co-owns data models in dbt and collaborates with other team members when working on new models to design them effectively. Owns data models in dbt and writes them with performance in mind. Implements performance recommendations from team members and is capable of using more advanced dbt features with guidance, such as macros in a pipeline. Owns and designs dbt models with a strong focus on performance. Works across domain boundaries when needed. Independently implements advanced dbt features and adopts new practices quickly. Leads dbt architecture and optimization across the team. Uses advanced features to improve efficiency and maintainability. Proactively reviews and influences models outside their domain. Sets team standards for dbt usage.
Technical Skills Git Follows Git best practices, including branching and commit conventions. Occasionally needs support with branch management and resolving merge conflicts. Can review most PRs but may need guidance on complex changes. Manages branches independently and resolves merge conflicts with minimal support. Writes clear commit messages and follows structured Git workflows. Provides constructive feedback in PR reviews and ensures a prompt turnaround time to keep development moving efficiently. Demonstrates deep understanding of version control. Efficiently analyzes code history to track changes and debug issues. Reviews PRs for both quality and performance, ensuring best practices are followed. Acts as a Git expert within the team. Handles complex PR reviews, including architectural changes. Influences and guides team members on advanced Git workflows.
Technical Skills AI Uses AI tools in daily work and is able to QA AI-generated output for correctness. Uses AI tools with a focus on experimentation. Tries new tools and workflows proactively. QAs all AI-generated output and takes full ownership of the result. Integrates AI across all facets of work: technical, analytical, and cross-functional. Regularly shares learnings and effective prompts/workflows with the team. Leads AI adoption for the team. Identifies high-leverage opportunities to integrate AI into team workflows and standards. Evaluates new tools and establishes guidance on when and how to use them effectively.
Getting Things Done Scope Primary analyst for a domain with support of a lead. Flags data quality issues and tech debt for prioritization. Primary analyst for a domain with support of a lead. Proactively identifies data quality issues and tech debt, suggesting them for prioritization. Primary analyst for one or two domains, support of lead only on cross-functional large projects. Owns data quality and tech debt within their domain, maintaining a backlog and advocating for prioritization. Data lead for domain(s). Owns multiple domains and drives strategic alignment across them, ensuring cross-functional dependencies are proactively managed and data strategies are optimized for maximum impact. Owns data quality and tech debt prioritization across their domains.
Getting Things Done Prioritization Primarily works on reactive tasks assigned by the manager and may need support in prioritization. Handles both reactive tasks and proactively prioritizes work in collaboration with the manager, suggesting areas to focus on. Proactively collaborates with the manager on prioritization, taking initiative in proposing work that should be prioritized based on business needs. Fully autonomous in prioritizing work and identifying future projects, ensuring that cross-functional priorities align with broader business strategies and objectives.
Getting Things Done Business Understanding Understands core business drivers and how their work contributes to company goals. Familiar with the short-term roadmap for their domain and works closely with a manager to understand the strategic context. Has a deeper understanding of their domain's long-term roadmap and strategy. Independently navigates business context and applies insights to their work. Builds working knowledge of core team pipelines. Integrates business drivers, external factors, and long-term domain strategy into their work. Proactively identifies cross-functional dependencies and offers feedback on the impact of projects. Solid understanding of core pipelines and how they connect across domains. Possesses a broad understanding of the business and how data influences strategic decisions across departments. Provides feedback on cross-departmental impact and aligns projects with company-wide goals. Deep understanding of all core pipelines and their interdependencies.
Getting Things Done Accountability Is accountable for delivering work within agreed-upon timelines. Responsible for upward management: escalating for support, communicating blockers, and providing visibility to managers and teammates. Receives ongoing support during projects. Accountable for delivering work on time and ensuring accuracy of results. Primarily receives support at the start of a project but works more autonomously once scoped. Consistently delivers work on time with accuracy. Proactively addresses challenges before they become blockers. Maintains a high pace of shipping (PRs, analyses, dashboards). Maintains a high level of accountability for their own work while mentoring others to take ownership of their projects. Leads by example in setting quality standards and maintaining velocity. Helps others navigate challenges and improve their execution.
Getting Things Done Problem Solving Determines actions within defined processes and documentation. Contributes to resolving issues using learned techniques. Performs basic debugging of queries, dashboards, and dbt models with guidance. Devises solutions based on limited information and adapts existing approaches to resolve issues. Independently debugs data discrepancies, SQL queries, and model errors. Devises solutions while considering future use cases and challenges. Exercises judgment in selecting methods, evaluating, and adapting complex techniques. Leads debugging efforts, identifying root causes of data inconsistencies, and reporting errors. Designs and trains the team on best practices around methods, techniques, and problem-solving. Ensures that issues are documented, conducts retrospectives, and establishes new guidelines to prevent recurring problems.
Cross-Functional Collaboration Stakeholder Management Able to clarify and answer basic stakeholder questions about their domain. Escalates as needed to meet stakeholder demands. Implements the "no ticket, no work" and "no DM" data team norms. Able to clarify and answer most stakeholder questions about their domain. Able to clarify and answer questions about their domain and direct stakeholders to the right resources on most topics. Able to confidently evaluate stakeholder requirements, pushing back when necessary with clear reasoning and alternatives. Fully owns prioritization and stakeholder management for their domain. Proactively shapes stakeholder requirements; able to challenge assumptions and guide discussions toward high-impact, data-driven solutions.
Cross-Functional Collaboration Communication Clearly communicates analyses and technical concepts, both asynchronously and in presentations. Ensures new dashboards and analyses are always shared in the relevant Slack channel, highlighting key insights. Actively participates in meetings, clearly communicating findings and updates to stakeholders. Adapts communication to the audience to effectively drive key messages. Clearly articulates recommendations to stakeholders and draws a direct connection between technical work and strategic business outcomes. Crafts a coherent narrative about the business and the impact of their work on strategic outcomes. Establishes best practices for data communication across the team.
Cross-Functional Collaboration Influence Engages in team discussions to improve workflows and data usage but relies on senior guidance. Effectively influences the data team by contributing to technical decisions, improving processes, and driving adoption of best practices. Expands influence beyond the data team, impacting key stakeholders within their area of ownership. Drives data-informed decision-making within their domain. Influences multiple teams and ownership areas, shaping strategic decision-making across the company. Autonomously drives discussions on broader company data strategy and priorities.
Team People Supports team members by providing guidance and assistance. Contributes to hiring, onboarding, and team initiatives. Mentors team members to improve their skills and provides support when a manager identifies a need. Helps foster a strong, collaborative team culture.
Team Processes Follows team processes, best practices, and guidelines. Enforces team processes, making sure everybody understands the benefits and tradeoffs. Critically evaluates team processes and identifies opportunities for improvement. Proactively suggests and tests refinements. Leads process improvements and drives ideation for new best practices. Establishes technical standards and stays informed on emerging technologies.