Senior Data Engineer
Job Description
NORTHEAST POWER COORDINATING COUNCIL (NPCC) is hiring a Senior Data Engineer for a remote role. The position focuses on building and maintaining enterprise-grade data platforms and pipelines that help support NPCC’s business objectives. This is a great fit for engineers who want to work on scalable cloud data architecture, automated ELT/ETL, analytics foundations, and data quality governance, with a benefits package that includes health, retirement, and flexible scheduling.
Responsibilities
- Design, develop, implement, and maintain enterprise data architecture, scalable data pipelines, and cloud-based data platforms aligned to NPCC’s business objectives.
- Develop and optimize automated ELT/ETL workflows using modern integration technologies including Fivetran, dbt, APIs, and cloud-native services.
- Build and maintain enterprise data warehouses, semantic models, and analytical datasets using Snowflake and other modern cloud technologies.
- Integrate and manage data from multiple NPCC departments, including RAPA, System Protection, Compliance Monitoring and Enforcement, Registration, Event Analysis, Corporate Services, Finance, Information Technology, and other business functions.
- Design and maintain integrations with external industry data sources such as NERC applications, ERO Enterprise systems, Regional Entities, ISOs/RTOs, Transmission Owners, Generator Owners, governmental agencies, public data repositories, and other industry partners.
- Create and maintain enterprise data models that support business intelligence, operational reporting, executive dashboards, regulatory reporting, and advanced analytics.
- Develop and optimize Power BI dashboards, reports, and interactive visualizations for organizational performance metrics and executive decision-making.
- Implement automated data quality validation, reconciliation, monitoring, and alerting to protect the integrity, accuracy, and reliability of enterprise data assets.
- Establish and maintain enterprise metadata, data lineage, technical documentation, and data governance standards.
- Partner 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 using industry best practices for secure and reliable data management.
- Participate in cross-functional projects supporting NPCC strategic initiatives and continuous improvement efforts.
Requirements
- 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 using modern integration tools and cloud technologies.
- Experience delivering enterprise reporting and business intelligence solutions using Power BI or similar platforms.
- Excellent verbal, written, and technical communication skills, including the ability to communicate with technical and non-technical audiences.
- Strong analytical, organizational, and problem-solving skills with attention to detail.
- Ability to manage multiple priorities independently while collaborating 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 with enterprise data governance programs, metadata management, and data quality frameworks.
- Knowledge of artificial intelligence, machine learning, and predictive analytics technologies.
Technologies
Fivetran, dbt, APIs, cloud-native services, Snowflake, Power BI, SQL, Python, relational databases, NERC applications, ERO Enterprise systems, ISOs/RTOs, NERC Reliability Standards, Microsoft Fabric, Azure Data Factory, Azure Synapse, Azure Data Lake, REST APIs, Git, Azure DevOps, CI/CD pipelines, artificial intelligence, machine learning
Benefits
- 401(k) and 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
Work Location
Remote
Compensation
USD 105,000 - 125,000 per year