Senior Data Engineer
Senior
Azure Data Factory
Business Intelligence
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Factory Azure
Data Integration
Data Modeling
Data Pipeline
Data Platform
Data Visualization
Data Warehouse
Database
Databases
ETL
Fivetran
Microsoft Azure
Microsoft Fabric
Power BI
Reporting and Analytics
REST APIs
Snowflake
SQL
Job Description
Lead enterprise data engineering initiatives for NPCC by designing scalable data pipelines, cloud data platforms, and governed analytics foundations.
Responsibilities
- Design, develop, implement, and maintain enterprise data architecture, scalable data pipelines, and cloud-based data platforms aligned to NPCC business objectives.
- Build and optimize automated ELT/ETL workflows using modern integration technologies including Fivetran, dbt, APIs, and cloud-native services.
- 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.
- Create 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 for business intelligence, operational reporting, executive dashboards, regulatory reporting, and advanced analytics.
- Develop, maintain, 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 support data integrity, accuracy, and reliability.
- Establish and maintain 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 across enterprise data architecture, cloud platforms, analytics capabilities, automation processes, and AI initiatives.
- Support organizational data governance, cybersecurity, and information management using industry best practices for secure and reliable data management.
- Participate in cross-functional projects supporting NPCC strategic initiatives and continuous improvement.
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 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 for 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 across departments.
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 and Health savings account
- Life insurance
- Paid time off
- Parental leave
- Retirement plan
- Vision insurance
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 who can manage multiple priorities in a fast-paced environment
Physical Demands
- Ability to sit for long periods of time
- Ability to communicate verbally and in writing
- Ability to handle long periods of screen time
- Ability to work and travel within the U.S. and travel to Canada
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
Salary: USD 105,000 - 125,000 per year
Minimum experience: 7 years
Education: Bachelor's degree