Management Advisor

As an Applications Management Advisor, you will support and enhance the front-to-back Energy Trading and Risk Management environment used by trading, middle office, market risk, commercial operations, and settlements teams. Your work will vary from day to day, balancing hands‑on development with production support in a fast‑paced trading business. You will build and maintain data pipelines, integrations, warehouses, reports, and custom applications while investigating failed jobs, access questions, system issues, and data discrepancies.

You will also contribute to business‑driven projects that introduce new customers, vendors, products, data sources, and reporting needs, while helping the team prepare to support the future transactional platform.

• Design, develop, maintain, and troubleshoot ETL processes and SSIS packages for data integration and migration.
• Develop, optimize, and re‑engineer SQL queries, stored procedures, views, and functions across data warehouse environments.
• Integrate and validate data from SQL Server, Oracle, CSV files, APIs, and external sources that may require token‑based or multifactor authentication.
• Implement error handling, logging, auditing, reconciliation, and data‑quality controls across integrated systems.
• Support the ETRM platform and related workflows, including trade, market, pricing, reference, risk, P&L, position, and exposure data.
• Create and maintain reports, dashboards, technical specifications, data mappings, data dictionaries, and operational documentation.
• Collaborate with business analysts, data engineers, technical team members, and business stakeholders to translate evolving needs into sustainable solutions.
• Provide responsive production support while managing multiple development, enhancement, and issue‑resolution priorities.

• Bachelor’s degree in Computer Science, Engineering, Management Information Systems, or a related field, or an equivalent combination of education, training, and relevant experience
• A minimum of 7 years relevant work experience is required
• Expert‑level experience with Microsoft SQL Server, including database design, query optimization, performance tuning, stored procedures, and SQL Server Integration Services (SSIS)
• Experience developing and maintaining enterprise reporting solutions using SQL Server Reporting Services (SSRS) or a comparable platform
• Hands‑on experience extracting and integrating data from Oracle databases;
  Oracle application development is not required
• Proficiency in Python for data engineering, ETL, API integration, automation, and data transformation, including libraries such as Pandas and Num Py
• Experience designing, building, and supporting data pipelines that integrate multiple internal and external systems
• Knowledge of data warehousing, dimensional modeling, data governance, metadata management, and data‑quality practices
• Experience in an energy, commodity trading, financial trading, or ETRM environment, with an understanding of trades, commodities, scheduling, settlements, risk, or market data
• Ability to communicate technical concepts clearly to technical and non‑technical stakeholders and understand detailed technical requirements
• Strong analytical, troubleshooting, and root‑cause problem‑solving skills in an agile, changing environment
• Ability to manage multiple assignments accurately and adapt priorities in response to production and business needs
• This role is eligible for our hybrid work policy and requires working in the Houston office three days and two days working from home per week
• Occasional domestic travel may be required, typically once or twice per year for disaster recovery exercises, including possible travel to Austin, Texas.
• This role may require additional support during a…