Sr Treasury Analyst

Atmos Energy Corporation; Dallas (TX); On-site; USD 85,000 - 110,000; Full time

Job summary

Atmos Energy Corporation in Dallas seeks a Data Analyst specializing in cash forecasting and BI tools (Tableau/Power BI) to support Treasury operations. You will maintain forecasting tables, prepare monthly cash forecasts, and collaborate with IT to optimize treasury systems.

Minimum requirements include a Master's or Bachelor's in Accounting, Finance, or Business Administration with 3–4 years in finance or cash management; strong analytical, communication, and advanced spreadsheet skills are

Qualifications

• Requires a Master's or Bachelor's degree in Accounting, Finance or Business Administration and 3+ years of experience in finance, accounting or cash management.
• Requires strong communication and numeric skills to handle technical and complex matters.

Responsibilities

• Maintains policies, procedures and controls to ensure compliance with treasury policies and GAAP.
• Reviews treasury-related journal entries and submits monthly ledger reports.
• Prepares and submits month-end/quarter-end debt and investment reports and reconciles with bank statements.
• Liaises with Legal to track changes in dockets and universal shelf activity.
• Assists in capital structure reporting and SOX documentation.
• Maintains cash forecasting tables and assists in forecast preparation and system improvements.

Skills

Communication skills

Numeric skills

Computer skills

Education

Master's degree in Accounting, Finance or Business Administration

Bachelor's degree in Accounting, Finance or Business Administration

Tools

Tableau

Power BI

Job description

Hyperion (Must Have) Cash Forecasting Tableau/Power BI Data Analyst Skills

Primary Duties

1. Maintains functional area policies, procedures and controls to assure compliance with Treasury policies, Generally Accepted Accounting Principles (GAAP) and regulatory requirements.
2. Reviews all daily/monthly treasury related journal entries.
   Prepares and submits the monthly treasury general ledger report.
3. Prepares and submits month-end/quarter-end reports for short-term debt, long-term debt and investments.
   Reconciles reports against corresponding bank statements.
4. Files and processes reports of action to comply with reporting requirements in multiple state jurisdictions.
   Partners with Legal to track and document changes in dockets and universal shelf activity.
5. Prepares and submits quarterly reports to the rating agencies.
   Processes payments for related fees.
6. Partners with IT to maintain and update departmental software and systems.
   Troubleshoots issues related to the treasury management system.
7. Researches and prepares responses to rate case questions.
   Assists in the preparation of monthly capital structure reports.
8. Responds to internal and external audit requests related to SOX requirements and process documentation.
9. Administers Procurement Card and Travel & Entertainment Card programs.
   Serves as the liaison with the card program sponsor.
10. Documents and develops correspondence to satisfy long and short-term debt covenant requirements.
    Assists in the preparation of loan compliance calculations.
11. Processes payments for long and short-term debt interest expense, principal payments and commitment fees.
    Assures the accuracy of the monthly accruals for the same items.
12. Monitors monthly banking fees and charges.
    Maintains legal documents to satisfy banking requirements.
    Promotes and upholds strong banking relationships with service representatives.
    Assists with bank-required projects and supports the Banking at work programs.
13. Maintains cash forecasting tables.
    Assists in the preparation of monthly cash forecasts, reviewing and reclassifying items as necessary to assure accuracy.
    Participates in the modification, evaluation and implementation of cash flow forecasting and working capital process technologies.

Minimum Requirements

• Requires Master's degree in Accounting, Finance or Business Administration and three years experience in finance, accounting or cash management; or Requires Bachelor's degree in Accounting, Finance or Business Administration and four years experience in finance, accounting or cash management.
• Communication Skills: Requires the ability to communicate, persuade and/or influence internal customers at all level of management on matters of a technical and/or complex nature.
• Numeric Skills: Requires the ability to apply to perform algebraic, trigonometric and geometric operations and/or moderately complex statistical and/or accounting methods.
• Computer Skills: Requires advanced knowledge of various software applications to create spreadsheet models, documents, reports and graphics.
• Physical Demands: Requires occasionally performing activities including, but not limited to, bending, stooping, grasping, reaching, twisting, turning and/or lifting.
• Work Conditions: Works in an office environment.

Atmos Energy Corporation is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, or veteran status.

Job Family

Treasury/Investor Relations atmos Energy Corporation, a natural gas-only distributor, is an S&P 500 company headquartered in Dallas. We safely deliver reliable, affordable, efficient and abundant natural gas to more than 3 million distribution customers in over 1,400 communities across eight states located primarily in the South. As part of our vision to be the safest provider of natural gas services, we are modernizing our business and infrastructure while continuing to invest in safety, innovation, environmental sustainability and our communities. Atmos Energy manages proprietary pipeline and storage assets, including one of the largest intrastate natural gas pipeline systems in Texas.