Job Closed

This listing is no longer active.

General Dynamics logo
General Dynamics

General Dynamics is a global aerospace and defense company offering products designed to provide safety and security to people around the world. In the past, Ge

Lead Snowflake Data Warehouse Architect

Location

United States

Posted

50 days ago

Salary

$170K - $230K / year

Seniority

Senior

Bachelor Degree10 yrs expEnglishAWSCloudETLPySparkPythonSQL

Job Description

Lead Snowflake Data Warehouse Architect

General Dynamics

• Own the opportunity as a Snowflake Data Warehouse Architect and help ensure the mission is never interrupted. • Guide the design, architecture, and technical strategy for our enterprise cloud data environment. • Shape the architecture supporting complex data ecosystems. • Provide leadership across engineering workstreams. • Ensure the platform evolves in a scalable, secure, and high‑performing direction. • Architect enterprise‑level Snowflake data warehouse solutions. • Provide technical leadership across multiple teams. • Define data architecture patterns, standards, and best practices. • Lead design decisions related to schema architecture, data distribution, performance optimization, security, governance, and cost management in Snowflake. • Collaborate with Program Management, Agile PMO, ETL development, DevSecOps, DBA, user support, and analytics teams. • Oversee ingestion, transformation, and integration of complex healthcare datasets. • Work hands-on in Snowflake, including DDL design, warehouse configuration, performance tuning, and workload optimization. • Leverage and advise on usage of related AWS data services.

Job Requirements

  • BS/MS degree with 10+ years of general experience in information systems and 8+ years of specialized data warehouse related experience
  • 6+ years of experience in cloud data architecture, data warehousing, or enterprise data modeling
  • 6+ years Snowflake experience required
  • 2+ years direct CMS experience required
  • Extensive hands-on Snowflake experience, with strong skills in implementing logical and physical models
  • Proven leadership in large-scale cloud data environments, preferably within AWS
  • Deep experience with ETL/ELT frameworks and model‑driven engineering approaches
  • Proficiency in SQL, data transformation design, and performance optimization
  • Experience working with cloud‑native architectures, modern data integration patterns and AI solution development
  • Strong expertise in automation and scripting (e.g., Bash, PowerShell, Python, PySpark)
  • Excellent communication skills with demonstrated experience delivering presentations to diverse audiences at various levels of an organization
  • Experience managing, mentoring, and developing engineering staff.

Benefits

  • Full-flex work week.
  • 401K with company match.
  • Customizable health benefits packages.
  • Collaborative teams of highly motivated critical thinkers and innovators.
  • Internal mobility team dedicated to helping you own your career.
  • Rewards program for high-performing employees.

Related Categories

Related Job Pages

More Data Engineer Jobs

Full TimeRemoteTeam 10,001+H1B Sponsor

• Define and evolve cloud-native data architecture on AWS; • Design data models optimized for APIs and consumption by AI; • Lead the migration of historical data from the mainframe; • Ensure data consistency, integrity, and traceability; • Work with large volumes and complex historical data; • Build and maintain ingestion and transformation pipelines; • Integrate systems (PeopleSoft, mainframe, and RDS); • Optimize queries in PostgreSQL; • Implement partitioning, indexing, and caching (Redis) strategies; • Reduce latency for frequent queries; • Ensure compliance with LGPD (Brazilian General Data Protection Law) and retention policies; • Implement governance: access control, masking, anonymization, auditing, and lineage; • Structure data for consumption by LLMs and conversational agents; • Support the construction of semantic layers; • Implement quality validations and monitoring for pipelines.

Brazil
Full TimeRemoteTeam 201-500

Hello and thank you for your interest! We're looking for folks nationwide who are great at data entry and typing. We offer a flexible work from home remote position that allows you to stay home with the family! The pay range is flexible from $16/ph to $30/ph DOE and level of experience. You'll meet these requirements to work from home remotely • Stable Internet connection • Work can be done using the following: Phone device, laptap or computer • Must be able to type accurately with a minimum speed of 30 words per minute • Able to focus on tasks without being distracted • Must be resident of the US • Not afraid of emailing clients as needed We're looking for folks who we can depend on who can work from home remotely without distraction and are go-getters. Pay range from 16 to 30 hourly depending on the role, level of experience and proven ability to work from home at the same level as from an office. Data entry clerks come from all different backgrounds including, data entry, telemarketing, customer service, sales, clerical, secretary, administrative assistant, warehouse, inventory, receptionist, call center, part-time, retail fields & more • Must be 16 year of age or older • Must be proficient with basic PC skills • Must have an internet connection • Basic english written language • Basic english spoken language Thank you for your interest.

United States
$16 - $30 / hour
Sanford Health logo

Senior Data Modeler

Sanford Health

Dedicated to the work of health and healing.

Data Engineer50 days ago
Full TimeRemoteTeam 10,001+Since 1894H1B Sponsor

