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, 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.
The Role
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 to generate and troubleshoot DMS network models and refine them collaborating with other Engineers. You will be highly engaged with our customers leading and supporting project efforts. You will be also focused on understand 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 a 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.
Your Impact
- 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.
What You'll Need
- 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.
- Strong communication skills, both verbally and written.
- Proven ability to organize and prioritize work within tight timelines.