Role overview
Design, build, and maintain data pipelines and cloud data architecture for a client engagement, with Snowflake as the core platform. The individual contributor will support data integration, replication, transformation, storage, and analytics, while working with client stakeholders and cross-functional teams. The engagement is expected to last about a year and includes regular travel to Missouri.
Responsibilities
- Develop and maintain data pipelines, integration solutions, and data architecture.
- Configure and use Snowflake for ingestion, storage, performance, and security.
- Apply replication and transformation tools to move and prepare data for analysis.
- Support data modeling, ETL processes, and data warehousing practices.
- Diagnose pipeline and platform issues, and contribute to data quality, governance, and lifecycle management.
- Collaborate with client stakeholders and project teams to deliver data engineering work.
Requirements
- Typically 4+ years of senior data engineering experience, including hands‑on Snowflake work.
- Experience with Qlik Replicate and Compose, DBT Labs, Astronomer, and GitHub.
- Strong understanding of data engineering, modeling, ETL, and data warehousing.
- Experience with AWS or Azure and cloud‑based data services.
- SQL and scripting skills, such as Python or PowerShell, for data work and automation.
- Strong troubleshooting, communication, and collaboration skills; prior consulting experience is required.
- Must be authorized to work in the United States without current or future employment‑based visa sponsorship.
Nice to have
- A bachelor's or master's degree in computer science, information systems, or a related field is preferred.
Benefits and work setup
- Travel to Columbia, Missouri every other week, typically Sunday evening through Thursday evening, for the engagement. Standard availability is 8:30 a.m.–5:30 p.m. Eastern, Monday through Friday; occasional additional client‑site travel may be needed.
- Annual base salary range: $110,000–$160,000, subject to change and candidate factors.
- Benefits include 25 days of accrued paid time off plus holidays, paid training time, reimbursement for commuting, phone, and home internet, medical, dental, and vision coverage, and 401(k) matching.