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
-
Data Architecture SME USD 95K-109KBPMN | DODAF | Data Warehousing | Database Architecture | Dimensional Modeling401k plan with company matching | Bereavement | Dental and vision care | Employee assistance program | Employee discount programSenior-level Full TimeScott Air Force Base, IL, United …6h ago
-
BigQuery | Curriculum Development | Data Governance | Data Lakehouse | Data ModelingAsynchronous hiring process | Part-time hoursSenior-level Part TimeBoston, US8h ago
-
Technical Architect – AI, ML & Generative AI USD 142K-240KAWS Bedrock | AWS SageMaker | Agentic AI | Apache Spark | Artificial Intelligence401k | Critical Illness Accident Hospital Indemnity Identity Theft Protection | Dental plans | Life and Accidental Death and Dismemberment | Long-term disabilitySenior-level Full TimeFrisco, United States9h ago
-
Solution Architect (AI & Data Applications) USD 180K-247KAutogen | CI/CD | Databricks | Docker | FastAPIMentoring system | Professional development | Supportive work environmentSenior-level Full TimeJersey City, NJ, United States13h ago
-
*Data Architecture and Modelling - 6252888 USD 100K-108KAI strategy | Agile Scrum | Data Architecture | Data Modeling | Data access401k plan | Dental insurance | Long-term disability | Medical insurance | Paid time offSenior-level Full TimeDallas, 5205 N OConnor Las Colinas, …22h ago
-
Principal Data Architect USD 160K-160KApache Spark | Azure | CI/CD | Data Governance | Data Lineage401k match | Employee wellness programs | Life insurance | Medical/Dental/Vision | Paid time offSenior-level Full TimeHouston, TX22h ago
-
Data Domain Architect Lead USD 171K-205KArtificial Intelligence | Business Intelligence | Data Annotation | Data Modeling | Data ProcessingBackup childcare | Financial coaching | Health care coverage | Mental health support | On Site Health Wellness CentersSenior-level Full TimeWilmington, DE, United States1d ago
-
Solutions Architect, Strategic Retail - Central USD 180K-247KAccount Management | Apache Spark | Artificial Intelligence | Big Data | Cloud ComputingSenior-level Full TimeUnited States1d ago
-
Azure Data | Azure Data Factory | Azure Synapse | Azure Synapse Analytics | CI/CDDental insurance | Health insurance | Professional development and training | Remote work flexibility | Retirement benefitsSenior-level Full TimeIdaho R1d ago
-
AI Foundry | APIs | Access Management | Azure AI | Azure AI FoundryEast Coast location flexibility | NYC based candidate salary transparency | Remote work opportunityMid-level Full TimeNew York City, NY, United States1d ago
-
Senior-level ContractATLANTA, GA1d ago
-
Senior-level Full TimeDallas, Texas, United States1d ago
-
Practice Lead, Data & Analytics USD 155K-200KAWS | Agile | Amazon Redshift | Azure | Azure Data401k matching | Flexible vacation | Medical/Dental/Vision | Training SponsorshipSenior-level Full TimeLos Angeles, CA1d ago
-
Senior Solutions Architect, Generative AI USD 184K-287KC# | C++ | Deep learning | Distributed Computing | GPUComprehensive benefits | EquitySenior-level Full TimeUS, CA, Santa Clara, United States1d ago
-
Technical Delivery Lead USD 94K-164KAgentic AI | Apache Kafka | CI/CD | Cloud Native | Cloud Native ArchitectureBonus eligibility tied to performance | Comprehensive total rewards packageSenior-level Full TimeDayton WFH, United States R1d ago
-
Data and Analytics Technical Lead USD 142K-189KAPI Gateway | AWS | Business Intelligence | CloudFormation | Code Management401k match | Employee discounts | Floating holidays | Health coverage | Paid parental leaveSenior-level Full TimeCoppell - 0760, United States1d ago
-
Agentic AI Lead Solution Architect USD 150K-220KAdvanced Analytics | Agentic AI | Artificial Intelligence | Cloud Computing | Compliance401k retirement plan | Company holidays | Dental insurance | Disability insurance | Employee assistance programSenior-level Full TimeAtlanta, GA, US1d ago
-
AWS Cloud | By Design | CCPA | CDGC | Data ArchitectureCompany-Paid Holidays | Employee assistance program | Life and disability insurance | Medical, dental, and vision coverage | Paid time offSenior-level Full TimeAtlanta, GA, US1d ago
-
AWS | Artificial Intelligence | Cloud Computing | Data analytics | Foundation ModelsCareer growth resources | Mentorship | Work-life balanceSenior-level Full TimeSan Francisco, California, USA1d ago
-
Data Science Lead, Data Architect USD 152K-244KAgentic AI | Anomaly Detection | CRM Integration | Contract analytics | Data EngineeringAnnual bonus | Discretionary LTI bonus | Reimbursement of phone use | Reimbursement of vehicle useSenior-level Full TimeUSA NJ - Franklin Lakes, United …1d ago
-
Data Architect Senior - Retail Architecture USD 80K-194KApache Avro | Apache Kafka | Business Intelligence | Data Architecture | Data Modeling401k match | Dental insurance | Educational assistance | Health insurance | Life insuranceSenior-level Full TimeTwo PNC Plaza (PA374), United States1d ago
-
Vice President - Business, Data Architect - Transaction Banking Product, TD Securities USD 108K-225KAI/ML | Access Control | Analytical Zones | Analytics | Cloud ComputingCareer development | Health and well-being benefits | Mentoring programs | Online learning platform | Paid time offSenior-level Full Time101 North Tryon Street, Charlotte, North …1d ago
-
Embedded Software Engineering Specialist USD 128K-192KBash | C# | C++ | CI/CD | Debugging401k matching | Adoption benefits | Career development | Dental insurance | Disability benefitsSenior-level Full TimeMossville, Illinois, United States1d ago
-
Data & Semantic Model Architect USD 140K-199KAPIs | Allotrope | CDISC | Common Data Model | Data GovernanceSenior-level Full TimeUnited States - Remote R1d ago
-
Senior-level Full TimeArlington - 1801 S Bell (INDG), …1d ago