Solution Engineer

M

Manifest Solutions

Solution Engineer

Columbus, OH
Full Time
Paid
  • Responsibilities

    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.