Hybrid Principal Data & Analytics IT Engineer

PSEG; United States; Hybrid; USD 121,000 - 199,000; Full time

Benefits offered by this job

Benefits from day one

Hybrid work environment

Job summary

PSEG Services Corp. is seeking a Principal 2 IT Engineer - Data & Analytics to design, build, optimize, and maintain data pipelines and curated datasets that support enterprise reporting, analytics, automation, and AI initiatives.

The role collaborates with business analysts, BI developers, data scientists, and product teams to ensure reliable, scalable solutions and to deliver quality outputs across the company.

Qualifications

• Bachelor's degree in Computer Science or a related technical field.
• 8–12 years of experience delivering technology solutions, preferably in data engineering or data analytics.
• Ability to lead technical components and ownership of solutions.
• Experience documenting data flows, system behavior, and technical designs.
• Familiarity with data warehouse and data lake architectures.
• Strong SQL skills and experience with relational and non-relational databases.
• Experience with ETL/ELT tools and data integration platforms (SSIS, AWS Glue, Azure Data Factory).
• Knowledge of DevOps practices including version control, automated testing, and release processes.
• Understanding of data governance, metadata management, and compliance requirements (DOE 10 CFR 810).

Responsibilities

• Analyze requirements and design data pipelines, transformations, and data models for reporting and analytics.
• Create, maintain, and optimize data pipelines as they move to production.
• Document data flows, technical specifications, and process descriptions for maintainability.
• Collaborate with BI, data science, and analytics teams to meet data needs.
• Coordinate with architects, cloud, and cybersecurity teams to align with standards.
• Participate in design reviews and change management processes.
• Provide support for production data pipelines and analytics systems, including root-cause analysis.
• Assist with controlled deployments and production readiness activities.
• Review tools and processes for performance, scalability, and improvements.
• Support data governance, metadata management, and data quality initiatives.
• Foster continuous improvement of engineering practices and automation capabilities.

Skills

Leadership

Documentation

Data pipeline design

Data modeling

Data governance

DevOps practices

BI collaboration

Regulatory compliance awareness

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

AWS

AWS Glue

Azure Data Factory

SSIS

SQL/PL-SQL

Job description

PSEG Services Corp. is seeking a Principal 2 IT Engineer - Data & Analytics to design, build, optimize, and maintain data pipelines and curated datasets that support enterprise reporting, analytics, automation, and AI initiatives.

The role collaborates with business analysts, BI developers, data scientists, and product teams to ensure reliable, scalable solutions and to deliver quality outputs across the company.