GCP BigQuery Data Engineer

Description

The resource will develop and support a reusable analytics data framework using daily GA4 and Firebase BigQuery exports. Key responsibilities include writing and maintaining BigQuery SQL, Scheduled Queries, Routines (stored procedures/UDFs), and data pipelines to transform raw event-level export data into curated, analytics-ready data views. This includes building consistent event- and session-level models that can be used reliably by BI and analytics teams.

Primary Responsibilities

• Assist with the ingestion, transformation, and evolution of data products within our BigQuery environment, working closely with the data engineering lead.
• Bring in data from diverse sources, including Google Analytics (GA4), Firebase, and SFTP servers, into BigQuery.
• Take raw, nested JSON data from Google Analytics and Firebase and transform it into a standardized, workable event-level and session-level framework using BigQuery SQL.
• Create and maintain curated, aggregated data views and materialized tables in BigQuery to be used by analysts and dashboard developers.
• Utilize scheduled queries, stored procedures, and other BigQuery features to automate data transformation and materialization processes.
• Work with business users to understand requirements, and with dashboard developers to provide them with the clean, curated data views they need for their analytics in tools like Power BI.

Technical Skills

• Must have strong SQL skills, with specific experience in handling nested data structures within BigQuery.
• Python skills are also essential for working with our Cloud Function-based data pipelines.

Key Experience

Deep familiarity with the data schemas exported from Google Analytics (GA4) and Firebase is highly desired to allow the candidate to be effective from day one.

Skills

• Python
• SQL
• Firebase
• BigQuery
• Spark

Top Skills Details

• Python
• SQL
• Firebase
• BigQuery

Required Skills

Additional Skills & Qualifications

• Strong BigQuery SQL development skills
• Experience with GA4 and Firebase daily BigQuery data exports
• Experience creating event-, session-, and user-level data models from GA4 export data
• BigQuery Scheduled Queries, Routines, and daily data refresh orchestration
• Strong dimensional data modeling and analytics data design skills
• Ability to document logic and work collaboratively with BI, analytics, and business stakeholders

Experience Level

Intermediate Level

Job Type & Location

This is a Contract position based out of Piscataway, NJ.

Pay And Benefits

The pay range for this position is $40.00 - $42.00/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a hybrid position in Piscataway,NJ. Application Deadline This position is anticipated to close on Sep 25, 2026.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems And TEKsystems Global Services

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.