Wpromote is looking for a Data Analyst with excellent math, logic, and interpersonal skills with strong attention to detail and the desire to learn new tools and strategies. This individual will contribute to data cleansing, data analysis, and visualization initiatives. The primary function of this role will be to create end-to-end solutions and provide actionable insights to our client’s marketing initiatives. This individual will also maintain existing solutions while gaining guided experience in advanced analytics to enable increased responsibility over time. This individual will also have the opportunity to work with exciting clients in the e-commerce, retail, and entertainment space while interacting with the Engineering, Reporting, Product, Paid Media, and Data Science teams.
At Wpromote, we believe that great work is only possible with great people. Our goal is to build a better, more inclusive work environment and support our people at every stage of their careers by prioritizing a strong work-life balance through our policies and benefits listed below. As a Best Place to Work according to both Ad Age and Glassdoor and Adweek’s Fastest Growing Digital Agency, we are moving fast to expand our teams and bring new experts into the fold to keep pushing the boundaries of what’s possible in marketing.
We offer:
-Remote-first culture
-Half-day Fridays year round
-Unlimited PTO
-Challenger Recharge week (Summer)
-Extended Holiday break (Winter)
-Flexible schedules
-Work from anywhere options*
-100% paid parental leave
-401(k) matching
-Medical, Dental, Vision, Life, Pet Insurance
-Sponsored life insurance
-Short Term Disability insurance and additional voluntary insurance
-LinkedIn Learning Membership and more!
The anticipated annual salary for this role will range from $65,000 – $80,000, based on consideration of a wide array of factors unique to each candidate, including but not limited to skill set, years and depth of experience, education and certifications, competitive benchmarks, scope of responsibility, market dynamics, geographic location, and respective state’s salary threshold for exempt employees. The total compensation package for this role will include benefits (listed above).
*This position may be performed remotely in most states within the US, with some exclusions
**This position is not eligible for immigration sponsorship
You Will Be
- Making platform and CRM data more accessible, understandable, and usableLearning to transform, improve, and integrate data, depending on the business requirements
- Planning and scoping end-to-end data analysis projects by identifying the business problem and selecting appropriate investigative testing and solutions
- Using SQL and BigQuery to combine data sets across multiple sources
- Delivering the data in a useful and appealing way to technical and non-technical audiences using Looker
- Querying, cleaning, formatting, and structuring data for analysis
- Interpreting, presenting, and communicating results by creating presentations and/or dashboards that communicate a succinct and compelling business story, driving decisions through research results
- Learning how to automate data gathering, blending, and transformation of data
- Working across various departments to understand client needs
You Must Have
- 1-2 years of hands-on data analysis experience within an agency or in-house environment
- Intermediate to advanced programming skills (R or Python) for data cleaning, data modeling, API calls, etc
- Intermediate to advanced experience in SQL (i.e.: window functions, stored procedures, and views, Triggers, Unions, CTEs, subqueries, debugging)
- Intermediate to advanced competency in statistics, probability, and linear algebraAdvanced Excel and/or Google Sheets skills
- Familiarity with at least one BI platform and the ability to learn others (i.e.: Looker, Tableau, MicroStrategy, Power BI, Google Data Studio, Datorama, etc.), with a preference for Datorama and/or Looker
- Experience/familiarity with version control (i.e.: Git, Bitbucket, etc.)
- Excellent analytical and problem-solving skills with strong attention to detail
- The ability to work with large amounts of information and see the bigger picture
- Excellent foundational math/statistical skills with the ability to juggle facts, figures, and number crunching
- Strong communication skills, with experience in creating and delivering presentations and executive summaries
- Critical thinking: the ability to look at numbers, trends, and data and come to new conclusions based on the findings
- Familiarity with cloud computing
- The ability to frame business problems into quantitative methods and testing
- An interest or passion for marketing analytics and/or personal project portfolio
- Bachelor’s degree in a quantitative field (Stats, Mathematics, CS, Information Technology, Economics, Engineering, etc.)
Nice to Have
- Experience with statistical modeling and/or machine learning
- Knowledge with Media Advertising Platforms, such as Google Ads, Bing Ads, Yahoo Gemini
- Experience with Analytics software, such as Google Analytics and Adobe Analytics
- Experience with statistical modeling, data mining, and/or machine learning
- Experience with Looker and/or Tableau
- Working knowledge in CLI and bash scripting
- Experience with cloud computing (AWS, GCP, Azure, etc.)
Wpromote is committed to bringing together individuals from different backgrounds and perspectives, providing employees with a safe and welcoming environment free of discrimination and harassment. We strive to create a diverse & inclusive environment where everyone can thrive, feel a sense of belonging, and do impactful work together. As an equal opportunity employer, we prohibit any unlawful discrimination against a job applicant on the basis of their race, color, religion, gender, gender identity, gender expression, sexual orientation, national origin, family or parental status, disability*, age, veteran status, or any other status protected by the laws or regulations in the locations where we operate. We respect the laws enforced by the EEOC and are dedicated to going above and beyond in fostering diversity across our workplace.
Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and certain state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Wpromote.
This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9. For more information on E Verify, or if you believe that your employer has violated its E-Verify responsibilities, please contact DHS.