# Grant Horner > Senior Software Engineer at OpenInvest Location: Delmar, New York, United States Profile: https://flows.cv/granthorner Passionate software engineer with 7 years professional programming experience across the stack. Heavy emphasis on simple, testable code and communication. ## Work Experience ### Senior Software Engineer (OpenInvest) @ J.P. Morgan Jan 2023 – Present | Albany, New York, United States Full stack development in Typescript (React, Express), Python (FastAPI, Flask), Go and Java (Spring Boot), as well as supporting our IaC repositories written in Terraform. Designed and developed new internal platform for ESG analysts. Built out our own feature flag service that integrates with JP Morgan's release management system. Ran software team dedicated to developing and maintaining OpenInvest’s data pipelines. Migrated existing OpenInvest EKS deployment pipeline into the JPM AWS ecosystem. Led development and design of Spring Boot GraphQL server for use across JPM. Designed and performed large scale refactoring of OpenInvest Airflow ETL pipelines to improve data durability and auditability. Used Terraform to manage the team's infrastructure, including our EKS cluster, ECS clusters, MySQL Aurora databases, elasticache, secretsmanager and S3 buckets. Used Datadog to set SLOs, create monitoring dashboards, and use application performance monitoring to inform technical decisions and optimizations, improving response times of a key API by 80%. Managed and improved our Terraform codebase, helping shift teams towards self managing their own ECS clusters. ### Software Engineer (OpenInvest) @ J.P. Morgan Jan 2021 – Jan 2023 Full stack development in Typescript (React, Express), Python (FastAPI, Flask) and Clojure (Reitit, Ring). Architected and implemented a new public REST API using FastAPI following the J.P. Morgan acquisition, following Google, Microsoft and Slack REST API standards. Designed and implemented a security name matching tool using Clojure for internal use. Led development on a sustainable reporting platform using Typescript (React, Express, Puppeteer). ### Full Stack Engineer @ OpenInvest Jan 2021 – Jan 2021 Full stack development prior to the company's acquisition by JP Morgan. ### Software Developer @ SourceOne, Inc (DE) Jan 2018 – Jan 2021 | Greater New York City Area Build and develop our in-house EmSys web app, using Angular, C# and MSSQL. Develop Python scripts to automate business tasks. Assist business team, providing technical support for special projects and automating data processes. Act as liaison between the development and business teams, providing context and clarification to requests and inquiries. ### Energy Analyst @ SourceOne, Inc (DE) Jan 2017 – Jan 2019 | New York, New York Managed MSSQL database and client relationships for all 106 utility vendors of the largest transportation agencies in New York City and Washington D.C. Uncovered and investigated data discrepancies through careful data analysis using Excel, SQL and Tableau driven visualizations. Built Python applications to reduce SourceOne’s expenditures by automating monthly data manipulation/cleansing of Excel and CSV files. Designed Tableau dashboards that drove business decisions and exposed savings opportunities for customers. Designed and built prototype for SourceOne’s first automated QA reporting system using Python and SQL. ### Project Engineer Co-Op @ SourceOne, Inc (DE) Jan 2017 – Jan 2017 | New York, New York Aided Energy Management team through data manipulation and investigation in Excel and MSSQL databases. Excellent performance led to a permanent position at SourceOne as an Energy Analyst. ### Solar Consultant @ Level Solar Jan 2017 – Jan 2017 | Brooklyn, New York ### Team Leader/Lead Ambassador @ Level Solar Jan 2016 – Jan 2017 | Brooklyn, New York Responsible for training and developing a team of four Solar Ambassadors, as well as monitoring their progress by checking key performance indicators and conducting personal interviews. Motivating the team to grow and improve their skills and attitudes through leadership, positive energy and a positive attitude. ### Solar Ambassador @ Level Solar Jan 2016 – Jan 2016 | Brooklyn, New York Spearheaded operations in a green energy startup to penetrate the New York residential solar market. Worked alongside various departments such as Solar Consultants, CAD Specialists and Marketing to resolve customer concerns and verify home specifications. Educated home owners on the benefits of solar energy and arranged appointments for them to meet with our consultants to check customer financial information and verify their qualifications for our program. My success resulted in being chosen to train new Solar Ambassadors as a Lead Ambassador. ### Mailroom Clerk @ SUNY Geneseo Jan 2015 – Jan 2016 Organizing mail, signing in mail, retrieving mail for students and delivering mail across campus. ### Junior Counselor @ JMU4Kids Jan 2011 – Jan 2011 I worked as a Junior Counselor at the JMU4Kids summer camp, working with kids who were 3-5 years old. ### Junior Counselor @ JMU4Kids Jan 2010 – Jan 2010 I worked as a Junior Counselor at the JMU4Kids summer camp, working with kids who were 3-5 years old. ## Education ### Bachelor’s Degree in Geology/Mathematics SUNY Geneseo Jan 2012 – Jan 2016 ## Contact & Social - LinkedIn: https://linkedin.com/in/hgranthorner --- Source: https://flows.cv/granthorner JSON Resume: https://flows.cv/granthorner/resume.json Last updated: 2026-03-22