Sr. DBE

What You'll Do

Job Title: Sr Database Engineer (Snowflake Admin)

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.

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

• 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.
  

What You'll Need to be Successful

Additional Skills

• 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.
• Working Conditions:
• This position may require occasional after-hours or weekend work for maintenance and upgrades.
• Perform Oncall Duties
• Flexibility to work remotely or on-site as required.
• Good Team Player
  

About The Team

The RELE Data Engineers are based in Pune, Brazil, Seattle 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/Qlik, and Snowflake is also set to expand into other Avalara SIG products for all data compliance and reporting aspects.

How We'll Take Care of You

Total Rewards

In addition to a great compensation package, paid time off, and paid parental leave, many Avalara employees are eligible for bonuses.

Health & Wellness

Benefits vary by location but generally include private medical, life, and disability insurance.

Inclusive culture and diversity

Avalara strongly supports diversity, equity, and inclusion, and is committed to integrating them into our business practices and our organizational culture. We also have a total of 8 employee-run resource groups, each with senior leadership and exec sponsorship.

Flexible hybrid working

We support hybrid work and flexible schedules for our employees.

Learn more about our benefits by region here: https://careers.avalara.com/

About 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.