Analytics Engineer

Fetch Agency - Madison, WI

Full-time

Remote - Madison, WI

Apparel Manufacturing

About the position

The position involves modeling and analyzing data using SQL best practices to enhance OLAP and OLTP query performance. The role requires leveraging various tools and technologies such as DBT, Snowflake, Airflow, and AWS to generate actionable insights from large datasets. The candidate will be responsible for translating business requirements into data models, communicating findings to stakeholders, and ensuring data quality and health through testing and monitoring.

Responsibilities

• Model and analyze data utilizing SQL best practices for OLAP/OLTP query and database performance.
• Leverage Data Build Tool (DBT), Snowflake, Airflow, AWS infrastructure, CI/CD, testing, and engineering best practices.
• Generate innovative approaches to datasets with millions of daily active users and terabytes of data.
• Translate business requirements for near-real-time actionable insights into data models and artifacts.
• Communicate findings clearly both verbally and in writing to a broad range of stakeholders.
• Perform administrative duties for Snowflake, Tableau, and DBT/Airflow infrastructure.
• Test, monitor, and report on data health and data quality.
• Lead data documentation and data discovery initiatives.

Requirements

• Proficient in SQL with an understanding of performance optimization.
• Experience with data modeling and orchestration tools.
• Familiarity with relational (SQL), non-relational (NoSQL), and object data stores (e.g., Snowflake, MongoDB, S3, HDFS, Postgres, Redis, DynamoDB).
• Solid understanding of ETL vs. ELT processes, data warehouses, and business intelligence tools.
• Prior experience communicating about data with internal and external customers.
• Highly motivated to work autonomously and manage multiple work streams.
• Interest in building and experimenting with different tools and tech, sharing learnings with the organization.
• Experience developing and maintaining DBT or Airflow in production environments.
• Experience programmatically deploying cloud resources on AWS, Azure, or GCP.
• Experience implementing data quality, data governance, or disaster recovery initiatives.
• Proficient in at least one imperative programming language (i.e., Python).

Benefits

• Equity for everyone
• 401k Match: Dollar-for-dollar match up to 4%
• Comprehensive medical, dental and vision plans for everyone including pets
• Continuing Education: $10,000 per year in education reimbursement
• Employee Resource Groups for diversity and inclusion
• Flexible PTO and 9 paid holidays
• 20 weeks of paid parental leave for primary caregivers, 14 weeks for secondary caregivers
• $2,000 incentive for new family members to assist with childcare costs
• Hybrid Work Environment with options for remote work.