Python à United States

The driving force behind our success has always been the people of AspenTech. What drives us is our aspiration, our desire, and ambition to keep pushing the envelope, overcoming any hurdle, and challenging the status quo to continually find a better way. You will experience these qualities of passion, pride, and aspiration in many ways — from a rich set of career development programs to support of community service projects to social events that foster fun and relationship building across our global community.

OSI’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 a Model Engineer, you will be developing, maintaining, and optimizing network models for electric utilities. You will be responsible for generating and troubleshooting DMS network models and refining them while collaborating with other Engineers. You will be highly engaged with our customers, leading and supporting project efforts. You will also focus on understanding customer data sources, especially Esri GIS, database schemas, and follow the ETL process to rapidly transform these inputs to the target data model.

This position gives you broad exposure to the entire OSI ADMS ecosystem. 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.

• Participate in design, planning, and execution of ADMS projects.
• Engage in 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 and improve 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.

• Bachelor's degree in Geography, GIS, Computer Science, Engineering, or a related field.
• 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.) is a strong plus.
• Experience in the Utility Power Industry or equivalent is a strong plus.
• Experience in troubleshooting complex systems and software applications.
• Strong communication skills, both verbally and written.
• Proven ability to organize and prioritize work within tight timelines.