IT Engineer Principal II -Data & Analytics

The Principal 2 IT Engineer - Data & Analytics plays a key role in delivering and maintaining the data assets required for enterprise reporting, analytics, automation, and AI initiatives. The role focuses on designing, building, optimizing, and supporting data pipelines, curated datasets, and related data engineering components that serve analysts, data scientists, and business users across the company.

This engineer participates in design, development, testing, deployment, and production support of data solutions, working closely with business analysts, product managers, and technical partners to ensure reliability, quality, and consistent delivery.

Job Responsibilities

• Analyze business and end-user requirements and design, configure, develop, and test the data pipelines, transformations, and data models needed for reporting, analytics, and operational use cases.

• Create, maintain, and optimize data pipelines as workloads move from development into production, ensuring they perform reliably and efficiently.

• Develop and maintain documentation such as data flow diagrams, technical specifications, and process descriptions to support understanding, maintainability, and knowledge transfer.

• Work closely with business analysts, BI developers, data scientists, and other data consumers to refine data needs and ensure solution outputs meet functional expectations.

• Coordinate with enterprise architects, cloud and infrastructure teams, software development teams, and cybersecurity to ensure data engineering solutions align with enterprise standards and integrate appropriately with other technology areas.

• Participate in design reviews and change reviews, offering input to help ensure quality, consistency, and conformance with established engineering practices.

• Provide support for production data pipelines and analytics systems, including troubleshooting issues, implementing fixes, performing proactive maintenance, and conducting root-cause analysis as needed.

• Assist with controlled deployments, upgrades, updates, and enhancements following standard change-management processes and ensuring readiness for production.

• Review existing tools, platforms, and processes to evaluate performance, scalability, and alignment with business needs, making recommendations for improvements when appropriate.

• Contribute to ongoing data management practices, including metadata management, data quality checks, governance adherence, and structured documentation.

• Support continuous improvement of engineering methods, coding standards, automation opportunities, and collaboration practices that strengthen the data engineering discipline.

• Bachelor’s degree in Computer Science or a related technical field.

• 8-12 years of experience delivering technology solutions, preferably with a focus on data engineering, analytics engineering, or data integration.

• Demonstrated leadership through ownership of technical solutions or project components.

• Experience documenting technical solutions, data flows, and system behavior.

• Foundational knowledge of data management practices and familiarity with data warehouse and data lake architectures.

• Strong ability to design, build, and manage data pipelines including transformations, data modeling, metadata, and workload management.

• Experience with AWS and/or Microsoft analytics platforms and related data services.

• Proficiency with SQL, PL/SQL, and experience working with relational and non relational databases.

• Experience supporting DevOps practices such as version control, automated testing, and release processes.

• Experience collaborating with BI and advanced analytics teams and supporting their data needs.

• Experience developing and maintaining ETL/ELT pipelines using tools such as SSIS, AWS Glue, Azure Data Factory, or similar.

• Compliance with the Department of Energy’s regulation 10 CFR 810 is required.

Desired

• Experience supporting machine learning workflows, including feature pipelines or model deployment.

• Familiarity with emerging analytics and AI technologies, including generative AI or retrieval based approaches.

• Experience with data governance, data quality frameworks, or responsible AI practices.

• Exposure to modern data engineering or analytics tools and techniques.

1. Hybrid flexible - roles that are a mix of remote work and onsite work, but the onsite requirements have greater flexibility. (i.e. 5-8 days a month vs. set days each week).

As an employee, if you are regularly scheduled to work 20 or more hours per week, you will have access to a wide range of comprehensive benefits from day one, designed to support your total well-being: medical, dental, vision, parental leave and family leave programs, behavioral health programs, 401(k) with company match, life insurance, tuition reimbursement, and generous paid time off., Some positions at PSEG require access to information covered by the Department of Energy’s regulation 10 CFR 810 (Part 810). If applicable, the successful applicant must prove they are: (1) a citizen or national of the USA; OR (2) a lawful permanent resident of the United States (Non-Conditional Permanent I-551 / Green Card / Permanent Resident Card holder); OR (3) a citizen, national, or permanent resident of a “Generally Authorized” destination on the attached list (https://corporate.pseg.com/-/media/PSEG/Corporate/Careers/Careers At PSEG/AppendixAtoPart810_ Title10) not also a citizen, national, permanent resident of any country not listed; OR (4) a “Protected Individual” under the Immigration and Naturalization Act (8 U.S.C 1324b(a)(3)).

As an employee of PSEG, you should be aware that during emergency restoration efforts, you may be required to perform functions outside of your routine duties and on a schedule that may be different from normal operations.

For all roles, PSEG’s drug and alcohol testing program includes pre-employment testing, testing for cause, and post-incident/accident testing.

Employees who are hired or transfer into a federally regulated role (including positions covered by USDOT, PHMSA, or NRC regulations) are subject to random drug and alcohol testing, inclusive of marijuana. Although numerous states throughout the country have legalized marijuana/cannabis products recreationally and medically, the use of these products are prohibited for employees in federally regulated roles. Please note that the use of CBD products may result in a positive drug test for THC/Marijuana and such use is not a legitimate medical explanation for a positive result.

If you are a current PSEG Long Island (PSEGLI) employee and offered an opportunity with PSEG or any of its subsidiaries other than PSEGLI, you will be treated as a new hire. Please note that as a new hire to PSEG, your benefits will change and generally will be consistent with other similarly situated PSEG new hires. Similarly, for PSEG employees who accept job opportunities with PSEGLI, your benefits will change and generally be consistent with other similarly situated new hires of PSEGLI.

We’re one of the country’s largest energy companies, with a vision of powering a future where people use energy more efficiently and it’s safer and delivered more reliably than ever. We’re also deeply connected to the communities we serve, with more than 13,000 employees working together to support our customers and make a difference every day.

Here, you’ll have the stability and exciting opportunities that come with being a Fortune 500 company - along with a supportive, friendly work environment where your contributions are valued.

We know life isn’t one-size-fits-all, and neither is work. That’s why we offer flexible work options depending on the role.

In support of this model, roles have been categorized into one of three work location categories:

1. Onsite - roles where employees are expected to be onsite daily., More than 13,000 people already call PSEG their work home, taking pride in providing safe, reliable service to millions of customers. If you’re looking for a place where you can build a meaningful career and help power and support our communities, we’d love to welcome you to the team.