Trading Back Office Analyst: Reconciliation & Compliance

Burnett Specialists Staffing | Recruiting; Houston (TX); On-site; USD 70,000 - 110,000; Full time

Job summary

Burnett Specialists Staffing | Recruiting seeks a Back Office Analyst in Houston to support trading operations in a fast-paced environment. The role emphasizes independent and collaborative work, strong communication, and strict deadline discipline.

You will engage in trade validation, confirmations, onboarding, and process improvements, leveraging Excel, VBA, Python, Power BI, and Alteryx to streamline reporting and analytics. Strong energy market knowledge is preferred.

Qualifications

• Undergraduate degree in Accounting, Finance, Mathematics, Energy, or a business-related major.
• 2–3 years of experience in the Gas, LNG, and Energy markets with a data analysis component.
• Knowledge of energy commodity markets is highly desirable.
• Ability to work under pressure while meeting strict deadlines.
• Strong attention to detail and accuracy in a high-risk financial environment.
• Effective and proactive communication skills with a customer service mindset.
• Demonstrated ability to drive innovation, manage change, and improve processes.
• Advanced computer proficiency with IT skills.
• Expertise in Excel (including VBA).
• Knowledge of Python for data analysis and process optimization.
• Skilled in Power BI for dashboards and reporting.
• Experience with Alteryx for data prep and automation.
• Familiarity with Power Automate for workflow automation.
• Ability to develop new tools to secure and optimize processes and build reports.

Responsibilities

• Manage trading counterpart portfolio and verify deal sheets/reports in BOOK system.
• Confirm daily trades with counterparts/brokers and validate exchange positions and limits.
• Perform daily trade checks, reconciling confirmations against internal records.
• Settlements, Invoicing & Reconciliation.
• Issue and reconcile invoices within deadlines, resolving discrepancies with Operations/Middle Office.
• Agree settlements, provide payment instructions, and deliver cash forecasts to Treasury.
• Support Accounting with debt reporting, accruals, and analyze settlement statements in Simba systems.
• Process and record confirmations in the BOOK, chasing outstanding items daily.
• Review confirmations/settlements for pricing and volume adjustments.
• Collaborate with IT to automate confirmation processes.
• Regulatory & Market Monitoring; report OTC trades within 24 hours to meet Dodd-Frank requirements.
• Monitor market/regulatory changes and ensure audit compliance.
• Lead onboarding of new counterparts and provide support on trade queries.
• Mentor junior team members and assist colleagues.
• Contribute to projects, management reports, and ad hoc analysis.
• Support new product/market implementation with compliant process documentation.
• Drive process/system improvements, assess operational risks, and define mitigating measures.

Skills

Excel

VBA

Python

Power BI

Alteryx

Power Automate

Data analysis

Education

Undergraduate degree in Accounting/Finance/Mathematics/Energy or related major

Tools

Excel

Power BI

Alteryx

Power Automate

Python

VBA

Job description

Burnett Specialists Staffing | Recruiting seeks a Back Office Analyst in Houston to support trading operations in a fast-paced environment. The role emphasizes independent and collaborative work, strong communication, and strict deadline discipline.

You will engage in trade validation, confirmations, onboarding, and process improvements, leveraging Excel, VBA, Python, Power BI, and Alteryx to streamline reporting and analytics. Strong energy market knowledge is preferred.