Finance 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

We were recently engaged in a new search for a Treasury & Financial Reporting Manager position with a transportation infrastructure solutions company based in Detroit, MI.

Requirements:

• Bachelor’s degree in accounting, finance, business administration, data analytics, or a related field, plus at least 5 years of relevant professional experience.
• Demonstrated data-analysis experience, including data extraction, cleansing, reconciliation, trend and variance analysis, root-cause analysis, and the ability to translate complex data into clear business insights and recommendations.
• Strong attention to detail, data accuracy, and reporting consistency.
• Excellent verbal and written communication skills
• Project management experience is a plus
• Advanced Microsoft Excel skills and experience developing dashboards, KPIs, and management reporting using business intelligence tools; Power BI experience is preferred.
• Strong SQL experience is required, including writing complex queries using joins, aggregations, subqueries/CTEs, conditional logic, and data-validation techniques, with a working knowledge of relational databases and data structures.

Responsibilities:

• Manage treasury functions for debt compliance and funding arrangements to optimize financial stability, which includes:
• Prepare monthly cash flow forecasts, bank funding certificates, and periodic cash and debt forecasts to support funding requirements and strategic decision-making.
• Monitor daily cash positions and ensure adequate liquidity to optimize working capital and cash reserves.
• Make formal recommendations for biannual and other periodic intercompany settlements as part of cash forecasting.
• Develop and maintain treasury policies and procedures following formal recommendation and approval.
• Automate cash management and reporting processes for the Treasury function.
• Maintain the treasury management system.
• Perform periodic reviews and analyses of interest rates, bank fees, credit card fees, and currency exchange rates.
• Use SQL to query, join, aggregate, validate, and extract data from financial, toll, and operational systems for recurring and ad hoc management reporting.
• Develop, maintain, and document reusable SQL queries and data extracts used for management reporting, reconciliations, forecasting, and decision support.
• Analyze large and complex datasets to identify trends, variances, anomalies, root causes, and key business drivers; prepare cost-benefit and other financial/operational analyses; and communicate findings clearly to management.
• Perform data validation, reconciliation, and quality checks to ensure accuracy and consistency across source systems and reports.
• Create and maintain dashboards, KPIs, and analytical reports using advanced Excel and business intelligence tools such as Power BI.