Technical Specialist

Role Purpose

This position involves preparing controlled data foundations for specific use cases within the cloud environment.

Key Responsibilities

• Profile approved MOSAIC and CLDW BigQuery tables to develop curated, read-only views.
• Standardize measures, dimensions, naming conventions, date fields, and implement robust data-quality checks.
• Support query performance optimization for AtScale connectivity and source-model validation.
• Create structured Enterprise Architecture application records and mappings in approved formats.
• Stage documents and files into the designated GCS locations.
• Document source-to-standard mappings along with SQL-based reconciliation evidence.

Required Skills

• 7+ years of data engineering experience focusing on BigQuery, Cloud Data Engineering (CLDW), and SQL.
• Proficiency in Google Cloud Storage (GCS) and structured formats like CSV/JSONL.
• Ability to build analytical views and validation queries.
• Familiarity with financial and healthcare domain data is a plus.
• Basic Python or equivalent scripting skills required for automation tasks.
• Experience supporting semantic-layer integrations, AI models, and analytics pipelines.

Note: This role focuses on PoC staffing; no new production ingestion pipelines will be developed in this engagement.