SQL Analyst with Accounting

EPSoft Technologies

Irving, TX, United States

about 1 month ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Microsoft Excel Data Analysis Information Systems Computer Programming Databases Extract Transform Load (ETL) Data Warehousing Database Development Python (Programming Language) PostgreSQL Microsoft Dynamics Microsoft SQL Server

+22 more

SQL Azure MySQL Netsuite Oracle (Applications) Performance Tuning Pivot Tables Powerpivot Windows PowerShell Query Optimization Cloud Services Standard Sql SQL Stored Procedures SQL Databases SQL Server Reporting Services Tableau (Software) Workday Financials Snowflake Indexer Powerquery Information Technology Vba Programming Language Sap Portal

Requirements

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.