Technical Data Analyst - Azure Databricks

Job Description :

We are looking for a highly skilled Technical Data Analyst to join our team and contribute to the creation of a single source of truth for our direct-to-consumer accounting and financial data warehouse.

The ideal candidate should have a strong background in data analysis, SQL, and data transformation, along with experience in financial data warehousing and reporting.

In this role, you will collaborate closely with finance and accounting teams to gather requirements, build dashboards, and transform data to support month-end accounting, tax reporting, and financial forecasting.

The financial data warehouse is currently established in Snowflake and will be transitioned to Databricks.

Your responsibilities will include migrating reporting and transformation processes to Databricks while ensuring the accuracy and consistency of the data throughout the transition.

Key Responsibilities :

Data Analysis & Reporting :

• Develop and maintain month-end accounting and tax dashboards utilizing SQL and Snowsight in Snowflake.
• Shift reporting processes to Databricks, creating dashboards and reports to aid finance and accounting teams.
• Collect requirements from finance and accounting stakeholders to design and provide actionable Transformation & Aggregation :
• Create and implement data transformation pipelines in Databricks to aggregate financial data and generate balance sheet look-forward views.
• Guarantee data accuracy and consistency during the migration from Snowflake to Databricks.
• Collaborate with the data engineering team to enhance data ingestion and transformation Integration & ERP Collaboration :
• Assist in integrating financial data from the data warehouse into NetSuite ERP by ensuring proper data

transformation and validation.

(ref : hirist.tech)