20 days ago
Base Salary
$167k - $202k/yr
Responsibilities
- Administer and secure Snowflake, including users, roles, grants, warehouses, resource monitors, access controls, and security policies.
- Design, build, test, document, and own dbt staging, intermediate, mart, and semantic-layer models.
- Build, operate, monitor, and troubleshoot ELT pipelines using Fivetran and related tools, including connector failures, schema changes, backfills, and data-quality issues.
- Own data-platform requests from intake through production, including scoping, estimation, status reporting, and stakeholder acceptance criteria.
- Perform impact analysis and rollback planning for changes to shared tables, models, and connectors.
- Own Git and GitHub workflows for the dbt project, including branching, pull-request review, testing, and deployment.
- Use and help govern AI coding agents for SQL and dbt development, testing, documentation, code review, and debugging.
- Investigate root causes of data-quality, performance, and pipeline issues and optimize queries, models, and warehouse usage.
- Maintain data dictionaries, data-flow diagrams, schema documentation, and the Quality Management System.
- Lead technical reviews and data-design sessions, communicate trade-offs, mentor analysts and engineers, and evaluate platform improvements.
Requirements
- Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field, or equivalent practical experience.
- 10+ years of experience as a data engineer designing, building, and operating data pipelines and warehouses.
- 6+ years of hands-on production Snowflake experience, including administration, access control, warehouse management, and cost and performance monitoring.
- 5+ years building and maintaining production dbt projects, including testing, documentation, incremental models, macros, and CI/CD.
- 5+ years working with ETL/ELT tools and pipeline orchestration, with direct Fivetran experience preferred.
- Daily hands-on experience with agentic coding tools that operate in the codebase, including concrete workflows or integrations and disciplined verification of generated changes.
- Expert SQL skills covering CTEs, window functions, semi-structured data, and performance tuning.
- Daily experience with Git and GitHub pull-request workflows.
- Experience owning or technically leading a data platform and administering platforms containing regulated data such as CUI under NIST SP 800-171.
- Ability to pass a background check and complete required CUI and security training.
- Preferred experience includes Sigma Computing, Tableau, Looker, NetSuite, Salesforce, Python, Terraform, Snowflake SnowPro or dbt certification, and manufacturing, supply-chain, or marketplace businesses.
Benefits
- Comprehensive medical and dental coverage.
- 401(k) plan.
- Generous PTO and leave programs.
- Schaumburg-based role with work involving remote, cross-functional teams across time zones.
- Ability to travel 5% annually in the US for team meetings, offsites, and conferences.
About Fictiv
Fictiv builds a digital platform for on-demand manufacturing of custom parts, offering CNC machining, 3D printing, and urethane casting from prototype through low-volume production. Companies use its global manufacturing network and hubs in the U.S., China, India, and Mexico to source parts and manage supply chains. Founded in 2013 and headquartered in the San Francisco Bay Area, Fictiv was acquired by Misumi Group and has delivered over 35 million parts.