Think Beyond The Label Jobs

AspenTech is a global software leader helping industries meet the increasing demand for resources from a rapidly growing population in a profitable and sustainable manner. Our Digital Grid Management software suite, including AspenTech OSI products, helps power and utilities companies achieve superior real-time control, optimization and management for exceptional performance of complex energy networks. The RoleDGM's Advanced Distribution Management System (ADMS) is a high growth area in our business that unlocks an electric distribution utility's ability to monitor, manage, control, and optimize the grid. As an experienced ADMS Model Engineer focused on the GIS data conversion you will be involved in rapid conversion and development of the data model. A deep knowledge of Esri ArcGIS and other GIS vendors as well as an extensive DBMS experience will drive efficiency in the ADMS model processes is necessary. In this role you will be responsible for generating working DMS data models at a rapid pace and handing them over to Power Model Engineers for further refinement. You will be highly engaged with our customers leading and supporting project efforts. You will be focused on understanding existing source database schema and system representation and oversee the ETL process to the target data model, with the focus on efficiency and expediency of the data extraction. This position gives you broad exposure to the entire DGM ADMS system and you will be a primary point of contact for GIS side of the distribution electrical network modeling work with our customers throughout the project lifecycle. You will have the opportunity to work across functional teams including Power Model Engineers, Subject Matter Experts, Model Excellence Engineers, and other project engineers ensuring customer satisfaction and a velocity of project deliverables. Your Impact Participate in design, planning, and execution of ADMS projects. Lead customer workshops focused on data modeling. Support customer data quality assessments. Extract data from various sources, including databases, web services, and APIs. Transform data by cleaning, formatting, and validating it. Develop and maintain data quality checks. Document ETL processes and procedures. Identify and analyze database queries associated with ETL workflows. Tune SQL queries and indexes to improve query execution times. Monitor and troubleshoot ETL performance issues. Interface with the utilities Geographic Information System (GIS) teams to extract, translate, and load the electrical network model to the Distribution Management System. Configure and integrate software components to meet contract requirement specifications and test with customers. Train customers on how to operate the systems being delivered. Provide technical support to troubleshoot and resolve issues observed on live systems. What You'll Need Bachelor's degree in Geography, GIS, Computer Science, or a related field with 8+ years of technical experience. Experience with ETL tools and methodologies. Strong understanding of geospatial data concepts and principles. Proficiency in SQL and scripting languages (Python, Perl, etc.). Experience with GIS software (ArcGIS, QGIS, etc.). Experience in the Utility Power Industry or equivalent. Experience troubleshooting complex systems and software applications. Strong communication skills, both verbally and written. Proven ability to organize and prioritize work within tight timelines. Ability to travel up to 25%. Preferred Requirements 3-5 years of experience in the Utility Power Industry 5+ years of experience GIS maintenance, administration, and data entry experience with Esri, GE, Oracle, or Milsoft Operations or engineering experience at an electric utility is preferred. #LI-RT1 AspenTech is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity national origin, disability, or protected Veteran status or any other basis protected by federal, state, or local law.