Data Analyst — MCT PathAI

About the Role

MCT PathAI operates an AI-powered job matching platform processing over 5,000 job listings daily from sources like Greenhouse, Lever, and Ashby, evaluating resumes across ten criteria and filtering by visa sponsorship. The platform utilizes a GitHub Actions pipeline running on Supabase, resulting in a rapidly growing data set and product.

Key Responsibilities

• Manage and develop analytical dashboards monitoring scraper functionality, matching accuracy, user engagement, and retention metrics.
• Conduct comprehensive analyses on job and resume matching effectiveness, proposing improvements to models and product offerings.
• Oversee daily data pipeline execution at 7AM PDT, identifying anomalies and implementing data-quality validations.
• Collaborate with engineering teams to determine necessary events, metrics, and data schemas for instrumentation.
• Transform unstructured scraped data into well-organized, queryable databases.
• Develop self-service reporting tools to reduce ad hoc data requests from team members.
• Support go-to-market efforts through cohort evaluation, conversion tracking, and insights into beta users.

Required Skills and Experience

• 2 to 4 years experience in data analysis or analytics engineering roles.
• Proficient in SQL with advanced knowledge of CTEs, window functions, and query optimization on Postgres databases.
• Experienced in Python scripting for data analytics, especially with Pandas and Jupyter.
• Proven track record building dashboards utilized by stakeholders, using tools like Metabase, Looker, Superset, or Streamlit.
• Ability to work effectively with messy and semi-structured data formats such as JSON or scraped HTML.
• Strong product intuition enabling conversion of ambiguous business questions into clear metrics.
• Excellent written communication skills to convey insights to non-technical leadership.

Preferred Skills

• Familiarity with Supabase or Postgres as a primary data warehousing solution.
• Experience with data transformation frameworks like dbt.
• Understanding of recruiting platforms and ATS data, including Greenhouse, Lever, and Ashby.
• Knowledge of statistics and A/B testing methodologies.
• Experience using Python notebooks for exploratory machine learning tasks such as clustering and classification.
• Client-facing experience with cross-team collaboration and managing stakeholder relations.

Additional Details

The role is based in Bothell, Washington with hybrid work options available or can be fully remote within the United States. This position is full-time. Applicants should submit a resume, portfolio or example dashboard, and a brief explanation of the initial metric they would develop when analyzing daily job posting and user application tables. Applications are reviewed on a rolling basis with personalized feedback provided.