Main Duties & Responsibilities:
- Build and maintain Bronze/Silver Layer Pipelines: Ensure core data sources land accurately, on time, and with full lineage.
- Lead Data Ingestion, Transformation, and Enrichment: Own the end-to-end pipeline from raw file landing through cleansed, conformed staging tables, including deduplication, standardization, code mapping, and entity resolution.
- Develop Automated Ingestion Pipelines: Use Snowpipe, Matillion, or custom solutions with reliability, observability, and minimal manual intervention in mind.
Education and Experience:
- Required: 5+ years of professional data engineering experience, with at least 3 years working in modern cloud data environments.
- Required: 2+ years hands-on experience with Snowflake, including performance tuning, Snowpipe, and Snowflake-specific optimization patterns.
- Strong SQL skills. Write efficient, readable, well-structured SQL and can debug complex query performance issues.
Technical Stack and Environments:
- Data Platforms (Snowflake, AWS Redshift, S3)
- Transformation (dbt, Matillion)
- Orchestration (Airflow, Dagster)
Precision AQ
Precision AQ is building a centralized Data Hub to consolidate fragmented data infrastructure, establish enterprise-wide data governance, and enable AI-ready analytics across our life sciences portfolio. This is a foundational initiative, not a maintenance role.