Technical Data Analyst

Role & responsibilities

Job Description

consumer accounting and financial data warehouse

The financial data warehouse is currently built in **Snowflake** and will be migrated to **Databricks**. The candidate will be responsible for transitioning reporting and transformation processes to Databricks while ensuring data accuracy and consistency.

**Key Responsibilities:**
1. **Data Analysis & Reporting:** - Build and maintain **month-end accounting and tax dashboards** using SQL and Snowsight in Snowflake. - Transition reporting processes to **Databricks**, creating dashboards and reports to support finance and accounting teams. - Gather requirements from finance and accounting stakeholders to design and deliver actionable insights.

2. **Data Transformation & Aggregation:**
- Develop and implement data transformation pipelines in **Databricks** to aggregate financial data and create **balance sheet look-forward views**. - Ensure data accuracy and consistency during the migration from Snowflake to Databricks. - Collaborate with the data engineering team to optimize data ingestion and transformation processes.

3. **Data Integration & ERP Collaboration:**
- Support the integration of financial data from the data warehouse into **NetSuite ERP** by ensuring data is properly transformed and validated. - Work with cross-functional teams to ensure seamless data flow between systems.

4. **Data Ingestion & Tools:**
- Understand and work with **Fivetran** for data ingestion (no need to be an expert, but familiarity is required). - Troubleshoot and resolve data-related issues in collaboration with the data engineering team.

Additional Qualifications:
- 3+ years of experience as a **Data Analyst** or similar role, preferably in a financial or accounting context. - Strong proficiency in **SQL** and experience with **Snowflake** and **Databricks**. - Experience building dashboards and reports for financial data (e.g., month-end close, tax reporting, balance sheets). - Familiarity with **Fivetran** or similar data ingestion tools. - Understanding of financial data concepts (e.g., general ledger, journals, balance sheets, income statements). - Experience with data transformation and aggregation in a cloud-based environment. - Strong communication skills to collaborate with finance and accounting teams. - Nice-to-have: Experience with **NetSuite ERP** or similar financial systems.