SQL Analyst with Accounting

• SQL Advanced SQL Complex Joins CTEs (Common Table Expressions) Window Functions Stored Procedures Views Triggers Query Optimization Performance Tuning Indexing Accounting Knowledge General Ledger (GL) Accounts Payable (AP) Accounts Receivable (AR) Journal Entries Financial Statements Balance Sheet Income Statement Cash Flow Statement Bank Reconciliation Fixed Assets Month-End Close Year-End Close Cost Accounting Revenue Recognition Budgeting Forecasting Reporting & BI Microsoft Power BI Tableau SSRS (SQL Server Reporting Services) Microsoft Excel (Advanced) Pivot Tables Power Query Power Pivot Databases Microsoft SQL Server Oracle PostgreSQL MySQL Snowflake (Preferred) ERP Systems SAP Oracle ERP NetSuite Microsoft Dynamics 365 Workday Financials (Preferred) Programming (Preferred) Python VBA PowerShell., * Bachelor's degree in Accounting, Finance, Computer Science, Information Systems, or a related field.

*3 7 years of experience in SQL development, financial reporting, or data analysis. Strong understanding of accounting principles and financial reporting. *Experience working with ERP systems. Advanced SQL programming skills. Strong analytical and problem-solving abilities., * CPA (Preferred) CMA (Preferred) Microsoft SQL Certification Experience with cloud data platforms such as Snowflake or Azure SQL. Knowledge of ETL processes and data warehousing concepts.