Job Summary

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.

Pay: $120,000.00 - $145,000.00 per year

Benefits:

401(k)
401(k) matching
Dental insurance
Employee assistance program
Employee discount
Flexible schedule
Flexible spending account
Health insurance
Health savings account
Life insurance
Paid time off
Parental leave
Retirement plan
Vision insurance

People with a criminal record are encouraged to apply

Application Question(s):

Do you have 5+ years of professional experience in data engineering, data architecture, database development, or analytics engineering?
Do you have hands-on experience designing, building, deploying, and maintaining production ETL/ELT data pipelines?
Do you have advanced hands-on experience with SQL and experience with a modern cloud data platform such as Snowflake, Microsoft Fabric, Databricks, Synapse, BigQuery, or Redshift?
Have you personally designed solutions that integrate multiple internal and external data sources, including databases, APIs, files, or third-party platforms, with automated data-quality validation and error handling?

Work Location: Remote

NORTHEAST POWER COORDINATING COUNCIL (NPCC) jobs

RAPA Senior Data Engineer