Troops to Energy Jobs

Job Information

Duquesne Light Company Operations Analytics Spec I in Pittsburgh, Pennsylvania

Duquesne Light Company, headquartered in downtown Pittsburgh, is a leader in providing electric energy and has been in the forefront of the electric energy market, with a history rooted in technological innovation and superior customer service. Today, the company continues its role as a leader in the transmission and distribution of electric energy, providing a secure supply of reliable power to more than half a million customers in southwestern Pennsylvania.

Duquesne Light Company is committed to creating a culture of inclusion. We value and respect the unique differences and experiences of our employees. We believe that our differences lead to better collaboration, innovation and outcomes. We want you to join our team!

Position Title: Operations Analytics Specialist I

Company: Duquesne Light Company

Unit: Operations

Department: 830

FLSA Status: Exempt

Overall Purpose

The Operations Analytics team at Duquesne Light is looking for a motivated individual to work in a team-based environment for collecting, analyzing, and reporting the Operations Departments’ key performance indicators. The successful candidate will utilize advanced tooling in Python, Vuejs, PowerBI, Excel, and other technology stacks to perform tasks related to the job. These tasks include managing a python codebase that focuses on ETL, data automation, and data visualization. Additional skills in Excel are required to build successful data processes for reporting. The successful candidate shall identify and collaborate with teammates to build automation, data (science) modeling, and process improvement pipelines that allow the business to view meaningful insights. Upon completing any insights, the individual must be able to present at a high level to convey the results and be able to present the data at a technical level. The individual must understand how to work within and lead a team to provide actionable results.


  1. The successful candidate shall have advanced problem-solving skills to perform tasks related to the job. The individual shall have excellent skills relating to analytics, programming, finance, and project management. The individual shall be able to lead several projects requiring various skillsets.

  2. Skills include:

  3. Analysis

  4. Predictive Analytics

  5. Forecasting

  6. Cost saving initiatives

  7. Data Modeling

  8. ETL

  9. Database Management

  10. Data Warehousing

  11. Reporting

  12. Visualizations

  13. PowerPoint

  14. Programming/Software

  15. Python

  16. JavaScript

  17. Power BI

  18. Utilize different technology stacks to perform analysis that can create API’s or visualizations that allow the business to make performant related decisions. Must be a self-starter in creating team initiatives. Must be able to lead meetings and build timelines for deliverables.

  19. Have an understanding of data structures with the ability to lead projects related to Python, SQL, and Power BI. Focus on object oriented programming and providing actionable outputs to the business.

  20. Perform code deployments on the Azure DevOps platform and train employees to assist.

  21. Develop ad-hoc reporting and performance-improvement analyses related to the Operations Department.

  22. Lead in the process of compiling, proofing, and publishing regular (e.g. monthly), comprehensive reports of the Operations Department’s performance results utilizing the Microsoft Office suite of applications at a quality-level appropriate for consumption by DLC’s executive officers and Board of Directors.

Additional Responsibilities

  1. Support Duquesne Light Company’s path to top quartile safety and reliability performance.

  2. Support server/code uptime.

  3. Ability to be on call (rotation).

  4. Other duties as assigned.


Required: Accredited Bachelor degree in accounting, business administration, computer science, engineering, finance, information technology, or 5+ years of experience. Must be proficient in Microsoft Office applications, Python, SQL, Power BI, Excel, and Git.

Willingness to Learn:

JavaScript – Vuejs and VBA


  • Excellent analytical, project management, problem solving, and modeling skills.

  • Desire to learn, grow, or expand skillsets in the business.

  • Python and Power BI proficiency required.

  • Great presentation (PowerPoint) skills at both a high level and technical level.

  • Experience with SQL and data mining techniques for structured and unstructured data.

  • Understand how to utilize programming techniques to transform data into meaningful results.

  • Ability to perform various analyses related to cost saving initiatives and risk awareness.

  • Outstanding oral and written communication skills.

  • Ability to lead a team and meet key deadlines for deliverables.

  • Ability to handle multiple tasks concurrently and work in a fast-pace and changing environment.

  • Must be highly regarded for integrity, collaboration, flexibility, teamwork, and interpersonal skills.

  • An entrepreneurial spirit with keen attention to detail.

  • Familiarity with Microsoft products.

Physical Requirements

  • Normal office environment.

  • Currently in a work from home environment due to COVID-19. Subject to change.

  • May spend long periods sitting.

  • Manual dexterity to operate a computer keyboard.


The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

Duquesne Light Company is committed to providing equal employment opportunity to all people in all aspects of the employment relationship, without discrimination because of race, age, sex, color, religion, national origin, disability, sexual orientation and gender identity or status as a Vietnam era or special disabled veteran or any other unlawful basis, as defined by applicable law, and fostering a workplace free of unlawful discrimination and retaliation. This policy affects decisions including, but not limited to, hiring, compensation, benefits, terms and conditions of employment, opportunities for promotion, transfer, layoffs, return from a layoff, training and development, and other privileges of employment. An integral part of Duquesne Light's commitment is to comply with all applicable federal, state and local laws concerning equal employment and affirmative action.