Ekman Associates, Inc. ยท 15 hours ago
Data Analyst (Finance/Accounting)
United States
Full-time
Remote
Senior Level
7+ years expEkman Associates is a management consulting firm specializing in business, digital, and technology strategy. They are seeking a highly analytical Data Analyst with experience in data extraction and accounting to analyze financial data, develop reports, and collaborate with teams to provide actionable insights.
Business DevelopmentConsultingDigital SignageDirect MarketingManagement Consulting
Responsibilities
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
Clean and standardize extracted data to ensure accuracy and consistency
Perform data validation checks to identify and address data quality issues
Transform data into a usable format for analysis
Conduct descriptive and statistical analysis on financial data to identify trends, patterns, and anomalies
Utilize advanced analytical techniques like regression analysis, forecasting, and variance analysis
Create comprehensive financial/accounting reports and dashboards to communicate key insights to stakeholders
Utilize data visualization tools to present findings in a clear and impactful manner
Work closely with accounting, finance, and business operations teams to identify data needs and interpret analysis results
Collaborate on projects to leverage data insights for business improvement
Qualification
Required
Bachelor's in computer science, Information Technology
7+ Years SQL, Excel, ETL, Data Analysis
Experience with Order to Cash, Billing, Contract Activation, Cash Process, and Business Process (OTC)
Experience with Data Quality
Exceptional analytical, conceptual, and problem-solving
Strong proficiency in SQL for data extraction and manipulation
Experience with data analysis tools (e.g., Tableau, Power BI, Excel)
Understanding of accounting principles and financial/accounting reporting standards (invoicing, payments, revenue recognition)
Statistical analysis skills and ability to interpret data
Expertise in MS Excel
Expertise in SQL and relational databases
Strong communication (verbal and written) and interpersonal skills to translate key insights from complex analyses into actionable business insights
Proven ability of looking at solutions in unconventional ways- seeing opportunities to innovate and leading the way
Company
Ekman Associates, Inc.
Ekman Associates is a woman-owned (WBENC Certified) consulting firm that specializes in developing business, digital, and technology strategy, delivering solutions, and addressing human resource demands.
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Tom Ekman
Chief Financial Officer
Company data provided by crunchbase