Strategic Treasury & Financial Reporting Manager

Venteon; Detroit (MI); On-site; USD 95,000 - 130,000; Full time

Job summary

Venteon seeks a Treasury & Financial Reporting Manager in Detroit to lead treasury operations, forecasting, and reporting. The role demands deep SQL querying, Excel-based analysis, and Power BI dashboard development to support funding decisions and liquidity management.

The ideal candidate has a Bachelor’s degree with 5+ years of relevant experience, strong analytical and communication skills, and a proven ability to translate data into actionable insights for senior management.

Qualifications

• Bachelor’s degree in accounting, finance, business administration, data analytics, or related field.
• At least 5 years of relevant professional experience.
• Demonstrated data-analysis experience including data extraction, cleansing, reconciliation, trend and variance analysis, root-cause analysis.
• Advanced Microsoft Excel skills and experience developing dashboards, KPIs, and management reporting using BI tools; Power BI preferred.
• Strong SQL experience with joins, aggregations, subqueries/CTEs, conditional logic, and data validation.

Responsibilities

• Manage treasury functions for debt compliance and funding arrangements to optimize financial stability.
• Prepare monthly cash flow forecasts, bank funding certificates, and periodic cash and debt forecasts.
• Monitor daily cash positions and ensure adequate liquidity to optimize working capital.
• Make formal recommendations for intercompany settlements as part of cash forecasting.
• Develop and maintain treasury policies and procedures.
• Automate cash management and reporting processes for the Treasury function.
• Maintain the treasury management system.
• Perform periodic reviews of rates, fees, and currency exchange rates.
• Use SQL to query, join, aggregate, and extract data for reports.
• Develop and document reusable SQL queries for management reporting and reconciliations.
• Analyze large datasets to identify trends and key drivers; communicate findings to management.
• Perform data validation and quality checks across source systems and reports.
• Create dashboards, KPIs, and analytical reports using Excel and Power BI.

Skills

Data analysis

Excel advanced

Power BI

SQL

Communication

Attention to detail

Project management

Education

Bachelor’s degree in accounting/finance/business/data analytics

Tools

Power BI

Relational databases

Job description

Venteon seeks a Treasury & Financial Reporting Manager in Detroit to lead treasury operations, forecasting, and reporting. The role demands deep SQL querying, Excel-based analysis, and Power BI dashboard development to support funding decisions and liquidity management.

The ideal candidate has a Bachelor’s degree with 5+ years of relevant experience, strong analytical and communication skills, and a proven ability to translate data into actionable insights for senior management.