Senior Data Analyst - (Remote)
About the job Senior Data Analyst - (Remote)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 ResponsibilitiesWork collaboratively with the product, support, engineering and ad ops to develop analytic monitoring and measurement tools that meet immediate needsDevelop self service tools that allow internal users to answer the next question beyond the initial askAssist on assigned projects through all phaseIncrease the companys analytical ability and comfort level through approachable analyses for non-analytical stakeholders and audience specific guidanceCreate visualizations to monitor business performance and uncover interesting trends for investigationCommunicating requirements to the data engineering members of the team to make sure the platform can support the business needsLead anomaly investigation helping other teams identify root cause and present findingsDefine and create exception based alerting that is meaningful for specific audiences along with investigation and remediation stepsComfortably 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 resultsWork with data engineers and analytics engineers to standardize transformation logic in the dbt layer for consistency and ease of exploration by end usersAdhere to data analysis code best practices and analysis standardsRequirementsLocation: Applicants must be based in the United States.You Have: 4+ years of experience in a data analyst roleExtremely 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 techniquesComfortable 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 pathsExperience with designing and analyzing experiments including but not limited to A/B testingExperience with R or Python for creating data models or data manipulationThe 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 SnowflakeBenefits Remote work environmentTravel opportunities (remember those!?)Comprehensive benefits including 401k, Health, Dental, and Vision insuranceLearning allowanceGenerous Vacation/Time off policiesAdditional side benefits such as home-office upgrades, tuition reimbursement, paid gym memberships and wellness retreats, upgraded flights, cool swag and moreCompany match charitable donations