Senior Analytics Engineer / Jr. Tech Lead
M
Mammoth GrowthE-commerce, SaaS, media, D2C, B2B
U.S., U.K., CanadaFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5-7+ years
- Required Skills
- AWSSQLGCPSnowflakeJiradbt
Requirements
- 5-7+ years of analytics engineering or data engineering experience
- Advanced dbt proficiency with complex modeling, macros, and performance optimization
- Deep Snowflake expertise including architecture, optimization, and advanced features
- Hands-on experience with Fivetran and modern data stack ecosystem
- Proficient in Git/GitHub workflows, branching strategies, and collaborative development
- Advanced SQL skills with query optimization and performance troubleshooting
- Understanding of dimensional modeling and analytics engineering methodologies
- Experience with cloud environments and scalable solutions in AWS and/or GCP
- Familiarity with project management tools like Jira
- Demonstrated experience with Claude, ChatGPT, and other LLM platforms
- Familiarity with agentic tools such as CoPilot, RooCode, and others
- Prompt engineering skills for code generation, documentation, and problem-solving
- Strong interest or direct experience in agentic workflows and Model Context Protocols (MCP)
- Ability to integrate AI tools into technical workflows
- Strong problem-solving abilities with complex technical challenges
- Excellent communication skills for technical and business stakeholders
- Experience mentoring junior team members
Responsibilities
- Build complex data models using dbt with optimal performance and maintainability
- Design and optimize Snowflake data pipelines leveraging advanced features for scalability
- Configure database environments, manage permissions, access control, and implement data governance frameworks
- Implement ELT processes using modern data stack tools such as Fivetran
- Write high-quality code following Git workflows, code reviews, and CI/CD practices
- Conduct data quality audits and implement automated testing frameworks
- Leverage AI tools (Claude, ChatGPT) to enhance development productivity and solution quality
- Apply prompt engineering and implement agentic workflows using MCPs
- Mentor Analytics Engineers I and II, providing technical guidance and code reviews
- Collaborate with Technical Leads and Sr. Consultants on complex project decomposition and execution
- Present technical solutions and audit findings to clients
- Independently manage project components while coordinating with cross-functional teams
- Support project planning with technical expertise and risk assessment
View Full Description & ApplyYou'll be redirected to the employer's site
