Sr Data Analytics Manager

About HashiCorp

 HashiCorp is a fast-growing company that solves development, operations, and security challenges in infrastructure so organizations can focus on business-critical tasks. We build products to give organizations a consistent way to manage their move to cloud-based IT infrastructures for running their applications. Our products enable companies large and small to mix and match AWS, Microsoft Azure, Google Cloud, and other clouds as well as on-premises environments, easing their ability to deliver new applications for their business.

 We are looking for an experienced Sr. Data Analyst(Data Engineer) to be part of the Financial Planning & Analysis (FP&A) Digitization team.

Education

1. Bachelor's Degree in Engineering or Science
2. Snowflake certified professional 

Experience 

Overall experience of 7+ years as Data Analyst(Data Engineering). Minimum 3+ years experience on Snowflake.

What You Will Do

Maintenance/Support:

• Work closely with the Business Intelligence (BI) team to deliver processed and refined data for integration into BI systems from FP&A datamart on Snowflake.
• Collaborate on the development of dashboards, providing the necessary backend data structures to support insightful visualizations.
• Troubleshoot and optimize SQL queries for enhanced dashboard performance and responsiveness.
• Run refresh of tables and views to provide updated feed to other systems or tools like Tableau and Anaplan.
• Test updates to the data feeds to/from other systems.

Database Schema, table and views Management:

• Create/update schemas, tables and views on data mart as per business requirements.
• Manage schemas, tables and views to facilitate simplified and efficient data access for various analytical needs while ensuring data integrity.

SQL Query Development:

• Write and optimize stored procedures, ensuring seamless execution for efficient data retrieval and processing.
• Develop SQL queries incorporating table joins, subqueries, and aggregations to extract data from diverse datasets.
• Collaborate with cross-functional teams to understand data requirements and translate them into effective SQL queries.

Data Processing:

• Handle data from multiple schemas and tables, SQL transformations to clean, filter, and aggregate information as needed.
• Use data processing techniques to prepare datasets for further analysis and reporting.
• Ensure data consistency and accuracy through rigorous validation processes. #LI-Hybrid #LI-SG1