Leads the architecture and engineering of scalable Snowflake data platforms, including ETL pipelines, data warehouses, streaming ingestion, stored procedures, performance optimization, security, and automation. Troubleshoots platform issues, collaborates on enterprise data initiatives, and mentors junior architects and engineers. The role requires deep Snowflake, SQL, Python, data modeling, and modern data platform expertise, with preferred experience in cloud platforms, orchestration tools, governance, and real-time analytics.
Principal Architect
Primary Skills
- DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
- Snowflake Engineering: Principal Data Architect
Job requirements
- Design and architect scalable, secure, and high-performance Snowflake data solutions to drive enterprise data initiatives.
- Develop and implement robust ETL pipelines using Snowflake Streams, Python, and SQL to enable efficient data ingestion and transformation.
- Optimize Snowflake environments for performance, cost, and reliability by leveraging features such as Time Travel, Fail Safe, and Snowpipe.
- Lead the modeling and structuring of complex Snowflake data warehouses, ensuring data integrity, accessibility, and scalability.
- Configure and manage SnowSQL, stored procedures, and advanced SQL scripts to automate data processing and analytics workflows.
- Collaborate with cross-functional teams to define data platform requirements and deliver modern data solutions aligned with business objectives.
- Troubleshoot and resolve architectural and operational issues within Snowflake and related data platforms, ensuring minimal downtime.
- Mentor and guide junior architects and engineers on best practices in Snowflake engineering and data platform fundamentals.
- Expertise in Snowflake architecture and engineering
- Advanced proficiency in SQL
- Strong experience with Python for data processing and automation
- Deep understanding of ETL pipeline development
- Hands-on experience with Snowflake Streams for real-time data ingestion
- Proficiency in Time Travel and Fail Safe features within Snowflake
- Implementation and management of Snowpipe for automated data loading
- Skilled in SnowSQL for scripting and data management
- Experience in Snowflake-specific data modeling and warehouse design
- Expertise in developing and managing Snowflake stored procedures
- Experience integrating Snowflake with cloud platforms such as AWS or Azure
- Expertise in advanced data security and governance practices
- Knowledge of performance tuning and optimization for large-scale Snowflake workloads
- Familiarity with emerging data engineering technologies and frameworks
- Experience with orchestration tools for automating data pipelines (e.g., Apache Airflow, dbt)
- Hands-on experience with real-time analytics and streaming data solutions
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline
- Snowflake SnowPro Advanced Architect certification or equivalent
- Certification in data warehousing or cloud data platform architecture (e.g., AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer Associate)
15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platforms
Key Responsibilities:
Required Skills:
Preferred Skills:
Desired Qualifications:
Similar Jobs
Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Leads client-facing regulatory consulting projects from initiation through completion, coordinating medical device manufacturers, consultants, sales teams, and internal stakeholders. Manages schedules, budgets, milestones, billing, scope changes, risks, communications, and deliverables. Builds client relationships, improves internal processes, tracks project health, and drives cross-functional initiatives to successful completion.
Top Skills:
ExcelMS OfficeMicrosoft TeamsOnenoteOutlookPsaSalesforceSharepointWord
Information Technology • Software • Financial Services • Big Data Analytics
As a Quantitative Research Engineer, design, develop, and implement software for automated trading systems using advanced statistical techniques. Collaborate with researchers and prioritize business needs.
Top Skills:
C++Distributed ComputingMachine LearningNatural Language ProcessingNetworkingPlatform DevelopmentPythonRSystem DesignWeb Development
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handles inbound calls and warm leads, consults customers on property and casualty insurance needs, recommends appropriate coverage, and converts prospects into policyholders. The role includes paid licensing and training, customer relationship management, sales closing, and representing the Liberty Mutual brand. Employees must work a designated weekday and weekend schedule and maintain a compliant home office with wired high-speed internet.
Top Skills:
Cable InternetDsl InternetFiber InternetPc
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
