> Markdown version of [/jobs/ext/1991308-sr-consultant-technical-lead](https://www.wearedevelopers.com/jobs/ext/1991308-sr-consultant-technical-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr Consultant - Technical lead - **Company:** VANTIVE INC. - **Location:** San Francisco, CA, United States - **Experience:** Expert - **Salary:** $152,000.0 - $190,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Amazon S3, Data Analysis, Software Quality, Information Systems, Data as a Services, Data Architecture, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Security, Data Sharing, Data Warehousing, Identity and Access Management, SQL Stored Procedures, Enterprise Data Management, Data Ingestion, Snowflake, Storage Technologies, Information Technology, Data Analytics, Data Delivery, Data Pipelines - **Published:** August 8, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/17873834?backUrl=%2Fcareer%2F17873834%2FSr-Consultant-Technical-Lead-Illinois-Deerfield ## About the Role * Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related discipline. * Master's degree preferred. Experience * 10+ years of experience in data engineering, ETL/ELT, data warehousing, or enterprise data platform development. * 5+ years of experience leading technical teams or enterprise-scale data delivery initiatives. * 5+ years of hands-on experience with Snowflake development, optimization, and secure data design. * Strong experience with AWS data services, especially S3-based data ingestion and processing patterns. * Proven experience designing pipelines for large-scale enterprise reporting, analytics, and data product use cases. ## Description * Provide technical leadership for EDH, AWS S3 ingestion patterns, Snowflake, and enterprise data engineering delivery. * Own end-to-end technical design for data ingestion, transformation, orchestration, and curated data product delivery. * Establish reusable engineering standards, development patterns, naming conventions, code quality expectations, and operational best practices. * Lead technical design reviews and partner with architecture teams to ensure scalable, secure, and maintainable solutions. * Drive modernization toward domain-driven data architecture and trusted data products. Pipeline Development & ETL/ELT Engineering * Design, develop, and maintain scalable ETL and ELT pipelines across batch, incremental, CDC, and file-based ingestion patterns. * Build and enhance pipelines from source systems into AWS S3 and downstream Snowflake layers. * Implement transformation logic, business rules, validations, enrichment, data harmonization, and audit controls. * Support common EDH layers and patterns such as collect, translate, curate, and Snowflake consumption layers. * Partner with application and BI teams to ensure data pipelines meet business reporting and analytics requirements. Snowflake Engineering * Lead Snowflake development activities including schemas, tables, views, stages, tasks, stored procedures, streams, and secure data access patterns. * Optimize Snowflake performance, compute utilization, storage design, query execution, and cost efficiency. * Implement role-based access controls, data sharing patterns, security standards, and platform governance expectations. * Enable curated datasets and reusable data products for reporting, analytics, AI, and advanced analytics use cases. Technical Delivery Leadership * Lead and mentor data engineers, consultants, and technical delivery teams across design, build, test, deployment, and production support. * Review technical designs, code, data models, and deployment packages to ensure quality and adherence to standards. * Manage technical dependencies across infrastructure, security, platform, application, and business teams. * Drive issue resolution, root-cause analysis, and operational readiness for production releases. * Provide hands-on technical guidance when complex pipeline, integration, performance, or data quality issues arise. Data Quality, Governance & Operations * Implement data quality checks, reconciliation controls, observability, lineage, and monitoring across critical data pipelines. * Partner with data governance teams to support metadata, cataloging, ownership, access management, and compliance expectations. * Ensure pipelines are reliable, supportable, secure, and aligned with enterprise standards for privacy, security, and regulatory needs. * Create operational runbooks, support documentation, and transition materials for steady-state operations. Stakeholder Collaboration * Translate business and product requirements into scalable technical solutions and delivery plans. * Collaborate with data architects, product owners, business SMEs, BI teams, AI/ML teams, and platform engineering groups. * Communicate complex technical topics clearly to both engineering teams and business stakeholders. * Proactively identify risks, dependencies, and design tradeoffs, and recommend practical options for resolution. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Smart City, Smart Mobility](https://www.wearedevelopers.com/videos/954-smart-city-smart-mobility) - [WeAreDevelopers LIVE - CSS is DOOMed](https://www.wearedevelopers.com/videos/1838-wearedevelopers-live-css-is-doomed) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)