Back to Jobs
Recently postedTechnology

BI Analyst With Google Suite & Google BigQuery (Only Visa Independent Candidate/W2)

SumasEdge CorporationUpper Saddle River, NJ🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationUpper Saddle River, NJ, United States
SQLMicrosoft ExcelMicrosoft OfficeMicrosoft PowerPointGoogle WorkspaceLookerBigQueryJupyterPandasPythonGenerative AI

Job description

Job Title:- BI Analyst With Google Suite & Google BigQuery
Location:- Upper Saddle River (Hybrid)
Duration:- Contract
Job Description

Project Objective and Summary: The primary objective of this role is to provide hands-on Business Intelligence (BI) and reporting support to maintain established reports, dashboards, and automated workflows. The contractor will ensure business continuity by leveraging proficiency in SQL, Google BigQuery, Excel/Power Pivot, and Looker Studio, supported by a working knowledge of Google Sheets, Python, and Google Apps Script for troubleshooting.

Scope of Responsibilities and Tasks The contractor will be responsible for maintaining existing operations across the following key areas:

  • Database & Query Management: Apply intermediate SQL proficiency to understand, modify, and troubleshoot existing reporting queries, including the use of joins, Common Table Expressions (CTEs), aggregations, window functions, and date logic. Work hands-on within Google BigQuery to maintain reporting datasets, tables, and views, specifically investigating data availability and scheduled refresh issues.
  • Reporting & Dashboard Maintenance: Maintain existing dashboards in Looker Studio / Google Data Studio, actively troubleshooting BigQuery connections, calculated fields, filters, aggregations, and refresh issues. Maintain large reporting workbooks in Advanced Excel using PivotTables, lookup functions, data cleaning techniques, and SUMIFS/COUNTIFS. Maintain existing Power Pivot / Excel Data Models, including table relationships and calculated measures, resolving any calculation or refresh errors. Maintain Google Sheets reporting, troubleshooting data connections and formulas.
  • Script Maintenance & Automation: Run, understand, and apply minor fixes to existing Python data preparation and reporting scripts (using pandas, Jupyter Notebooks, and Google Colab). Understand and make minor updates to existing Google Apps Scripts, utilizing execution logs and scheduled triggers to investigate common failures and escalate unresolved issues.
  • Data Preparation & Quality Assurance: Combine multiple data sources, maintain product/SKU mappings, actively identify duplicates or missing mappings, and reconcile sales and units between source data and finalized reports.
  • Business Reporting & Analysis: Analyze metrics such as sales, units, average selling price, market share, and promotional performance utilizing YoY, YTD, and rolling-period comparisons.
  • AI-Assisted Productivity: Responsibly utilize company-approved AI tools, specifically Google Gemini, for troubleshooting, drafting minor SQL/script updates, documenting processes, and summarizing reports. The contractor must independently verify all AI-generated outputs and strictly adhere to company data privacy and security policies.
  • The contractor will play a critical role in supporting an ongoing implementation project and would be expected to test data mappings, verify ingested data against transmitted data, validate reports, and work closely with stakeholders to proactively identify and report any data issues.

Communication and Documentation

  • Translate business requests into clear reporting requirements and comprehensively explain data discrepancies.
  • Document recurring processes and coordinate directly with HQ data teams regarding data access or source-data issues.

Technical Requirements and Tools

  • Required Skills: Intermediate SQL, Google BigQuery, Advanced Excel & Power Pivot, Looker Studio, Basic Python, Google Sheets, Google Apps Script, Google Gemini.
  • Preferred Experience (E-commerce/Retail): Hands-on experience using Stackline and Circana Unify+ for retail/e-commerce reporting, data extraction, and analysis.
  • Preferred Experience (Enterprise/Systems): Familiarity with SAP reporting and data extraction, specifically SAP Hana and SAP BW.
  • Preferred Experience (Software Suites): Familiarity with Google Workspace (Gmail, Calendar, Meet, Drive, Docs, Slides, NotebookLM) and Microsoft Office (Word, PowerPoint).

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs