Sr Cloud Data Engineer- Specialist I - Duquesne Light Company

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!

The role of the Senior Cloud Data Engineer 1 is to expand the company’s use of data as a strategic enabler of corporate goals and objectives. The Senior Cloud Data Engineer will achieve this by being a key member of the data platform team and transforming data into code. The ideal candidate is skilled at designing, developing, and implementing data models for data stored in enterprise systems or curated from 3rd parties and providing accessible, continuous availability for business consumers to analyze and gain valuable insights. This individual will act as the technical resource in executing reference architectures developed by the Enterprise or Cloud Data Architects. The position will be responsible for advocating and adhering to software and data best practices and contributing to innovation by adopting and leveraging cloud data technologies to accelerate adoption.

Location: Hybrid, downtown Pittsburgh, Pennsylvania

Responsibilities:

Strategy & Planning

• Execute long-term strategic goals for data architecture vision and standards in conjunction with data users, department managers, clients, and other key stakeholders.
• Develop short-term tactical solutions to achieve long-term objectives and an overall data management roadmap.
• Collaborate with third-parties, product/platform teams and business subject matter experts to enable company strategic imperatives that require secure and accessible data cloud capabilities or assist in accessing data required to enrich models.
• Collaborate with IT Enterprise Architecture, Business Intelligence, Data Engineering, Data Quality and Data Governance stakeholders to:
• Adhere to and advocate for processes for governing the identification, collection, and use of corporate metadata.
• Take steps to assure metadata accuracy and validity.
• Tracking data quality, completeness, redundancy, and improvement.
• Contribute to cloud consumption cost forecasting, optimizations, usage requirements, proof of concepts, proof of business value, feasibility studies, and other tasks.
• Actively participate in the creation of strategies and plans for data security, backup, disaster recovery, business continuity, and archiving.
• Comply with data strategies, architecture best practice to ensure regulatory compliance.

Acquisition & Deployment

• Participate in technical proposals with vendors, cloud providers, and service providers to select the solutions or services that best meet company goals as required.

Operational Management

• Ensure that Data Engineering processes follow best practices for SDLC including proper use of source control, branching strategies, deployment pipelines, and change management.
• Assisting to maintain artifacts that represent the current-state, and future-state, system design as part of the technical roadmap for Data.
• Perform regular peer reviews of code and contribute to the success of all data team members.
• Contribute to and promote data management methodologies and standards.
• Investigate and implement the appropriate tools, software, applications, and systems to support data technology goals.
• Ensure the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.
• Work with project managers and business unit leaders on project assignments involving enterprise data.
• Assist with data-related problems regarding systems integration, compatibility, and multiple-platform integration.
• Develop key components as needed to create testing criteria to guarantee the fidelity and performance of data architecture.
• Update the data architecture and environment to maintain a current and accurate view of the implemented structure.
• Identify and develop opportunities for data reuse, migration, or retirement.
• Contribute to the maintenance of data engineering code by identifying and advocating for paying down tech-debt.
• Must be available for extended hours and on-call as required.
• Storm role as appropriate to the role and skillset

Education/Experience:

Bachelor’s degree in computer science, information systems, or computer engineering.

• In lieu of a bachelor's degree, an equivalent combination of education and experience may be considered.
• Seven (7+) or more years related experience required.
• Five (5+) or more years in a data engineering role preferred.
• Two (2+) or more years' experience as a project or team lead preferred.
• Electric Utility experience preferred.

Technical Knowledge & Experience Utilized in this Role Include:

• Knowledge of data architecture concepts, data mining, large-scale data modeling, cloud data storage, and analytics platforms.
• Experience with Azure, AWS, or Google data capabilities.
• Working experience with one or more cloud data platforms, such as Databricks, Synapse, Foundry, or Snowflake.
• Advanced experience with one or more Cloud Based ELT/ETL services, such as Azure Data Factory or AWS Glue.
• Experience performing data profiling.
• Working knowledge or experience with one or more reporting and/or analytics platforms, such as PowerBI, Tableau, or Looker.
• Direct experience in implementing data solutions in the cloud.
• Experience in deploying infrastructure as code.
• Advanced knowledge of relational data structures, theories, principles, and practices.
• Strong familiarity with metadata management and associated processes.
• Experience with business requirements analysis, entity relationship planning, database design, reporting structures, and so on.
• Ability to work with data owners in support of a data catalog.
• Experience with database management systems, including Oracle RDBMS and SQL Server.
• Understanding of Web services (SOAP, XML, UDDI, WSDL).
• Understanding of object-oriented programming principals
• Excellent client/user interaction skills to determine requirements.
• Project management, Product Management and/or Agile Product Team experience preferred.
• Awareness of applicable data privacy practices and laws.

EQUAL OPPORTUNITY EMPLOYER

Duquesne Light Holdings 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 Holdings' commitment is to comply with all applicable federal, state and local laws concerning equal employment and affirmative action.

Duquesne Light Holdings is committed to offering an inclusive and accessible experience for all job seekers, including individuals with disabilities. Our goal is to foster an inclusive and accessible workplace where everyone has the opportunity to be successful.

If you need a reasonable accommodation to search for a job opening, apply for a position, or participate in the interview process, connect with us at HR@duqlight.com and describe the specific accommodation requested for a disability-related limitation.