Finance Systems Analyst

---

Job description

Finance Systems Analyst

Coppell, TX

Hybrid- 2 to 3 days week on site in Coppel TX

6 Months

About the Job:

The Finance Systems Analyst will assist with implementing and updating finance systems for the Accounting, Treasury, and FP&A teams, focusing on optimizing SQL queries, automating reports, and migrating data to new systems. They will collaborate with Treasury to integrate asset data into Empyrean and work with FP&A to define reporting metrics and re-engineer databases using new ERP system data. Additionally, they will perform data analysis, create reports, ensure data accuracy, and collaborate with cross-functional teams to align business needs with data models and pipeline logic. This position will report directly to Finance Application Manager.

Major Accountabilities

The Finance Systems Analyst will assist in implementing and updating existing Finance Systems used by the Accounting, Treasury & FP&A Teams.

Collaboration with Treasury Team:

Understand, extract and transform asset information from Asset Financing Software for integration into Empyrean (ALM)

Develop and optimize SQL queries to extract and manipulate data from databases.

Play a key role in migrating current data sets used by Finance System to new database set for efficient data management and modeling

Reengineer SQL database to utilize new ERP system data and automate the Securitization report requirements.

Collaboration with Accounting and Financial Planning Analysis (FP&A) Team:

Work with FP&A team to define report metrics for accurate data reporting

Re-engineer SQL Database (views, stored procedures, tables etc.) using new ERP system.

Design, develop, and test processes using SQL and Oracle EPM & ARCS.

Create ad-hoc queries, reports and provide ongoing analytical support.

Perform various data analytics in SQL and MS Excel using models or industry accepted tools.

Perform data validation and quality assurance to ensure accuracy and reliability of reports.

Partner with cross-functional teams to translate business needs into the Semantic Layer and data models

Work closely with Data Services team to optimize data pipeline logic for Finance Applications and reporting needs

Qualifications

Bachelors Degree in Computer Science, IT, MIS, Engineering, or related fields.

5+ years of experience as a SQL Developer, Data Analyst or similar role.

Advanced SQL skills, Power BI, Tableau, Python. SQL Development Proficiency: Proficient in SQL development, including writing and troubleshooting SQL code and scripts (stored procedures, functions, tables, views, triggers, indexes, constraints).

Advance Microsoft Office Suite (excel, powerpoint, word, etc) skills.

Experience in Empyrean (ALM) a plus.

Experience in Securitization (ABS, ABL, ABCP) a plus.

Experience in banking/financial services/capital markets industry a plus.

Experience in SAP, Oracle EPM, Odessa, Wholesale Intelligence or any Asset Financing Software a plus

<!– job description page –>