Snowflake Architect

hace 23 horas

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 $

  • Data Architect for Advanced Data Solutions

    hace 4 días

    San Francisco, Heredia, Costa Rica Hangar Worldwide A tiempo completo

    Hangar Worldwide is seeking a highly skilled Data Architect to join our team as we continue to push the boundaries of data-driven innovation. We are looking for an experienced professional who can design and implement advanced data solutions, leveraging their expertise in data engineering to drive business growth and decision-making.The ideal candidate will...

  • Data Architect with Expertise in ETL and Data Warehousing

    hace 2 días

    San José, San José, Costa Rica Crg Solutions A tiempo completo

    About Crg SolutionsWe are a leading company providing innovative solutions for data-driven businesses. Our team is dedicated to delivering high-quality services that meet the evolving needs of our clients.Salary: $120,000 - $180,000 per annumJob DescriptionWe are seeking an experienced Data Architect to join our team. The successful candidate will be...

  • Digital Marketing Solutions Architect

    hace 5 días

    San Francisco, Heredia, Costa Rica Servicenow A tiempo completo

    **Overview**We are seeking a seasoned Digital Marketing Solutions Architect to join our team. As a key member of our DXP Data team, you will be responsible for conceptualizing and implementing full funnel tracking solutions for digital marketing activities.**Responsibilities**In this role, you will work closely with the DXP Data team and external vendors to...

  • Data Warehouse Architect

    hace 1 día

    San José, San José, Costa Rica Credito Real Usa Finance Llc A tiempo completo

    Company Overview">Credito Real Usa Finance Llc is a leading automobile loan provider seeking a highly skilled Data Warehouse Engineer to join our team in Costa Rica. Our company prides itself on providing excellent customer service and innovative solutions for our clients.">Job Description">We are looking for an experienced data warehouse engineer to design,...

  • Systems Architect, Software Development

    hace 4 días

    San José, San José, Costa Rica Western Union A tiempo completo

    About Western UnionWestern Union is a global leader in cross-border payments and money transfers. Our mission is to move money for better, connecting families, businesses, and financial institutions around the world.Our VisionWe envision a world where everyone has access to fast, reliable, and affordable financial services, empowering them to improve their...

  • Software Data Engineer Ii

    hace 17 horas

    San José, Costa Rica Imprivata A tiempo completo

    Come join a winning team! Here at Imprivata, you’ll see a dedicated group of professionals who care about improving healthcare. Our team thrives on collaboration and sharing ideas, whether in a cross-functional meeting or at one of our virtual team-building events. While we're diverse in our backgrounds and skills, we have much in common. A passion for...

  • Software Engineering Lead

    hace 4 días

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

    About EncoraWe are a global company providing innovation services and software engineering solutions. With over 27 years of experience in the market, we have established ourselves as a leader in Nearshore services.Job OverviewThis is a senior-level position that requires expertise in cloud data architecture. The successful candidate will be responsible for...

  • Senior Cloud Data Architect

    hace 4 días

    San Francisco, Heredia, Costa Rica Hakkoda A tiempo completo

    About HakkodaWe are a modern data consultancy that empowers organizations to unlock the full value of cloud-based data platforms. We provide expert consulting and managed services in data architecture, engineering, analytics, and science.Our team is distributed across North America, Latin America, and Europe, working together to deliver innovative solutions...

  • Cloud Data Architect

    hace 2 días

    San Francisco, Heredia, Costa Rica Hakkoda A tiempo completo

    About HakkodaHakkoda is a leading modern data consultancy empowering data-driven organizations to unlock the full potential of Snowflake's cloud platform. Our team provides consulting and managed services in data architecture, engineering, analytics, and data science, renowned for delivering expertise, ease of collaboration, and an exceptional work...

  • Advanced Confluent Cloud Solutions Architect

    hace 7 días

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

    About EncoraEncora is a global company that offers Software and Digital Engineering solutions, with more than 9000 professionals around the world. Our technology practices include Cloud Services, Product Engineering, Data Science and Engineering, Digital Experience, DevOps, Cybersecurity, Quality Engineering, among others.We are committed to delivering...

  • Data Engineer: Architect of Marketing Insights

    hace 4 días

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

    Splunk is dedicated to building a safer and more resilient digital world. Our unified security and observability platform enables the world's leading enterprises to keep their digital systems secure and reliable.As a career destination, Splunk stands out due to its exceptional people. We've won numerous awards for being an outstanding place to work, and it's...

  • Rpaengineer

    hace 24 horas

    San José, Costa Rica Convera A tiempo completo

    **Responsibilities**:**Duty/Responsibilities****Percentage of Time****Automation Development**- Collaborate with multi-disciplinary team of operation analysts, engineering, business analysts, product management & Infosec to assess and deliver new automation solutions that provide customer value- Identify gaps and constraints associated with business...