Title: Data Analyst Location: Complete Remote Duration: 7 Months
Business Justification: It will vary, some time will be spent working with the team via slack or video calls, some time will be spent crunching numbers via spreadsheets and various tools mentioned in the JD, and producing reports. Some time may also be spent helping to automate certain repeatable processes in support of reporting.
Would join a 4 person team that is focused on the content of our corporate website. We are re-platforming to a new CMS, so we are in the midst of migrating thousands of pages. Need help running inventories and analysis of a large body of content from multiple sources of data as well as multiple CMS platforms. SEO or digital strategy experience is a plus.
As a Data Analyst, you will serve a pivotal role supporting data-driven projects that fuel internal digital transformation efforts. Your expertise will be instrumental in managing and deriving valuable insights from extensive datasets, including data from large websites with over 50,000 pages. You will work to merge, normalize and harmonize data from multiple disparate sources into single datasets that support analysis of website performance for optimization, migrations and content deprecations. You'll guide teams through the complexities and intricacies of large datasets, delivering actionable insights that shape our business strategies.
Responsibilities:
Work collaboratively to produce comprehensive views of content inventories and performance data to support analysis, insights, and recommendations for stakeholders, content creators, taxonomists, and teams involved in content migration or deprecation.
Extract website inventories and metadata from various sources including AEM, Wordpress, Screaming Frog (site crawler), Botify, etc.
Overlay performance data from Google Analytics, Salesforce Orgs, Google Search Console, internal datasets, etc.
Focus primarily on data processing tasks such as merging complex datasets, cleansing, de-duping, and creating accurate and filterable reports in spreadsheets like Google Sheets or Excel.
Produce visualizations based on the data to illustrate insights including charts, Tableau Vizzes, and other storytelling visuals.
Develop spreadsheets for handoff to Ops teams for automating tasks such as bulk tagging of content from the auto-classification process or mass content deprecation.
Specifically manage and produce the Global Content Inventory, the single source of truth (SSOT) for all pages on the corporate website, including associated metadata and GA performance data (60K+ rows and 160+ columns).
Work to automate the production of the Global Content Inventory into a nearly real-time report. Utilize Python scripts, Vlookups, or other methods to automate data processing and generate required views.
Requirements:
Bachelor's degree in Computer Science, Statistics, Mathematics, or related field.
Proven experience in data analysis, preferably in a web analytics or digital marketing environment.
Proficiency in extracting and processing data from various sources including Website CMS, Website crawlers, Google Analytics, Big Query and more.
Strong skills in data processing including merging complex datasets, data cleansing, de-duplication, and report generation using tools like Google Sheets or Excel.
Experience with scripting languages like Python for automating data processing tasks.
Familiarity with visualization tools such as Tableau for creating compelling visualizations to communicate insights effectively.
Excellent communication and collaboration skills to work effectively with cross-functional teams.
Attention to detail and ability to manage large datasets efficiently.
Prior experience managing content inventories and performance data is a plus.
Must have skills: Google Analytics, Sheets and Docs, Looker Studio, Excel, Big Query, including expertise with formulas and pivot tables.
Teachable skills: Python, SQL, and R Optional skills: Tableau, crawler tools such as Screaming Frog.
Notice to California Applicants: SPECTRAFORCE® is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation. At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $55.00/hr.
