BigQuery Data Architect

Position Title: BigQuery Data Architect

Location: San Ramon, CA - Onsite

Qualifications

• Education:

• Bachelor s degree in Computer Science, Data Engineering, or a related field (Master s preferred).

• Experience:

• 5+ years of experience in data architecture or data engineering, with at least 3 years focused on Google BigQuery.

• Proven experience designing and implementing data pipelines in Google Cloud Platform (Google Cloud Platform).

• Hands-on experience with ETL processes for financial or ERP data (e.g., Oracle Fusion, Workday, Salesforce).

• Familiarity with Oracle EPM or similar financial planning tools is a plus.

• Technical Skills:

• Expertise in Google BigQuery, including schema design, SQL, partitioning, and clustering.

• Proficiency in Google Cloud Storage (GCS), Google Cloud Scheduler, and BigQuery Streaming API.

• Strong SQL skills for data transformation and query optimization.

• Experience with integration tools like Oracle Integration Cloud (OIC), Informatica, or Talend.

• Knowledge of REST APIs, JSON/CSV processing, and data warehousing concepts.

• Familiarity with data security and compliance standards (e.g., GDPR, CCPA).

• Soft Skills:

• Strong problem-solving and analytical skills.

• Excellent communication and collaboration abilities to work with cross-functional teams.

• Ability to document technical processes clearly and train non-technical stakeholders.

Preferred Qualifications

• Experience with financial data models (e.g., cash flow, receivables, payables).
• Knowledge of Oracle Fusion Financials APIs
• Google Cloud Professional Data Engineer certification or equivalent.
• Prior work on predictive analytics or cash flow forecasting projects.