Data Analyst, Patagonia Action Works
Remote
Contract Mid-level / Intermediate
Job Title: Action Works Data Analyst
Reports to: Head of Digital Activism, Claire Goodrich
Location: Remote – living in the following areas: California, Colorado, Connecticut, Florida, Hawaii, Illinois, Main, Maryland, Massachusetts, Minnesota, Montana, Nevada, New York, North Carolina, Ohio, Oregon, Texas, Utah, Vermont, Virginia, Washington
Type: 6-month Contract Position
COVID-19 Vaccinations: Patagonia requires all employees to demonstrate proof of receiving a COVID-19 vaccination as a condition of their employment.
As the Action Works Data Analyst (AWDA) you are responsible for merging data from CyberGrants and Wordpress, as well as manipulating the dataset that provides the foundation for Patagonia Action Works’ grantee data. As the data analyst, you will work with a cross-functional team from Digital Studio and Enviro to deliver high quality data sets built to the specifications of the Action Works platform. You will also create additional data sets for the process of vetting eligibility and content with the Enviro team, merge new data from the edit and proof teams, and ensure that any additional, updated, or relevant data is reflected back into the final data sets. You will be responsible for delivering additional data reports required for the completion of Action Works grantee onboarding process as requested.
What You’ll Do
- Reconcile CyberGrants data set with Action Works Wordpress data set to ensure a complete and consistent data set across platforms
- Work with internal stakeholders, external donation, and grant-making partners to ensure organization EINs are valid, updated and accurate across platforms.
- Ensure updated EINs are contained in final dataset for Wordpress update.
- Format all data fields according to Action Works data specifications ensuring consistent, error free data and formatting
- Create relevant reports for Enviro checks as well as edit and proof review; merge updates and edits back into primary data
- Manipulate the data set to identify eligibility of all existing and new grantees (the eligibility period spans two years)
- Provide additional reports as needed to assist the Action Works team in analyzing engagement data and finalizing the grantee onboarding process with organization meta data
- Assist with final quality assurance checks in coordination with Enviro team at various points to ensure the final dataset has not been corrupted at later stages in the process
- Contribute to and adjust existing documentation throughout the data process, including steps and important formulas
- Contribute to weekly data-related meetings to ensure accurate and timely delivery of specific data requests across.
Who You Are
- Passionate – cares deeply about saving our home planet.
- Detail Oriented – dots all i's and crosses all t's.
- Methodical- able to gather appropriate input and make clear, well-reasoned decisions.
- Self-reflective- Acknowledge own's experience and experiences of others.
- Team player - brings positive energy and is a strong collaborative.
- Flexibility- able to remain open in times of change.
Experience You Bring
- A high level of Excel proficiency and relational databases (i.e. SQL) is required and familiarity with Wordpress is strongly preferred.
- Other skills include the ability to:
- Use complex formulas to reference, extract and merge data across multiple data sets
- Use Pivot tables to simplify large data sets
- Implement best practices for maintaining data integrity and regular backups
- Ability to meet project milestones and communicate clearly with team members about potential challenges along the way
- Highly organized and detail oriented with an ability to quickly identify discrepancies and errors
- Prior experience with data analysis or data migrations projects preferred.
- Highly collaborative and willing to work with and take direction from multiple stakeholders.
- Comfortable with Python and XML languages is a plus.
Employee Conduct
It is the responsibility of every employee to contribute to a positive work environment through cooperative and professional interactions with co-workers, customers and vendors.
Covid-19 Vaccinations
Patagonia requires all employees who enter a Patagonia owned or operated facility or who physically interact with others as part of their job duties to demonstrate proof of receiving a COVID-19 vaccination as a condition of their employment.
Explore more AI/ML/Data Science career opportunities
Find open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general, filtered by job title or popular skill, toolset and products used.
- Open Computer Vision Engineer jobs
- Open Senior Marketing Data Analyst jobs
- Open Research Scientist, Computer Vision jobs
- Open Data Scientist II jobs
- Open Data Engineer (Remote) jobs
- Open Research Scientist, NLP jobs
- Open Machine Learning Engineering Manager jobs
- Open Big Data Engineer jobs
- Open Marketing Data Analyst jobs
- Open Senior Software Engineer, Machine Learning jobs
- Open Data Analyst Intern jobs
- Open Lead Data Analyst jobs
- Open Analytics Engineer jobs
- Open Business Data Analyst jobs
- Open Machine Learning Scientist jobs
- Open Data Operations Analyst jobs
- Open Senior Product Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Senior Data Scientist (Remote) jobs
- Open Senior Data Analyst (Bangkok Based, relocation provided) jobs
- Open Head of Data Science jobs
- Open Research Scientist, Machine Learning/Deep Learning jobs
- Open Senior Software Engineer, Data Engineering jobs
- Open Financial Data Analyst jobs
- Open Junior Data Engineer jobs
- Open Excel-related jobs
- Open Redshift-related jobs
- Open Business Intelligence-related jobs
- Open Hadoop-related jobs
- Open Economics-related jobs
- Open Snowflake-related jobs
- Open Streaming-related jobs
- Open Kafka-related jobs
- Open PyTorch-related jobs
- Open GCP-related jobs
- Open Azure-related jobs
- Open Kubernetes-related jobs
- Open NLP-related jobs
- Open BigQuery-related jobs
- Open Git-related jobs
- Open Pandas-related jobs
- Open Data Warehousing-related jobs
- Open Computer Vision-related jobs
- Open Data Mining-related jobs
- Open Consulting-related jobs
- Open NoSQL-related jobs
- Open Classification-related jobs
- Open KPIs-related jobs
- Open ML models-related jobs
- Open Distributed Systems-related jobs