Senior RAPA Data Engineer

Northeast Power Coordinating Council (NPCC); New York (NY); On-site; USD 140,000 - 180,000; Full time

Job summary

NPCC is seeking a RAPA Senior Data Engineer to design, implement, and maintain enterprise data solutions that support data-driven decision making. You will build scalable data pipelines, cloud-based platforms, and analytical datasets enabling reliable access to information for Reliability Assessments, performance analysis, and organizational reporting.

You will collaborate with multiple departments to integrate data from diverse sources, manage metadata and governance, and deliver BI insights

Qualifications

• Bachelor's degree in a technical field.
• 7+ years of data engineering/analytics experience.
• Experience designing enterprise data platforms.
• Strong SQL, Python, and data warehousing skills.
• Experience with ELT/ETL tools and cloud tech.
• Experience building BI solutions using Power BI.

Responsibilities

• Design and maintain enterprise data architecture and scalable pipelines.
• Develop ELT/ETL processes with modern tools (Fivetran, dbt).
• Build data warehouses and semantic models using Snowflake.
• Integrate data from multiple internal departments and external sources.
• Create and optimize Power BI dashboards and reports.
• Establish data governance, metadata, and data quality practices.

Skills

SQL

Python

Data modeling

ETL/ELT pipelines

Analytical thinking

Education

Bachelor's degree

Tools

Snowflake

dbt

Fivetran

Azure Data Factory

Power BI

Job description

Position Summary

As the RAPA Senior Data Engineer, you are responsible for designing, developing, implementing, and maintaining enterprise data solutions that support data‑driven decision making across NPCC. This position develops modern data architecture, scalable data pipelines, cloud‑based data platforms, and analytical datasets that enable reliable, secure, and efficient access to information supporting Reliability Assessments and Performance Analysis (RAPA), organizational reporting, operational analytics, and strategic initiatives. The RAPA Senior Data Engineer works closely with internal departments and external stakeholders to integrate, manage, and optimize data from a wide variety of sources, transforming complex datasets into trusted enterprise data assets. The position supports the NPCC commitment to promoting the reliable and efficient planning and operation of the international interconnected Bulk Power System through the application of modern data engineering, automation, cloud technologies, and business intelligence solutions.

Key Responsibilities

• Design, develop, implement, and maintain enterprise data architecture, scalable data pipelines, and cloud-based data platforms supporting NPCC's business objectives.
• Develop and optimize automated ELT/ETL processes utilizing modern data integration technologies such as Fivetran, dbt, APIs, and cloud-native services.
• Design, develop, and maintain enterprise data warehouses, semantic models, and analytical datasets using Snowflake and other modern cloud technologies.
• Integrate and manage data from multiple internal NPCC departments, including Reliability Assessments and Performance Analysis (RAPA), System Protection, Compliance Monitoring and Enforcement, Registration, Event Analysis, Corporate Services, Finance, Information Technology, and other business functions.
• Develop and maintain integrations with external industry data sources, including NERC applications, ERO Enterprise systems, Regional Entities, ISOs/RTOs, Transmission Owners, Generator Owners, governmental agencies, public data repositories, and other industry partners.
• Design and implement enterprise data models supporting business intelligence, operational reporting, executive dashboards, regulatory reporting, and advanced analytics.
• Develop, maintain, and optimize Power BI dashboards, reports, and interactive visualizations supporting organizational performance metrics and executive decision‑making.
• Develop automated data quality validation, reconciliation, monitoring, and alerting processes to ensure the integrity, accuracy, and reliability of enterprise data assets.
• Establish and maintain enterprise metadata, data lineage, technical documentation, and data governance standards.
• Collaborate with subject matter experts to translate business requirements into scalable technical solutions and reusable enterprise data products.
• Evaluate emerging technologies and recommend improvements to NPCC's enterprise data architecture, cloud platforms, analytics capabilities, automation processes, and AI initiatives.
• Support organizational data governance, cybersecurity, and information management initiatives by implementing industry best practices for secure and reliable data management.
• Participate in cross-functional projects supporting NPCC strategic initiatives and continuous improvement efforts.

Required Qualifications

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, Computer Engineering, Electrical Engineering, Mathematics, Statistics, Data Analytics, or a related technical discipline.
• Minimum of seven (7) years of progressively responsible experience in data engineering, database development, enterprise data architecture, cloud data platforms, business intelligence, or analytics engineering.
• Demonstrated experience designing and supporting enterprise‑scale data platforms and automated data integration solutions.
• Strong proficiency with SQL, Python, relational databases, and cloud-based data warehouse technologies.
• Experience developing and maintaining ELT/ETL pipelines utilizing modern integration tools and cloud technologies.
• Experience developing enterprise reporting and business intelligence solutions using Power BI or similar platforms.
• Excellent verbal, written, and technical communication skills with the ability to communicate effectively with technical and non‑technical audiences.
• Demonstrated analytical, organizational, and problem‑solving skills with strong attention to detail.
• Ability to manage multiple priorities independently while collaborating effectively across departments.

Preferred Qualifications

• Experience within the electric utility, electric reliability, transmission, generation, or energy industry.
• Familiarity with NERC Reliability Standards, Regional Entity functions, and electric system operations.
• Experience with modern cloud technologies including Snowflake, Microsoft Fabric, Azure Data Factory, Azure Synapse, Azure Data Lake, dbt, and Fivetran.
• Experience with REST APIs, Git, Azure DevOps, CI/CD pipelines, and data automation frameworks.
• Experience developing enterprise data governance programs, metadata management, and data quality frameworks.
• Knowledge of artificial intelligence, machine learning, and predictive analytics technologies.

Skills And Abilities

• Excellent verbal and written communication skills.
• Excellent interpersonal and conflict resolution skills.
• Excellent organizational skills and attention to detail.
• Strong analytical and problem‑solving skills.
• Strong supervisory and leadership skills.
• Proficient with Microsoft Office Suite or related software.
• Self‑starter with the ability to contribute to multiple priorities, multitask effectively, and prioritize work in a fast‑paced environment.

Physical Demands

• Ability to sit for long periods of time, ability to communicate verbally, and in writing, and ability to handle long periods of screen time.
• Ability to work and travel within the U.S. and travel to Canada.

EEOC and Disclaimer

NPCC is an Equal Opportunity Employer. Employment, including the decision to hire, promote, discipline or discharge, will be solely based on competence, performance, and business needs. We prohibit discrimination on the basis of the individual’s actual or perceived disability, protected veteran status, race, color, sex, age, national origin, religion, sexual orientation, gender, gender identity, gender expression, genetic information, marital status, citizenship, domestic violence victim status, or any other status protected under federal, state or local law. This job description is not intended to be all‑inclusive, and the employee will also perform other reasonably related business duties as assigned by immediate supervisor and other management as required. This job description does not constitute a written or implied contract of employment.