What are the responsibilities and job description for the Snowflake Data Architect position at Lumicity?
Senior Snowflake Data Engineer (Contract | Long-Term)
We’re partnering with an enterprise data platform team on a long-term initiative where Snowflake is the primary cloud data warehouse supporting analytics and reporting at scale. This role is ideal for someone whose core strength is Snowflake, with some experience working alongside Databricks in modern data ecosystems.
What you’ll be doing
- Building and maintaining ELT pipelines primarily in Snowflake
- Writing, optimizing, and troubleshooting complex Snowflake SQL
- Managing Snowflake objects: virtual warehouses, schemas, streams, tasks, and secure views
- Supporting performance tuning, cost optimization, and warehouse sizing
- Collaborating with analytics and business teams to deliver trusted datasets
- Integrating upstream or adjacent processing from Databricks where applicable
What we’re looking for
- Strong, hands-on Snowflake Data Engineering experience (primary platform)
- Advanced SQL expertise within Snowflake
- Experience designing ELT pipelines and analytical data models
- Working knowledge of Databricks / Spark in a production environment
- Understanding of Snowflake governance, security, and cost controls
Nice to have
- dbt experience
- Experience supporting enterprise analytics or reporting teams
- Exposure to cloud-based data platforms in large-scale environments
Engagement details
- Contract (long-term)
- Competitive hourly rate
- Remote or hybrid (US-based)
This role is best suited for engineers who go deep in Snowflake and can collaborate across platforms when Databricks is part of the stack.
Salary : $50 - $65