Sanford Health, the largest rural health system in the United States, is dedicated to transforming the health care experience and providing access to world-class health care in America’s heartland. Work Shift: 8 Hours - Day Shifts (United States of America) Scheduled Weekly Hours: 40 Compensation: Salary Range: $40.00 - $66.00 Union Position: No Department Details Summary The Senior Data Modeler is responsible for architecting, governing, and advancing the enterprise data modeling framework to ensure data structures support organizational strategy, scalability, and analytic maturity. Provides expert-level leadership across conceptual, logical, and physical modeling and ensures data assets are accurate, consistent, reusable, and aligned with enterprise architecture standards. Champions data modeling best practices, improves enterprise data quality, and shapes the long-term direction of data architecture. Job Description The Senior Data Modeler leads collaboration with data architects, data engineers, and business stakeholders to translate complex business rules and analytical requirements into robust conceptual, logical, and physical data models. Designs and governs high-quality data structures using advanced normalization, dimensional modeling, star schema design, and domain-driven design. Produces and maintains detailed Entity–Relationship Diagrams (ERDs) to ensure clarity, consistency, and alignment across data ecosystems. Provides authoritative oversight and approval for enterprise-wide data models, ensuring compliance with architectural standards, data governance policies, and Technology Solutions (TS) and Architecture COE principles. Will establish, refine, and enforce modeling standards, patterns, and best practices used across the organization to include comprehensive data dictionaries, metadata and data flow documentation. Ensures data models adhere to healthcare security and regulatory requirements (e.g. HIPAA, GDPR, etc.). Design schemas for data lakes and data warehouses (star, snowflake, normalized, denormalized). Leads cross-functional technical discussions, serving as a mediator and subject matter expert to ensure data modeling needs are accurately understood and implemented. Contributes to the evolution of healthcare-based enterprise data models, ensuring interoperability, scalability, and alignment with organizational goals. Will collaborate closely with principal data architects to influence data architecture decisions and strategic direction. Strengthens data modeling discipline across applications and business areas, ensuring high-quality data capture and data pipeline alignment. Must anticipate and identify opportunities for optimization, modernization, and innovation in data modeling and propose enhancements to align with industry advancements. Partners with data engineers, data architects and data analysts to resolve integration challenges. Will mentor and develop data modelers, engineers, and analysts, promoting modeling excellence and knowledge sharing across teams. Responsible for designing, building, and optimizing data models for platforms such as Snowflake, Redshift, and similar cloud-based database systems, ensuring performance, scalability, and architectural integrity. Qualifications Bachelor’s degree required in computer science, management information systems, or related field. Minimum of five years of experience in data modeling, database design and development, systems or applications development, or related field. Must be proficient in data modeling tools such as Erwin, ER/Studio, PowerDesigner, or other similar tools. Proficiency with SQL, strong understanding of data pipeline and data warehousing principles and concepts is required. Strong communication and documentation skills, with the ability to explain complex concepts to both technical and non-technical stakeholders. Strong problem-solving skills and attention to detail. Experience in data modeling and design within the health insurance or health care industry is preferred. Experience with cloud data platforms (e.g., Azure, AWS, or Google Cloud) and healthcare analytics platforms (e.g., Epic Caboodle). Understanding of data lake and lakehouse architectures. Experience with data governance, data quality, and MDM principles. Familiarity with BI/analytics tools and data science needs. Sanford is an EEO/AA Employer M/F/Disability/Vet. If you are an individual with a disability and would like to request an accommodation for help with your online application, please call 1-877-949-5678 or send an email to talent@sanfordhealth.org.

United States
$40 - $66 / hour
Live Nation Entertainment logo

Senior Data Engineer

Live Nation Entertainment

A Fortune 500 company lauded for innovative business practices by Fast Company magazine, Live Nation Entertainment is a global leader in live entertainment and

Data Engineer50 days ago

• Design, develop, and maintain scalable ETL/ELT pipelines using Databricks, PySpark, Python, and SQL • Optimize data workflows and SQL/Spark queries for performance, cost efficiency, and reliability • Contribute to the design of our enterprise Data Lake and curated data assets • Build robust ingestion frameworks, transformation logic, and reusable data engineering components • Support data migrations and modernization efforts from legacy systems to cloud-based platforms • Use AI coding copilots (Databricks Assistant, GitHub Copilot, SQL copilots) to accelerate development, code review, test creation, and documentation • Automate repetitive tasks (schema evolution, config generation, logging templates, test data creation) with generative AI tools • Leverage AI to auto-detect pipeline anomalies, data drift, quality issues, and performance bottlenecks • Incorporate AI-assisted query optimization tools to improve Spark & SQL performance • Collaborate cross-functionally with Product, data consumers to deliver high-quality data solutions • Participate in Agile ceremonies & contribute to sprint planning & technical design discussions • Mentor junior data engineers, promote best practices in AI-assisted data engineering • Ensure strong documentation, standards adoption, & continuous improvement across the team.

California
$152K - $190K / year