Applications Management Advisor

ENGIE North America Inc.; Houston (TX); Hybrid; USD 117,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k) with company match

ESPP

Paid time off

Wellness days

Job summary

ENGIE North America is seeking an Applications Management Advisor in Houston to design and maintain ETL processes, optimize SQL data workflows, and support the ETRM data ecosystem. You will integrate data from SQL Server, Oracle, and external sources, implementing robust data quality and reporting solutions.

The role requires 7+ years of relevant experience, strong Python skills, and the ability to communicate complex technical concepts to both technical and non-technical stakeholders.

Qualifications

• Bachelor's degree or equivalent in a related field
• 7+ years of relevant work experience
• Expert-level SQL Server experience including design, optimization, and SSIS
• Experience with SSRS or a comparable reporting platform
• Hands-on experience extracting data from Oracle databases
• Proficiency in Python for data engineering and API integration (Pandas/NumPy)
• Experience building data pipelines across multiple systems
• Knowledge of data warehousing, governance, and data quality practices
• Experience in energy or trading ETM environments
• Strong communication and problem-solving skills

Responsibilities

• Design, develop, maintain and troubleshoot ETL processes and SSIS packages
• Develop, optimize SQL queries, stored procedures, views, and functions
• Integrate and validate data from SQL Server, Oracle, CSV, APIs, and external sources
• Implement error handling, logging, auditing, and data-quality controls
• Support ETRM platform data workflows including trade and risk data
• Create and maintain reports, dashboards, data mappings and documentation
• Collaborate with analysts, data engineers and stakeholders to translate needs
• Provide responsive production support and manage multiple priorities

Skills

SQL Server

SSIS

SSRS

Python

Data integration

Data warehousing

Analytical skills

Communication

Education

Bachelor's degree in Computer Science, Engineering, MIS, or related field

Tools

SSIS

SSRS

Oracle

Job description

What You Can Expect

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.

What You’ll Bring

• 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 NumPy
• 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

Additional Details

• 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 business continuity or disaster recovery event.
• Must be willing and able to comply with all ENGIE ethics and safety policies

Compensation

Salary Range: $117,300 - $179,860 USD annually

This represents the average expected pay range for a qualified candidate.

ENGIE complies with all federal, state, and local minimum wage laws. Actual salary offered may vary depending on geography, experience, education, internal pay alignment, or other bona fide factors.

In addition to base pay, this position is eligible for a competitive bonus / incentive plan.

Your Talent Acquisition Partner can share more specific information regarding the benefits or the salary for the position based on the work location.

At ENGIE, we take your well-being seriously. Our comprehensive benefits package includes options for medical, dental, vision, life insurance, employer-paid short-term and long-term disability insurance, ESPP, generous paid time off including wellness days, holidays and leave programs. We also help you plan for retirement by offering a 401(k) Retirement Savings Plan with a company match. But that's not all - we're dedicated to the health and happiness of your entire family, offering supplemental benefits for full time employees that enhance emotional and physical well-being through all stages of life from family forming to caregiver benefits. Explore our benefits package to see how we can support you. Learn more .

Why ENGIE?

ENGIE North America isn't just participating in the Zero-Carbon Transition, we’re leading it! Join us as we develop energy that is renewable, efficient, and accessible to everyone.

At ENGIE, every talent has a role to play in the adventure of the century. Make a difference and enjoy a fulfilling professional experience. Take on exciting challenges and build a career path that reflects who you are.

Join us and be part of the adventure!

ENGIE is proud to be an equal opportunity workplace, and we are firmly committed to creating an inclusive workplace for all employees. We are committed to providing employees with a work environment free of discrimination and harassment. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status.

If you need assistance with this application or a reasonable accommodation due to a disability, you may contact us at [e-mail]. This email address is reserved for individuals with disabilities in need of assistance and is not a means of inquiry regarding positions or application status.

We value internal mobility and will offer sponsorship for this role to internal candidates only.

The safety of our employees is our number one priority. All employees at ENGIE have both a duty and the authority to STOP WORK if unsafe acts are observed.

Company Name: ENGIE North America

Minimum Base Salary: 117,300.00 USD

Maximum Base Salary: 179,860.00 USD

Pay Basis: Annual