Overview
Analytics Engineer — Job Posting
Job Title
Analytics Engineer
Reports To
Co-Founder / CEO
Employment Type
Full-Time
Work Model
Remote (US-Based) · Optional Hybrid (New York, NY)
Compensation
$120,000 – $175,000 USD / year + equity
About LockedIn AI
LockedIn AI is the #1 real-time AI interview and meeting copilot, trusted by over 1 million users worldwide. We are building a fast-growing AI-powered career platform that helps users succeed in live interviews, coding assessments, and professional communication.
Our mission is to turn raw data into actionable intelligence that powers better product decisions and better AI experiences at scale.
Role Overview
We are looking for a meticulous, systems-minded Analytics Engineer to build and maintain the data models, transformation pipelines, and analytics infrastructure that power decision-making across the company.
This is a foundational data role where you will transform raw product events, AI system logs, and business data into clean, reliable, and well-documented datasets used by product, engineering, AI, and leadership teams.
You will own the transformation layer of the data stack and help define how data is structured, validated, and consumed across the organization.
Key Responsibilities
1. Data Modeling & Transformation
Design and maintain dimensional data models for product, AI, and business data
Build and manage a dbt-based transformation layer with modular, version-controlled models
Standardize core business metrics (e.g., active users, session success, AI performance)
Develop a semantic layer to ensure consistent definitions across the company
2. Data Quality & Governance
Implement automated testing for schema, freshness, and data integrity
Build data contracts between upstream and downstream systems
Monitor pipeline health and create alerts for data quality issues
Maintain a centralized data catalog and documentation system
3. Analytics Infrastructure
Own and optimize the analytics stack (warehouse, dbt, orchestration tools, BI systems)
Build reliable ELT/ETL pipelines from product and third-party systems
Implement CI/CD for analytics code to ensure safe deployments
Optimize warehouse performance, query efficiency, and cost management
4. Business Intelligence & Self-Service Analytics
Partner with product, engineering, marketing, and leadership teams
Translate business questions into structured, reusable data models
Build dashboards and reporting datasets for key product and business metrics
Enable self-service analytics through well-documented data marts
5. AI & Product Analytics
Build models for AI system metrics (latency, cost, hallucination rate, quality)
Structure user behavior data for retention, funnels, and engagement analysis
Support A/B testing and experimentation frameworks
Collaborate with data scientists on model evaluation datasets
6. Cross-Functional Collaboration
Work closely with engineers to ensure clean and reliable data ingestion
Align with stakeholders on metric definitions and business logic
Maintain clear documentation of all models and transformations
Continuously improve analytics engineering best practices
Required Qualifications
Experience
3+ years in analytics engineering, data engineering, or related roles
Experience building production dbt pipelines or equivalent
Strong background in product analytics and metric design
Experience working cross-functionally in fast-paced teams
Startup or high-growth environment experience preferred
Technical Skills
Expert-level SQL (joins, window functions, optimization)
Strong experience with dbt (models, tests, macros, documentation)
Proficiency in Python for data workflows
Familiarity with orchestration tools (Airflow, Prefect, Dagster, etc.)
Experience with Git and analytics engineering best practices
Understanding of dimensional modeling (Kimball or similar)
Preferred Qualifications
Experience modeling AI/LLM system performance data
Familiarity with event-driven or streaming data architectures
Experience with large-scale consumer data (100K+ users)
Knowledge of data privacy frameworks (GDPR, CCPA)
Experience with reverse ETL tools (Hightouch, Census, etc.)
Contributions to dbt community or analytics open-source tools
Background in SaaS, edtech, or career tech products
What We Offer
Equity Ownership — meaningful early-stage ownership
High Impact — your work powers decisions for 1M+ users
Fast Execution — move quickly and ship improvements continuously
Remote Flexibility — work from anywhere (US-based optional NYC hybrid)
Strong Ownership Culture — full responsibility over analytics foundation
Category-Leading Product — build data systems for a top AI copilot
Why Join LockedIn AI?
You will define the data foundation for a 1M+ user AI platform
You will directly influence product and AI improvements through analytics
You will build systems that power decision-making across the entire company
You will work in a fast-moving AI-native environment
You will ship impactful data infrastructure faster than traditional enterprise roles
How to Apply
Please submit:
Resume / CV
Short note including:Why you want to join LockedIn AI
Whether you’ve used the product
Suggestions for improvement
Optional: SQL projects, dashboards, or portfolio work
Equal Opportunity
We are committed to building a diverse and inclusive team. Hiring decisions are based on merit, skills, and business needs.
