Technical Data Analyst

As a highly skilled Technical Data Analyst, you will be joining our team to help establish a single source of truth for our high-volume, direct-to-consumer accounting and financial data warehouse. Your solid background in data analysis, SQL, and data transformation, along with prior experience in financial data warehousing and reporting, will be crucial for this role. Your responsibilities will include collaborating closely with finance and accounting teams to gather requirements, develop dashboards, and transform data to facilitate month-end accounting, tax reporting, and financial forecasting. You will also be in charge of migrating reporting and transformation processes to Databricks while ensuring the accuracy and consistency of the data. Key Responsibilities: - Data Analysis & Reporting: - Construct and maintain month-end accounting and tax dashboards using SQL and Snowsight in Snowflake. - Shift reporting processes to Databricks, creating dashboards and reports to aid finance and accounting teams. - Engage with finance and accounting stakeholders to elicit requirements and provide actionable insights. - Data Transformation & Aggregation: - Develop and execute 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 processes. - Data Integration & ERP Collaboration: - Aid in integrating financial data from the data warehouse into NetSuite ERP by ensuring proper data transformation and validation. - Work with cross-functional teams to maintain seamless data flow between systems. - Data Ingestion & Tools: - Familiarize yourself with Fivetran for data ingestion purposes (expertise not mandatory, but familiarity is essential). - Address and resolve data-related issues in collaboration with the data engineering team. Additional Qualifications: - Minimum of 3 years of experience as a Data Analyst or in a similar role, preferably within a financial or accounting setting. - Proficiency in SQL and hands-on experience with Snowflake and Databricks. - Demonstrated ability to construct dashboards and reports for financial data, such as month-end close, tax reporting, and balance sheets. - Knowledge of Fivetran or similar data ingestion tools. - Understanding of financial data concepts like general ledger, journals, balance sheets, and income statements. - Experience with data transformation and aggregation in a cloud-based environment. - Effective communication skills for collaboration with finance and accounting teams. - Desirable: Familiarity with NetSuite ERP or comparable financial systems.,