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
Location:
Applicants must be based in the United States.
You Have:
4+ years of experience in a data analyst role
Extremely strong SQL skills (CTEs, window functions, optimization)
Experience with one 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)
Nice to haves:
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