The Data & Analytics team consists of data analysts, data engineers and analytics engineers working to build the most effective platform and tools to help uncover opportunities and make decisions with data here at Arkestro. We partner with Product, Support, Ad Operations and other teams within the Engineering department to understand behavior, develop accurate predictors and build solutions that provide the best internal and external experience possible.
The Data Analyst role will be assisting the analysts in their support of the business and helping to guide the direction through data based decisions. They will provide support in developing analytical processes and make use of data in meaningful ways that produce positive results.
Our current analytics toolkit consists of Tableau, Metabase and dbt running on top of a Snowflake data warehouse. We are exploring new BI tools and expect this position to add value in the implementation of this tool.
Essential Responsibilities
- Work collaboratively with the product, support, engineering and ad ops to develop analytic monitoring and measurement tools that meet immediate needs
- Develop self service tools that allow internal users to answer the next question beyond the initial ask
- Assist on assigned projects through all phase
- Increase the companys analytical ability and comfort level through approachable analyses for non-analytical stakeholders and audience specific guidance
- Create visualizations to monitor business performance and uncover interesting trends for investigation
- Communicating requirements to the data engineering members of the team to make sure the platform can support the business needs
- Lead anomaly investigation helping other teams identify root cause and present findings
- Define and create exception based alerting that is meaningful for specific audiences along with investigation and remediation steps
- Comfortably test and critique the process we use for exploratory data analysis and A/B testing. This includes helping stakeholders decide on testing strategy, generating baselines, approximating sample sizes and performing analysis of test results
- Work with data engineers and analytics engineers to standardize transformation logic in the dbt layer for consistency and ease of exploration by end users
- Adhere to data analysis code best practices and analysis standards
Requirements
- Applicants must be based in the United States.
- 4+ years of experience in a data analyst role
- Extremely strong SQL skills (CTEs, window functions, optimization)
- Experience with or more major BI tools like Tableau, Looker, PowerBI, etc. (Domo preferred)
- Experience using machine learning techniques
- Comfortable working with multi-TB cloud data warehouses (Big Query, Snowflake, Redshift)
- Knowledge of Ad Tech, Google Ad Manager and all of its fun quirks (so fun)
- Experience with web analysis such as creating product funnels, user behavior, and paths
- Experience with designing and analyzing experiments including but not limited to A/B testing
- Experience with R or Python for creating data models or data manipulation
- The ability to make your teammates laugh (it wouldnt hurt if you were fun to work with is what Im saying)
- Familiarity with event tracking systems (NewRelic, Snowplow, etc)
- Experience with dbt and Snowflake
Benefits
- Remote work environment
- Travel opportunities (remember those!?)
- Comprehensive benefits including 401k, Health, Dental, and Vision insurance
- Learning allowance
- Generous Vacation/Time off policies
- Additional side benefits such as home-office upgrades, tuition reimbursement, paid gym memberships and wellness retreats, upgraded flights, cool swag and more
- Company match charitable donations
