Mammoth Growth

Helping companies extract, visualize and interpret their data for growth.

Senior Analytics Engineer

Analytics EngineerAnalytics EngineerFull TimeRemoteTeam 11-50H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

23 days ago

Salary

Not specified

Bachelor Degree9 yrs expEnglishAWSDbtFivetranGCPGitJIRASnowflakeSQL

Job Description

Mammoth Growth is a modern data analytics consultancy. We use our unique combination of agnostic tools expertise and data-driven decision making to help our clients grow and thrive in an ever-changing marketplace. We are world-class business consultants who optimize systems to deliver measurable business outcomes. We have completed 850+ engagements with clients in all areas - e-commerce, SaaS, media, D2C, B2B - from start-ups to enterprise.  Mammoth is trusted by industry leaders from Dropbox to Calendly to verify their data, manage their reporting infrastructure, develop growth strategy and provide recommendations and insights that achieve measurable results. At Mammoth Growth, the Senior Analytics Engineer / Jr. Tech Lead focuses on building complex data infrastructure using dbt, Snowflake, and modern ELT tools while providing technical guidance and expertise. You'll design scalable data pipelines, implement governance frameworks, and leverage AI tools to optimize development workflows. The position requires hands-on technical work combined with code review responsibilities and team guidance. What You'll Do 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 What You'll Bring

Job Requirements

  • Technical 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
  • AI & Innovation Skills
  • 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
  • Professional Skills
  • 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
  • We love working with people who like to laugh, smile and joke around.
  • We provide rapid career advancement, exposure to a huge range of business challenges, amazing clients and competitive compensation.
  • We are 100% Remote. Our team is fully distributed (before Covid and forever), allowing you the flexibility of working from home. At this time, we are unable to provide sponsorship. Must be a resident or green card holder of the U.S.,U.K. or Canada.
  • So, what are you waiting for?

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Senior Consumer Analytics Engineer I

Upside

Upside is a technology company that increases the financial power of people and businesses in the real world. Our technology has helped millions of people get more purchasing power on the things they need, and tens of thousands of brick-and-mortar businesses earn measurable profit. Billions of dollars in commerce run through the Upside platform every year, and that value goes directly back to our retailers, the consumers they serve, and towards important sustainability initiatives.

Analytics Engineer23 days ago
Full TimeRemoteTeam 275Since 2016

The Analytics Engineer will build scalable data products, improve the analytics platform, and support internal teams by translating business needs into data assets.

AirflowDagsterDbtPythonSnowflakeSQL
Texas + 3 moreAll locations: Texas, Illinois, New York, District Of Columbia
$130K - $180K / year

Data & Analytics Engineer II

Praxis

Focused patient recruitment.

Analytics Engineer24 days ago
Full TimeRemoteTeam 11-50Since 2002H1B Sponsor

Data and Analytics Engineer II building data pipelines and dashboards at Praxis Precision Medicines

AWSAzureCloudETLPythonSQL
United States
$126K - $140K / year

Data & Analytics Engineer II

Praxis Precision Medicines, Inc.

The era of genetic neuroscience has arrived

Analytics Engineer24 days ago
Full TimeRemoteTeam 51-200Since 2015H1B No Sponsor

Design, build, and maintain scalable ETL/ELT pipelines and Power BI dashboards; write testable Python, R, and SQL code; enforce version control and engineering standards; partner with data scientists to productionize analytics; explore AI tools; and mentor junior staff.

PythonRSQLPower BiGitDatabricksAWSAzureETL/ELTAi
United States
$126K - $140K / year
Analytics Engineer24 days ago
Full TimeRemoteTeam 794Since 2006

The Senior Analytics Engineer will design and build datasets, optimize data modeling, mentor teams, and collaborate on data accessibility across Khan Academy.

AirflowBigQueryCI/CDDbtGitLookerSQL
California
$137.9K - $155.1K / year