Snowflake Data Warehouse Architect Lead
USA TX Home Office (TXHOME), United States
USD 170K-230K Senior-level Full Time
Tasks
- Advise on AWS data services for end to end pipelines
- Architect Snowflake data warehouse solutions
- Collaborate with engineering and analytics teams
- Define data architecture patterns standards and best practices
- Design DDL and configure Snowflake warehouses
- Ensure data security governance and cost management
- Guide automation for testing metadata capture and lineage
- Lead schema architecture and performance optimization decisions
- Mentor and develop data engineers and administrators
- Oversee ingestion transformation and integration of healthcare datasets
- Provide architectural insight for roadmap planning
- Provide technical leadership across teams
- Troubleshoot high complexity data platform issues
- Tune performance and optimize workloads
Perks/Benefits
- 401k match
- Disability insurance
- Health benefits
- Life insurance
- Paid Holidays
- Paid family leave
- Paid parental leave
- Paid time off
- Remote work flexibility
Skills/Tech-stack
AWS | Automation | Bash | Cloud Data | Cloud Data Architecture | Cortex AI | DDL | Data Architecture | Data Governance | Data Lineage | Data Modeling | Data Quality | Data Warehousing | Data integration | ELT | ETL | Enterprise Data | Enterprise Data Modeling | Glue | IAM | Lambda | Metadata Management | Powershell | PySpark | Python | S3 | SQL | Snowflake | Step Functions
Education
Related jobs
-
Lead Data Architect (Snowflake) USD 165K-195KACORD Data Model | Amazon S3 | Azure DevOps | CI/CD | CollibraSenior-level Full TimeNewport Beach, United States7h ago
-
Enterprise Data & AI Architect USD 140K-220KAI Agents | AI Governance | API Integration | Access Controls | Active DirectoryESOP ownership | Hybrid option | Remote work | Travel opportunitiesSenior-level Full TimePico Rivera, CA, US R16h ago
-
Principal Data Architect USD 123K-267KAI machine learning | Advanced Analytics | Amazon Web Services | Business Information | Business Information Models401k matching | Adoption Assistance | Birthday off | Career development and learning opportunities | Child care assistanceSenior-level Full TimeOakland, CA, United States19h ago
-
Reinsurance Data Engineer USD 150K-220KAWS Glue | Amazon Redshift | Amazon S3 | Azure Synapse | Azure Synapse AnalyticsSenior-level Full TimeBoston, MA22h ago
-
Cloud Computing | Data Architecture | Data Cleansing | Data Compliance | Data GovernanceHybrid work locationSenior-level Full TimeAustin, TX R22h ago
-
Data Architect USD 125K-191KApache Airflow | Apache Iceberg | BigQuery | Cloud Composer | Cloud Dataflow401k | Casual dress code | Company events | Employee discount | Hybrid scheduleSenior-level Full TimePittsburgh, PA, United States R1d ago
-
Data Architect USD 150K-210KADLS | Analytics Platforms | Azure Data | Azure Data Factory | Data ArchitectureSenior-level Full TimeGreater Milwaukee area1d ago
-
Lead Data Architect USD 173K-279KAWS EMR | AWS Redshift | AWS S3 | Apache Flink | Apache SparkCareer Development Programs | Inclusive workplace | MentorshipSenior-level Full TimeChicago, Illinois, USA R1d ago
-
Azure Data | Azure Data Factory | Data Factory | Microsoft Azure | Microsoft FabricRemote workSenior-level Full TimeNew York, NY, USA1d ago
-
AWS | Agile | Azure | Capacity Planning | Cause analysisFlexible cross functional collaboration | Office first 4 days a week | Travel as neededSenior-level Full TimeReading, PA, United States1d ago
-
Data Enterprise Architect - Banking USD 150K-220KABAC | API Design | Airflow | Amazon Kinesis | Apache SparkSenior-level Full TimeEdison, New Jersey, United States1d ago
-
Customer Success & GenAI Enablement Lead USD 140K-180KAnalytics | Customer Success | Data pipeline | Dollar Retention | Generative AIHealth and wellness packages | Open PTOSenior-level Full TimeNYC Metro1d ago
-
Database Architect USD 110K-150KBackup and Recovery | Cloud Databases | Database high availability | ELT | ETLSenior-level Contract Full TimeOkemos, MI / Farmington Hills, MI1d ago
-
Senior-level Full TimeSan Jose, California, United States, United …1d ago
-
Principal AI Architect - Agentic Verticals USD 206K-451KC++ | Computer Vision | Hugging Face | Java | LangchainHybrid workSenior-level Full TimeSeattle (WA), United States1d ago
-
Director - Data Engineering USD 162K-215KAWS | Azure | Bash | Cloud Data | Cloud data warehousingAnnual discretionary bonus | Flexible time off | Healthcare | Hybrid work model | Leave benefitsExecutive-level Full TimeAT8 - 725 Ponce de Leon … R1d ago
-
Corporate Data Architect USD 36K-36KCloud Computing | Data Architecture | Data Governance | Data Modeling | Data strategyComprehensive benefits package | Discounts directory | On-demand pay program | Optional identity theft protection | Retirement optionsSenior-level Full TimeSITE - Corewell Health Place - …1d ago
-
Oracle AI Lead USD 82K-233KAI Agent Studio | AI Agents | AI Services | Agent Studio | Cloud infrastructureCompany-Paid Holidays | Dental insurance | Disability insurance | Employee assistance program | Life insuranceSenior-level Full TimeNashville, TN, US1d ago
-
Principal Data Architect USD 188K-202KAPI Management | Advanced Analytics | Apache Kafka | Azure Event | Azure Event HubsCompany-Paid Holidays | Employee assistance programs | Life and disability insurance | Medical, dental, and vision coverage | Paid time offSenior-level Full TimeBerwyn, PA, US1d ago
-
Lead Data Engineer USD 93K-224KAnthos | App Engine | Automation | BigQuery | CI/CDCompany-Paid Holidays | Employee assistance program | Life and disability insurance | Medical, dental, and vision coverage | Paid time offSenior-level Full TimeNashville, TN, US1d ago
-
Principal AI Platform Architect USD 185K-220KAPI Development | Access Management | Agent Orchestration | Batch Processing | Cloud ArchitectureSenior-level Full TimeFoster City, United States1d ago
-
AI Solutions Architect USD 133K-188KAI Governance | AI Safety | API Integration | Artificial Intelligence | Automation401k match | Certification opportunities | Dental insurance | Employee recognition programs | Employee referral programsSenior-level Full TimeCleveland Office, United States1d ago
-
IT AI Solution Architect USD 156K-243KAPI Gateway | AWS | AWS CloudFormation | AWS Lambda | Agile ScrumFlexible time zone alignment | Remote work | Stakeholder collaborationSenior-level Full TimeDallas-Fort Worth Metropolitan Area, TX, USA, …1d ago
-
Artificial Intelligence | Audio generation | Data Curation | Data Modeling | Data QualitySenior-level Full TimeSan Jose, United States R1d ago
-
IT Data Architect USD 135K-200KAWS | AWS Aurora | AWS Database | AWS Database Migration Service | AWS database migrationFlexible time zone alignment | Remote workSenior-level Full TimeDallas-Fort Worth Metropolitan Area, TX, USA, …1d ago