O que você fará
Our Snowflake datalake, the data pipeline and ETL platforms are a critical component of compliance, reporting, counting and billing across Avalara's products. These applications need to provide not only 100% uptime but absolute accuracy of document recording and storage for Avatax, Returns, EU VAT, ORL , Comms etc. The Cloud Data Operations engineers are based in Seattle , Pune , Brazil and EMEA to cover 24x7 support and help engineering teams with troubleshooting, architectural design and performance issues proactively along with addressing new use cases and bugs. Our data pipelines including ETL using Wherescape or similar tools, Attunity, and Snowflake is also set to expand into other Avalara SIG products for all data compliance and reporting aspects.
We are seeking a highly skilled Snowflake Administrator to join our DBE team. The ideal candidate will have extensive experience in managing Snowflake Data Warehouse environments, including data security, performance tuning, and troubleshooting. The Snowflake Administrator will play a critical role in ensuring the optimal performance, security, and reliability of our data warehouse solutions.
O que precisa possuir para ser bem sucedido
Minimum Qualifications
- Education:
- Bachelor’s degree in Computer Science (4 Years) or Equivalent Engineering Degree.
- Experience:
- Proven experience as a Snowflake Administrator or in a similar role.
- Hands-on experience with Snowflake data warehousing solutions and architecture.
- Experience with database administration, performance tuning, and security best practices.
- Skills:
- Strong understanding of SQL and database concepts.
- Proficiency in scripting languages such as Python or Shell for automation.
- Familiarity with data integration and ETL tools.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills.
- Certifications:
- Snowflake certification(s) is a plus.
- Relevant certifications in data warehousing, cloud platforms, or database administration are desirable.
Key Responsibilities
Additional Skills
- Administration and Maintenance:
- Manage and maintain Snowflake environments, including user roles, permissions, and security.
- Monitor system performance and implement performance tuning measures.
- Perform regular database maintenance tasks such as backups, restores, and patch management.
- Data Management:
- Implement data governance policies and ensure data integrity and quality.
- Design and manage data loading processes, ensuring efficient data ingestion and transformation.
- Optimize data storage and retrieval to meet the needs of various business units.
- Security and Compliance:
- Implement and manage data security policies to ensure compliance with company policies and regulatory requirements.
- Conduct regular security audits and implement necessary measures to protect data from unauthorized access.
- Performance Monitoring and Optimization:
- Monitor system performance and proactively identify and resolve issues.
- Conduct performance tuning of queries and Snowflake objects to improve overall system efficiency.
- Collaboration and Support:
- Work closely with data architects, developers, and business analysts to understand data requirements and deliver effective solutions.
- Provide technical support and troubleshooting assistance to resolve Snowflake-related issues.
- Collaborate with cross-functional teams to support data initiatives and projects.
- Documentation and Reporting:
- Maintain detailed documentation of Snowflake configurations, processes, and procedures.
- Generate regular reports on system performance, security, and usage metrics.
- Good Knowledge on Postgres, Mongo Atlas, and other RDBMS.
- Write Iaac using Terraform, etc.
- Build CICD Pipeline and other Automation.
- Good knowledge on AWS and GCP Cloud.
Sobre a equipe
Discover what it means to work with some of the smartest people in the industry, and help solve some of the most challenging customer problems. We offer flexible hours, competitive salaries, the ability to work remote and the amazing experience of working with a multinational team of experts.
As a part of DB SRE team, you will troubleshoot and resolve products issues related to DB systems availability and performance. You will develop relationships with development teams, comprehend and fulfill their needs, and maintain their satisfaction through regular communication and engagement with their environments. You will perform technical work that requires planning and scheduling to ensure the best possible solution is delivered on time. You will react on incidents and provide solutions aiming at maintained environments’ improvements.
You will work in a fast paced environment where we are responsible for companies’ most critical systems. Customers count on us to keep their MongoDB, PostgreSQL , SQL server, Snowflake and MySQL DB’s databases running and we are vital to the success of their business.
Sobre a Avalara
We’re Avalara. We’re defining the relationship between tax and tech.
We’ve already built an industry-leading cloud compliance platform, processing nearly 40 billion customer API calls and over 5 million tax returns a year.
Last year, we became a billion-dollar business
, and our tribe expanded by a cool thousand people - there’s nearly 5,000 of us now. Our growth is real, and we’re not slowing down - not until we’ve achieved our mission - to be part of every transaction in the world.
We’re bright, innovative and disruptive, like the orange we love to wear. It captures our quirky spirit and optimistic mindset. It shows off the culture we’ve designed, that empowers our people to win. Ownership and achievement go hand in hand here. We instill passion in our people through the trust we place in them.
We’ve been different from day one. Join us, and your career will be too.
EEO Statement
We’re an Equal Opportunity Employer. Supporting diversity and inclusion is a cornerstone of our company — we don’t want people to fit into our culture, but to enrich it. All qualified candidates will receive consideration for employment without regard to race, color, creed, religion, age, gender, national orientation, disability, sexual orientation, US Veteran status, or any other factor protected by law. If you require any reasonable adjustments during the recruitment process, please let us know.
