Job Title : Sr Data Engineer (Snowflake / AWS)
Location: Dallas TX (or) Remote
Duration: 12 months
Purpose: Build and run the pipelines that bring event, client and third-party data into JackIQ, clean, secure and on time.
Responsibilities
- Build ingestion from Cvent (existing API connection), Bizzabo and other event platforms, booth/sensor feeds, Excel and file drops, and industry reports.
- Strip or tokenise PII at ingestion; apply tenant tagging so data lands in the right client boundary.
- Develop bronze → silver → gold transformations and gold-layer marts behind the semantic layer.
- Use InfoVision's pattern libraries and AI code generation for templated layers (target 90%+ generated for source-to-bronze, ~80% for bronze-to-silver).
- Orchestrate, schedule and monitor loads; move toward near-real-time where the use case needs it (Snowpipe Streaming, Streams/Tasks).
- Build data-quality checks and self-healing / auto-remediation for low-risk failures; route complex issues to humans.
- Maintain CI/CD for data code and document lineage.
Must have
- 8–12 years in data engineering; 3+ years on Snowflake.
- SQL, Python, Snowpark; dbt; Snowpipe, Streams and Tasks.
- REST API ingestion and incremental/CDC patterns.
- AWS: S3, Lambda, Glue or Step Functions, IAM.
- Git-based CI/CD (GitHub Actions or similar).
Nice to have
- Experience with Cvent, Bizzabo or other event / CRM / marketing platforms.
- IoT or streaming data (Kinesis, Kafka).
- Data-quality frameworks (Great Expectations, dbt tests, Soda).
- SnowPro Core or Data Engineer certification.