Analytics Engineer

Sift Science, Inc.; United States; Remote; USD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking company as an Analytics Engineer, where you will play a crucial role in enhancing the Business Operations team's reporting and analytics architecture. Collaborate with various stakeholders to develop insightful reports and dashboards, while leveraging advanced SQL and Python skills to drive automation and improve data quality. This position offers an exciting opportunity to work in a dynamic environment that values innovation and teamwork, providing you with the chance to make a significant impact on business operations and analytics capabilities.

Benefits

Competitive total compensation package

401k plan

Medical, dental and vision coverage

Wellness reimbursement

Education reimbursement

Flexible time off

Qualifications

• 5+ years of advanced SQL experience, preferably with Snowflake.
• Intermediate to advanced Python skills with familiarity in libraries like pandas.

Responsibilities

• Maintain and expand reporting capabilities through SQL architecture design.
• Work with team members to keep sales reporting up to date.

Skills

SQL

Python

Data Analysis

Data Documentation

Business Intelligence Tools

Version Control (GitHub)

Data Quality Monitoring

B2B SaaS Metrics

Tools

Snowflake

DBT

Looker

Tableau

PowerBI

Airflow

Databricks

Job description

About the Team:

Reporting to the Senior Director of Revenue Operations, the Analytics Engineer works with the Business Operations team and its partner teams to develop and maintain critical reporting and analytics architecture. Being part of a lean team, the Analytics Engineer will also often work directly with stakeholders on creating and refining new reports and dashboards as needed, but will primarily work with Analysts and SMEs within the Business Operations team.

Key Responsibilities:

• Maintain and expand the Business Operations team’s reporting capabilities through thoughtful design of SQL architecture.

• Increase the team’s total analytics capacity by introducing or improving automation wherever possible.

• Work with team members in Revenue Operations to keep sales reporting up to date by ensuring all changes to sales process or CRM management are reflected accurately in downstream reporting frameworks.

• Improve and expand monitoring of data quality, exception reporting, and status reporting on all analytics jobs and pipelines owned by the Business Operations team.

• Work with Business Operations Analysts to streamline their modeling and other analytics processes.

• Monitoring and troubleshooting of issues anywhere along a data pipeline ultimately serving up reporting to the business.

• Data documentation and expansion of the team’s data dictionary and directory.

• Support partner teams as needed in terms of explaining reporting frameworks and metrics, and occasionally performing ad-hoc analyses or expanding existing dashboards.

Role Requirements:

• Advanced SQL and 5+ years of SQL experience, preferably with Snowflake or a similar cloud SQL data warehouse

• 2+ years of experience with a SQL modeling tool such as DBT, SQLDBM, or similar

• Intermediate to advanced Python, and familiarity with cloud notebooks and Python libraries including or similar to pandas, snowflake connector or SQLAlchemy, requests, and json, among others

• 3+ years of experience developing and maintaining reporting, with one or more BI tools such as Looker (preferred), Tableau, PowerBI, Sigma, Metabase, or similar

• 2+ years of experience working with version control tools such as Github

• Experience working with data from Salesforce, Hubspot, or a similar CRM

• Experience being responsible for maintenance of business-critical data models and reporting frameworks

• Familiarity with common B2B SaaS go-to-market and financial metrics (eg conversion metrics, churn rates, net and gross dollar retention, etc.)

• Experience with Airflow or another orchestration tool is a bonus

• Experience with Databricks is a bonus

Benefits and Perks:

• Competitive total compensation package

• 401k plan

• Medical, dental and vision coverage

• Wellness reimbursement

• Education reimbursement

• Flexible time off

A little about us:

Sift is the AI-powered fraud platform securing digital trust for leading global businesses. Our deep investments in machine learning and user identity, a data network scoring 1 trillion events per year, and a commitment to long-term customer success empower more than 700 customers to grow fearlessly. Brands including DoorDash, Yelp, and Poshmark rely on Sift to unlock growth and deliver seamless consumer experiences. Visit us at sift.com and follow us on LinkedIn.