Data Analyst

BCforward is currently seeking a highly motivated Data Analyst for an opportunity.

Position Title: Data Analyst

Location: Remote, USA

Anticipated Start Date: [28th May 2024]

Please note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start date.

Expected Duration: [ 05/28/2024 to 01/15/2025]

Pay Range: [60] - [62]

Please note that actual compensation may vary within this range due to factors such as location, experience, and job responsibilities, and does not encompass additional non-standard compensation (e.g., benefits, paid time off, per diem, etc.).

Must have skills: Google Analytics, Sheets and Docs, Looker Studio, Excel, Big Query, including expertise with formulas and pivot tables, Web content metadata is required.

Teachable skills: Python, SQL, and R

Optional skills: Tableau, crawler tools such as Screaming Frog

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.

Benefits:

BCforward offers all eligible employees a comprehensive benefits package including, but not limited to major medical, HSA, dental, vision, employer-provided group life, voluntary life insurance, short-term disability, long-term disability, and 401k.

Keywords:

["Data Analyst" AND "Web Analytics"]

About BCforward:

Founded in 1998 on the idea that industry leaders needed a professional service, and workforce management expert, to fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing unique solutions supporting value capture and digital product delivery needs for organizations around the world. Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000 consultants support more than 225 clients globally.

BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients achieve their strategic goals for more than 25 years. Our strong culture and clear values have enabled BCforward to become a market leader and best in class place to work.

BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.

To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our

Privacy Notice and CCPA Addendum . As part of the recruitment process, we may ask for you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process.

This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at-will regardless of the anticipated assignment duration.

Interested candidates please send resume in Word format Please reference job code 222458 when responding to this ad.

---