Data Analyst (Finance/Accounting) at Ekman Associates
Austin, Texas, United States — contract
Job Description
Title: Data Analyst (Financial/Accounting/SQL)
Location: Austin Texas or Dublin California (Hybrid)
Ekman Associates is a management consulting firm that specializes in developing business, digital, and technology strategy, delivering solutions, and addressing human resource demands.
SUMMARY:
Seeking a highly analytical Data Analyst with Data Extraction Analysis experience and with Accounting knowledge/experience to extract and analyze financial/accounting data from various systems (including Salesforce). The Data Analyst will be utilizing advanced data analysis techniques to identify trends, anomalies, exceptions, and provide actionable insights/solution to resolve the data descriptions. This role will be responsible for developing and maintaining data extraction processes, creating comprehensive reports, and collaborating with cross-functional teams to identify errors, interpret findings and provide solutions.
The Data Analyst is responsible for defining requirements and developing solutions. This involves the execution of data analysis, report and dashboard creation, and requirements assessment. Serving as a liaison between the business and the development team to translate business needs into useful data.
Key Skills:
Must speak English and Spanish Fluently
Must understand accounting principles and financial/accounting reporting standards (invoicing, payments, revenue recognition)
SQL Expertise
Responsibilities:
Data Extraction:
Collect and document business requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, user stories, use cases, scenarios, business-process, and workflow analysis.
Access and extract financial data from various accounting systems (ERP, CRM, etc.) using SQL queries and data extraction tools.
Develop and maintain data pipelines to automate data extraction processes.
Data Cleaning and Transformation:
Clean and standardize extracted data to ensure accuracy and consistency.
Perform data validation checks to identify and address da