Note: The job is a remote job and is open to candidates in USA. Mammoth Growth is a modern data analytics consultancy that helps clients grow through data-driven decision making. The Senior Analytics Engineer focuses on building complex data infrastructure and providing technical guidance, while designing scalable data pipelines and implementing governance frameworks.
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
Skills
- 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
- 5-7+ years of analytics engineering or data engineering experience
- Strong problem-solving abilities with complex technical challenges
- Excellent communication skills for technical and business stakeholders
- Experience mentoring junior team members
- Self-motivated with ability to work independently and collaboratively
Benefits
- We provide rapid career advancement
- Exposure to a huge range of business challenges
- Amazing clients
- Competitive compensation
- 100% Remote
- Our team is fully distributed (before Covid and forever), allowing you the flexibility of working from home.
Company Overview