Mammoth Growth · 5 months ago
Senior Analytics Engineer
United States
Full-time
Remote
Senior Level
5+ years expMammoth Growth is a modern data analytics consultancy that helps clients grow through data-driven decision making. They are seeking a Senior Analytics Engineer who will focus on building complex data infrastructure, designing scalable data pipelines, and providing technical guidance while mentoring junior engineers.
AdvertisingAnalyticsConsultingMarketing
No H1B
U.S. Citizen Only
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
Qualification
Required
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
Must be a resident or green card holder of the U.S., U.K. or Canada
Benefits
Competitive compensation
Rapid career advancement
Exposure to a huge range of business challenges
Amazing clients
100% Remote
Company
Mammoth Growth
Mammoth Growth provides data analytics and growth marketing services
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Ryan Koonce
Executive Chairman
Recent News
2023-10-17
Company data provided by crunchbase