Snowflake Architect

hace 3 semanas

San José, San José, Costa Rica Ex2 Outcoding A tiempo completo

We are seeking to hire an experienced Snowflake Architect to join our team.
If you're a passionate self-starter, this is the job for you
**Responsibilities**:

- Define, Design, build, support Source Extract to Staging Load processing using Azure Data Bricks.
- Define, Design, implement Security (all aspects: FW/Proxy/roles/column or row level security/etc.
): non-functional.
- Understand, model, monitor Cost allocation with Azure and SF (these are technical tasks): non-functional.
- Define, Design, build, support Tidal automation (for all runtime environments): non-functional.
- Define, Design, build, support Snowflake Transformations from Staging to Standard Data Model.
- Understand Operational Impact.
- Participate in Data Modelling exercises - translate logical to physical.
- Define Operational Monitoring/escalation framework: non-functional.
- Documentation within Confluence (our SharePoint Repository).
- Participate in project planning and estimating activities for technical aspects.
- Performance Tuning / Optimization of Snowflake resource utilization for strong cost.
- Design and implement effective Analytics solutions and models with Snowflake.
- Examine and identify Data Warehouse structural necessities by evaluating business requirements.
- Assess Data Warehouses to ensure they comply with internal and external regulations
- Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
- Recommend solutions to improve new and existing Data Warehouses.
- Offer support by responding to system problems in a timely manner.
- Guidance to developers in preparing functional/technical specs to define reporting requirement and ETL process.
- Develop complex data models in Snowflake.
- Tune Snowflake for performance and optimize utilization.
- Maintain deep understanding of complementary technologies and help organizations leverage Snowflake as part of their larger technology stack.
- Expertise in Snowflake - data modeling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts.
- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features.
- Expertise in deploying Snowflake features such as data sharing.
- Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python.
- Other duties as assigned.
**Qualifications**:

- Bachelor's Degree in in engineering, Data Science, AI, Mathematics, Statistics, Computer Science, Computer Engineering, or related discipline.
- 5+ years of professional technical experience, 5+ years of hands-on Big Data architecture.
- 5+ years of experience building highly scalable Big Data solutions using Hadoop, Spark or Lambda architecture.
- Experience with Snowflake administration.
- Experience with Snowflake transformations from Staging to Standard Data Model.
- Strong database migration strategy and analytics fundamentals including database migration and ETL accelerators.
- Experience working in cloud environments (AWS and/or Azure).
- Strong client-facing communication and facilitation skills.
- Location

San José, San Jose
- Department

Recruiting
- Employment Type

Full-Time
- Minimum Experience

Senior Manager/Supervisor
- Compensation

USD $

  • Snowflake Technical Lead

    hace 1 semana

    San José, San José, Costa Rica Ex2 Outcoding A tiempo completo

    Job Description:Snowflake ArchitectWe are seeking an experienced Snowflake Architect to spearhead our data strategy.The ideal candidate will have a deep understanding of Snowflake administration, with expertise in data modeling, ELT using Snowflake SQL, and implementing complex stored procedures. They should also be well-versed in standard DWH and ETL...

  • Lead Data Solutions Architect

    hace 4 días

    San José, San José, Costa Rica beBee Careers A tiempo completo

    Job DescriptionWe are seeking a highly experienced Lead Data Solutions Architect to join our team. As a Lead Data Solutions Architect, you will be responsible for designing and architecting data engineering solutions, leading teams, and mentoring other engineers.The ideal candidate will have experience in AWS and Snowflake or other cloud-based architectures,...

  • Cloud Data Engineer

    hace 1 semana

    San José, San José, Costa Rica Ex2 Outcoding A tiempo completo

    About the Role:Snowflake ArchitectThis is an exciting opportunity to join our team as a Snowflake Architect and contribute to the development of our Big Data architecture. As a key member of our data strategy group, you will play a critical role in designing and implementing scalable solutions that meet the needs of our clients. With a focus on innovation...

  • Cloud Data Architect

    hace 16 horas

    San José, San José, Costa Rica beBee Careers A tiempo completo

    Cloud Data Architect PositionWe are seeking a skilled Microsoft Database Engineer to join our team as a Cloud Data Architect.Your primary responsibility will be designing and building a cloud-based data warehouse, ensuring it is aligned with our future growth strategy.You will work closely with developers and BI staff to provide guidance on using the...

  • Big Data Architecture Specialist

    hace 1 semana

    San José, San José, Costa Rica Ex2 Outcoding A tiempo completo

    About Us:Ex2 Outcoding is seeking an experienced Snowflake Architect to join our team. As a key member of our data strategy group, you will play a critical role in designing and implementing our Big Data architecture. This is an exceptional opportunity to work on cutting-edge projects and collaborate with top talent in the industry. Our company culture...

  • Software Data Engineer II: Cloud-Native Data Architect

    hace 16 horas

    San José, San José, Costa Rica beBee Careers A tiempo completo

    Data Engineer Role OverviewYou will play a pivotal role in shaping the architecture, design, and development of a cloud-native, multitenant SaaS product as a data lake/warehouse for multiple lines of businesses.Cross-functional teams and stakeholders will rely on your expertise to develop resilient, dependable, and high-performing software.Key...

  • Sales Ops Bi Data Architect

    hace 1 semana

    San José, San José, Costa Rica Sysdig A tiempo completo

    As Sysdig scales its go-to-market strategy, we are looking for an ambitious, highly motivated **SQL Developer **to help build our organization.As a SQL dev, you will play a critical role in building the GTM Snowflake data architecture and infrastructure, from developing and maintaining data pipelines, designing and executing Snowflake data management...

  • Cloud Data Architect

    hace 6 días

    San José, San José, Costa Rica Kimberly-Clark A tiempo completo

    About Us">Kimberly-Clark is a global leader in the consumer goods industry, driven by a passion for innovation and a commitment to making a difference in the lives of people around the world. Our iconic brands, including Huggies, Kleenex, and Scott, are trusted by millions of people every day.We're dedicated to delivering better care for billions of people...

  • Business Intelligence Delivery Lead

    hace 6 días

    San José, San José, Costa Rica Pfizer A tiempo completo

    Job Overview:The Application Service Solutions Architect will be responsible for developing and managing analytical and operational business intelligence (BI) solutions that serve Pfizer's Research and Global Product Development organizations.Key Responsibilities:Develop and implement BI reporting and analytical solutions for Research, Development, Worldwide...

  • Senior Data Engineer

    hace 5 días

    San José, San José, Costa Rica beBee Careers A tiempo completo

    Job OverviewWe are looking for an experienced Senior Data Engineer to join our team. As a Senior Data Engineer, you will focus on expanding and optimizing our data pipeline architecture and enabling delivery of new data engineering products at increasing scale.The ideal candidate will have expertise in SQL, NoSQL databases, Snowflake data warehouses, and...