This resource will join the Advanced Reporting Capabilities team as an experienced Database administrator. You will play a critical role for identifying performing core database administration for a snowflake environment, build automation to optimize the environment, and maintain and leverage existing pipelines to ensure data accuracy. This is a high performing team that focuses on evolving strategic operational reporting that focuses on data and analytics with real time capabilities in a cloud environment. You will work on critical projects ensuring all data is accurate and up to date in Snowflake for use in various website and reporting tools. All of the products are high profile with a wide scope in the organization. Because of this, you will interact with operation teams, engineering groups, products teams, and business partners as well as senior leadership and global stakeholders.
* Minimum 2 years relevant experience working with Snowflake.
* Develop, build & maintain mission critical centralized data platform using Snowflake.
* Diagnose and troubleshoot Snowflake database errors.
* Implement Snowflake user /query log analysis and alerts.
* Demonstrated proficiency of index design, query plan optimization and analysis required.
* User security auditing.
* Create Snowflake utilization and capacity plan.
* Tune the database to improve Snowflake queries.
* Experience using Perspectium or similar data integration and sync tools.
* Aptitude to independently learn new technologies.
* Passion for delivering the best quality product regardless of project scope.
* Excellent problem-solving skills.
* Conduct on call duties as needed for urgent matters.
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.