Manifest Solutions is currently seeking a Solution Engineer for an onsite position in Columbus, OH.
- Provide hands-on technical support for data-intensive pricing solutions, an enterprise energy-trading and risk-management platform, associated databases, scheduled processes, integrations, reports, and operational tools.
- Diagnose application, database, interface, job, configuration, and data-processing failures.
- Restore service safely and promptly during production incidents.
- Provide after-hours support when mission-critical Gas processes or peak operating periods require it.
- Escalate provider or infrastructure issues with complete technical evidence and remain accountable through resolution.
- Develop, test, and deploy stored-procedure, database, integration, application, reporting, and automation changes.
- Implement validation that identifies missing or incomplete data instead of allowing hidden errors or unsupported default values to continue through pricing or risk processes.
- Improve application logging, monitoring, alerting, error handling, recoverability, and operational transparency.
- Reduce manual work, rework, recurring defects, and dependence on individual subject-matter experts.
- Contribute to application upgrades, modernization, technical-debt reduction, and lifecycle planning.
- Learn the business processes supported by the applications, including forecasting, position reporting, matrix pricing, Transport deal processing, market-data intake, trading, settlement, billing, and reporting.
- Trace data from source systems through databases, calculations, interfaces, reports, and downstream consumers.
- Work directly with business SMEs to reproduce issues, validate results, test corrections, and understand operational impacts.
- Recognize when a technical change could affect pricing accuracy, risk positions, settlements, customer outcomes, compliance, or financial reporting.
- Create and maintain technical documentation, support runbooks, recovery procedures, code and database references, and troubleshooting guides.
- Cross-train with other application-support engineers to establish primary and backup coverage.
- Participate in knowledge-transfer sessions with current SMEs, providers, and support teams.
- Follow established development, testing, release, change-management, access-control, and production-validation procedures.
- Share technical findings and reusable knowledge with the broader Operations Technology team.
- Monitor and support production applications, databases, scheduled jobs, integrations, reports, and supporting services.
- Investigate incidents, determine impact, restore service, and document technical findings.
- Perform root-cause analysis and implement durable corrections for recurring problems.
- Develop, test, review, and deploy stored procedures, queries, application components, integrations, reports, and automation.
- Implement application and data controls that detect missing, incomplete, invalid, or inconsistent information.
- Improve logging, monitoring, alerting, error handling, recoverability, and support visibility.
- Support application releases, environment promotions, patches, upgrades, rollback planning, and post-deployment validation.
- Work with business SMEs to understand requirements, reproduce problems, validate calculations, and complete user-acceptance support.
- Reconcile data among source systems, application databases, operational reports, and downstream consumers.
- Maintain source control and comply with development, testing, security, audit, and change-management standards.
- Develop and maintain runbooks, technical documentation, interface records, job inventories, recovery procedures, and troubleshooting guides.
- Coordinate technical issues with packaged-software providers, custom-development partners, market-data services, and SaaS platforms as assigned.
- Cross-train with other team members and provide backup coverage for critical applications and processes.
- Support Choice and adjacent retail-energy applications when needed for integration troubleshooting, continuity, or transition activities.
- Provide after-hours support during high-severity incidents and business-critical operating periods when required.
Minimum Requirements
- Bachelor's degree in Computer Science, Software Engineering, Information Systems, Engineering, or a related technical field. An equivalent combination of education and relevant experience may be considered.
- Eight or more years of relevant application development, database development, integration, or production-support experience.
- Advanced SQL and relational-database experience.
- Strong development or support experience with Microsoft SQL Server/T-SQL, Oracle/SQL, or a comparable enterprise database platform.
- Experience developing or troubleshooting stored procedures, scheduled jobs, batch processes, data transformations, or data interfaces.
- Experience supporting enterprise applications in a production environment.
- Experience with at least one applicable development or scripting technology, preferably C#/.NET or Java.
- Experience troubleshooting APIs, file transfers, or other system integrations.
- Experience with source control, structured testing, release procedures, change management, and rollback.
- Demonstrated root-cause analysis, technical documentation, and problem-solving skills.
- Ability to provide after-hours production support when business-critical needs require it.
Preferred Qualifications
- Experience with both Microsoft SQL Server/T-SQL and Oracle/SQL.
- Experience with an enterprise energy-trading, risk-management, or commodity-management platform.
- Experience supporting energy pricing, risk, trading, scheduling, settlement, billing, or financial-reporting processes.
- Experience with Azure, Azure DevOps, GitHub or Git, IIS, Power Automate, or related tools.
- Experience supporting applications that use Excel-based operational or reporting interfaces.
- Experience working with SaaS providers, packaged-software providers, or distributed development teams.
- Relevant database, cloud, development, ITIL, or DevOps certifications.
Competencies
- Operational Ownership: Follows incidents through diagnosis, recovery, validation, documentation, and preventive action.
- Technical Problem Solving: Uses evidence to isolate complex application, database, integration, and data problems.
- Quality Focus: Produces controlled, tested, maintainable changes and recognizes the business consequences of inaccurate results.
- Learning Agility: Builds knowledge across unfamiliar applications, technologies, and business processes.
- Collaboration: Works productively with business users, technical teams, external providers, and other developers.
- Communication: Explains technical findings clearly and provides useful status during incidents and delivery work.
- Documentation: Creates support materials that enable others to perform recurring work and recover from failures.
- Risk Awareness: Recognizes impacts to pricing, trading, settlement, customer outcomes, security, compliance, and financial reporting.
- Adaptability: Works effectively across custom software, packaged applications, databases, spreadsheets, integrations, and SaaS platforms.
Technologies and Tools
- Databases and Data: Microsoft SQL Server, T-SQL, stored procedures, Oracle, SQL, data reconciliation, data validation, and performance tuning.
- Applications: Data-intensive pricing solutions and enterprise energy-trading, risk-management, or commodity-management platforms.
- Development and Integration: C#/.NET, Java, REST APIs, IIS, scheduled and batch processing, and file/SFTP interfaces.
- Cloud and DevOps: Microsoft Azure, Azure DevOps, GitHub or Git, CI/CD pipelines, automated deployment, and rollback.
- Automation and Operations: Monitoring and alerting tools, job scheduling, workflow automation, and IT service-management tools.
- Business Interfaces: Excel-based operational tools, pricing templates, data feeds, reports, and reconciliation processes.
- Adjacent Platforms: SaaS solutions, retail-energy platforms, market-data services, and other externally managed applications.
