← back to jobs
> job detail
P
👽Other

IT Engineer Principal II -Data & Analytics (Newark, NJ, US, 07101)

PSEG · Newark, NJ, US, 07101
// classified as
Other (Adjacent or hard to classify.)
posted
1d ago
location
Newark, NJ, US, 07101
languages
sql
tools
aws, azure
> stack
sqlawsazure
> description
<p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black"><strong>Requisition:</strong> 83756</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black"> </span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black"><strong>PSEG Company:</strong> PSEG Services Corp.</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black"> </span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black"><strong>Salary Range:</strong> $ 121,200 - $ 199,200</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black"><strong> </strong></span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black"><strong>Work Location Category:</strong> Hybrid Flexible</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black"> </span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">We’re one of the country’s largest energy companies, <span style="color:black">with a vision of powering a future where people use energy more efficiently and it’s safer and delivered more reliably than ever.</span> 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.</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">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.</span></p> <p> </p> <p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">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.</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">In support of this model, roles have been categorized into one of three work location categories:</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">1. Onsite – roles where employees are expected to be onsite daily.</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">2. Hybrid fixed – roles that are a mix of remote work and onsite work fixed days each week </span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">3. 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).</span></p> <p> </p> <p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">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.</span></p> <p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">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.</span></p> <p> </p> <p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif;color:black">PSEG is not offering visa sponsorship for this position.</span></p> <p> </p><div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Job Summary</b></H2> </div><div><p><span style="font-family:verdana, geneva, sans-serif">The Principal 2 IT Engineer – Data &amp; 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.</span></p> <p><span style="font-family:verdana, geneva, sans-serif">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.</span></p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Job Responsibilities</b></H2> </div><div><ul> <li><span style="font-family:verdana, geneva, sans-serif">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.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Create, maintain, and optimize data pipelines as workloads move from development into production, ensuring they perform reliably and efficiently.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Develop and maintain documentation such as data flow diagrams, technical specifications, and process descriptions to support understanding, maintainability, and knowledge transfer.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Work closely with business analysts, BI developers, data scientists, and other data consumers to refine data needs and ensure solution outputs meet functional expectations.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">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.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Participate in design reviews and change reviews, offering input to help ensure quality, consistency, and conformance with established engineering practices.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Provide support for production data pipelines and analytics systems, including troubleshooting issues, implementing fixes, performing proactive maintenance, and conducting root‑cause analysis as needed.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Assist with controlled deployments, upgrades, updates, and enhancements following standard change‑management processes and ensuring readiness for production.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Review existing tools, platforms, and processes to evaluate performance, scalability, and alignment with business needs, making recommendations for improvements when appropriate.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Contribute to ongoing data management practices, including metadata management, data quality checks, governance adherence, and structured documentation.</span></li> <li><span style="font-family:verdana, geneva, sans-serif">Support continuous improvement of engineering methods, coding standards, automation opportunities, and collaboration practices that strengthen the data engineering discipline.</span></li> </ul></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Job Specific Qualifications</b></H2> </div><div><ul> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Bachelor’s degree in Computer Science or a related technical field.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">8–12 years of experience delivering technology solutions, preferably with a focus on data engineering, analytics engineering, or data integration.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Demonstrated leadership through ownership of technical solutions or project components.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience documenting technical solutions, data flows, and system behavior.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Foundational knowledge of data management practices and familiarity with data warehouse and data lake architectures.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Strong ability to design, build, and manage data pipelines including transformations, data modeling, metadata, and workload management.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience with AWS and/or Microsoft analytics platforms and related data services.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Proficiency with SQL, PL/SQL, and experience working with relational and non‑relational databases.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience supporting DevOps practices such as version control, automated testing, and release processes.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience collaborating with BI and advanced analytics teams and supporting their data needs.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience developing and maintaining ETL/ELT pipelines using tools such as SSIS, AWS Glue, Azure Data Factory, or similar.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Compliance with the Department of Energy's regulation 10 CFR 810 is required.<br><br></span></li> </ul> <p style="font-family:verdana, geneva, sans-serif"><strong><span style="font-family:verdana, geneva, sans-serif">Desired Education and Experience:</span></strong></p> <ul> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience supporting machine learning workflows, including feature pipelines or model deployment.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Familiarity with emerging analytics and AI technologies, including generative AI or retrieval‑based approaches.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience with data governance, data quality frameworks, or responsible AI practices.</span></li> <li style="font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Exposure to modern data engineering or analytics tools and techniques.</span></li> </ul></div></div></div><p> </p> <p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">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 <a href="https://corporate.pseg.com/-/media/PSEG/Corporate/Careers/Careers At PSEG/AppendixAtoPart810_ Title10" target="_self">attached list</a> 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)).</span></p> <p> </p> <p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">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. </span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">For all roles, PSEG’s drug and alcohol testing program includes pre-employment testing, testing for cause, and post-incident/accident testing. </span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">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.</span></p> <p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">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. </span></p> <p> </p> <p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">PSEG is an equal opportunity employer, dedicated to a policy of non-discrimination in employment, including the hiring process, based on any legally protected characteristic. Legally protected characteristics include race, color, religion, national origin, sex, age, marital status, sexual orientation, disability or veteran status or any other characteristic protected by federal, state, or local law in locations where PSEG employs individuals. </span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">PSEG is committed to providing reasonable accommodations to individuals with disabilities. If you have a disability and need assistance applying for a position, please call 973-430-3845 or email accommodations@pseg.com.</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">If you need to request a reasonable accommodation to perform the essential functions of the job, email accommodations@pseg.com.  Any information provided regarding a disability will be kept strictly confidential and will not be shared with anyone involved in making a hiring decision.</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">ADDITIONAL EEO INFORMATION (Click link below)</span><br><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif"><a title="" href="https://corporate.pseg.com/-/media/PSEG/Corporate/Careers/Careers At PSEG/EEOC_KnowYourRights" target="_self">Know your Rights: Workplace Discrimination is Illegal</a></span></p>