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

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

ALERT: HashiCorp has received reports of scams where individuals purporting to represent HashiCorp conduct bogus “employment interviews” via email or text, and then request payment as a condition for receiving an offer of employment. HashiCorp and its subsidiaries do not conduct interviews by email or text, and will never request payment as a condition for applying for a position or receiving an offer of employment.  These scam operators may also ask for your personal information (name, address, birthdate, social security number, etc.), which you should not provide to them.  If you have been the target of such a scam, you should report it to the U.S. Federal Trade Commission (see this FTC posting for further details: https://www.consumer.ftc.gov/articles/job-scams) the office of your state Attorney General, or the government agency responsible for investigating matters such as this where you reside.