Senior Data Analytics Engineer
haystackapp
Job Description
- Design, build, and maintain analytical pipelines and reporting solutions on BigQuery and MariaDB
- Write sophisticated, performant SQL to extract insights from large-scale datasets
- Leverage AI and machine learning features to augment analytics workflows and deliver smarter outputs
- Use AI-powered development tools (Windsurf, Gemini, Claude, Cursor) to accelerate your workflow and deliver at a higher level
- Develop internal tooling and automation using Python, FastAPI, and modern frameworks
- Communicate findings clearly to technical and non-technical stakeholders-translate data into action
- Understand and document data architecture, lineage, and how information flows across systems
- Collaborate on business process analysis and process design improvements driven by data
- Proactively identify opportunities for deeper analysis, better tooling, and operational improvements
Requirements & Qualifications
- 7+ years of professional experience in data analytics engineering, data engineering, or a related field
- Expert-level SQL - you think in joins, window functions, and CTEs; BigQuery and MariaDB experience strongly preferred
- Strong Python and/or JavaScript skills - comfortable building pipelines, internal tools, APIs, and automation; not just scripts
- js experience - ability to build data-facing web applications and internal dashboards
- Deep understanding of data architecture - how databases are structured, how data flows, how schemas evolve
- Hands-on experience with AI/ML - you stay current with the latest capabilities (LLMs, generative AI, embeddings) and know how to apply them practically
- Proficiency with AI-powered development tools - Windsurf, Gemini, Claude, Cursor, or similar; you use AI to multiply your output, not as a crutch
- Excellent communication skills - you can explain complex analysis to anyone in the room
- Self-sufficient and self-managing - you own your work end-to-end without needing to be told what to do next
- Ambitious and continuously improving - you seek out new skills, tools, and techniques on your own
- A public GitHub profile with examples of your work (personal projects, contributions, experiments)
Nice to Have
- FastAPI experience for building internal APIs and services
- Background in business process design or operational analytics
- Exposure to multiple business departments (Finance, Marketing, Sales, Operations, Engineering) - you understand how data flows across an organization, not just within one silo
- Understanding of Docker and Kubernetes - containerization and cluster orchestration experience is a big plus