Senior Data Engineer/ Data Engineer

Dominion Energy
Richmond, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Shift work
Languages
English
Experience level
Senior
Compensation
$ 118K

Job location

Remote
Richmond, United States of America

Tech stack

Sql Data Warehouse
API
Artificial Intelligence
Amazon Web Services (AWS)
Data analysis
Azure
Cloud Computing
Cloud Database
Databases
Data Architecture
Data Validation
Information Engineering
Data Integration
Data Integrity
ETL
Data Mining
Data Systems
Data Warehousing
Relational Databases
Database Storage Structures
Python
Team Foundation Server
Performance Tuning
Query Optimization
Standard Sql
DataOps
Shell Script
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Talend
Data Processing
Scripting (Bash/Python/Go/Ruby)
Data Ingestion
Sql Optimization
Snowflake
GIT
Information Technology
Collibra
Apache Flink
Kafka
Spark Streaming
Data Management
Software Version Control
Data Pipelines

Job description

Dominion Energy is committed to providing reliable, affordable, and increasingly clean energy that powers our customers every day. If you want to work for a purpose-driven company that values safety and collaboration, we're looking for you. You won't just find a job here; you'll find your career. Review the position below and apply today.

We offer a hybrid work schedule (one week in the office, one week of teleworking) to accommodate the need for flexibility.

Military service members and veterans with ranks from E5-E9, W1-CW5, or O3-O6, plus appropriate equivalent combination of education and years of experience as outlined below will be considered for this opportunity.

At this time, Dominion Energy cannot transfer or sponsor a work visa or employment authorization for this position., The Senior Data Engineer and Data Engineer is responsible for designing, building, maintaining, and optimizing data solutions that collect, store, process, and make data accessible for analytics, reporting, and business decision-making. This role works closely with Data Product Owners, business stakeholders, analysts, and technical teams to develop scalable data pipelines, support data integration initiatives, and ensure the reliability, quality, and performance of enterprise data assets.

Responsibilities include designing and maintaining ETL/ELT processes, ingesting data from various sources including APIs, databases, and flat files, transforming and validating data, and developing efficient SQL queries, stored procedures, and database structures. The Data Engineer supports the implementation of data product backlog items, assists in troubleshooting and resolving data quality and performance issues, and contributes to the development and optimization of cloud-based data warehouse solutions.

Depending on experience level, the role may involve leading complex data engineering initiatives, optimizing data warehouse performance, mentoring junior team members, and driving best practices in data architecture, data modeling, and data integration. The ideal candidate is analytical, quality-focused, and capable of working collaboratively across teams to deliver scalable, reliable, and high-performing data solutions that support organizational goals., * Implement features and enhancements from the data product backlog.

  • Partner with Data Product Owners and business stakeholders to understand business and technical requirements.
  • Assist in building and maintaining scalable ETL/ELT pipelines.
  • Support data ingestion from APIs, relational databases, and flat files.
  • Clean, transform, and validate data to ensure quality and consistency.
  • Develop and optimize SQL queries for reporting and data extraction.
  • Collaborate with data analysts and data scientists to meet analytical requirements.
  • Monitor data workflows and troubleshoot data pipeline issues.
  • Maintain documentation for data processes and technical solutions.
  • Follow data engineering best practices and standards.
  • Learn from and collaborate with senior engineers on enterprise initiatives.
  • Perform ad hoc data analysis and queries to support business needs., * Design and develop scalable ETL/ELT solutions and enterprise data pipelines.
  • Build and optimize data integration processes using Talend and related technologies.
  • Design efficient database structures and implement data modeling best practices.
  • Optimize SQL queries, stored procedures, and data loading performance.
  • Develop and maintain Snowflake cloud data warehouse solutions.
  • Collaborate with business and technical teams to define data requirements and solutions.
  • Troubleshoot and resolve complex data quality and performance issues.
  • Support modernization initiatives involving cloud technologies and data platforms.
  • Mentor junior team members and promote engineering best practices.
  • Ensure data reliability, scalability, and operational excellence.., * Delivering at Pace: Acts with urgency to meet deadlines while maintaining quality, prioritizing workload effectively under pressure.
  • Collaborative Teamwork: Actively supports colleagues, shares knowledge freely, and treats others with dignity and respect.
  • Effective Communication: Tailors communication style to the audience, ensuring clarity and transparency in both successes and challenges.
  • Ownership and Adaptability: Takes responsibility for outcomes and welcomes feedback for improvement.
  • Ability to work independently
  • Achievement orientation
  • Self-starter
  • Concern for quality
  • Flexibility

Requirements

  • 2+ years of relevant experience.
  • Understanding of Relational Database Management Systems (RDBMS).
  • Knowledge of data warehousing concepts, including star and snowflake schemas.
  • Familiarity with version control systems such as Git or TFS.
  • Understanding of data modeling principles.
  • Exposure to ETL tools such as Talend, Informatica, or SSIS.
  • Working knowledge of SQL, stored procedures, and database table design.
  • Familiarity with scripting languages such as Python, Shell scripting., * 5+ years of data engineering experience.
  • Extensive experience with Talend ETL.
  • Advanced SQL skills, including:
  • Stored procedures
  • Database and table design
  • Query optimization
  • ETL performance tuning
  • Strong experience with Snowflake Cloud Data Warehouse.
  • Proficient in SQL for data manipulation, transformation, and querying within Snowflake.
  • Experience with scripting languages such as Python or Shell scripting.
  • Strong analytical and problem-solving skills with the ability to identify patterns and resolve data quality issues.
  • Demonstrated ability to work independently in a fast-paced environment.
  • Strong focus on quality, accountability, flexibility, and achievement of results., * Experience supporting AI/ML or advanced analytics pipelines.
  • Cloud platform experience (AWS, Azure, or GCP).
  • Prior experience influencing enterprise data standards or reference architecture.
  • Experience optimizing cost and performance in cloud data warehouses.
  • Hands-on experience with Cribl, Apache Kafka, Kafka Connect, Spark Streaming, or Apache Flink
  • Experience Data catalog platforms (e.g., Collibra, Informatica IDMC, Alation)
  • Experience with Data Observability Platforms (e.g., Monte Carlo, Data dog, Atlan)

Education Requirements

Education Level:

Degree or an equivalent combination of education and demonstrated related experience may be accepted in lieu of preferred level of education:

Bachelor

Preferred Discipline(s): Computer Science, Information Technology

Other disciplines may be substituted for the preferred discipline(s) listed above.

Benefits & conditions

Certain positions at Dominion Energy may involve access to information and technology subject to export controls under U.S. law. Compliance with these export controls may result in Dominion Energy limiting its consideration of certain applicants.

What You'll Get

Expected Hiring Base Salary Range:

Senior Data Engineer $90900 - $118100

Data Engineer $81,900- $106,400

The expected hiring base salary range is the range we anticipate hiring within for this position. The actual salary offered may vary based on factors such as the selected candidate's qualifications, skills, experience, and work location. This is not intended to represent the full salary range for the position or limit future compensation growth.

At Dominion Energy, we offer excellent plans and programs for employees. Employees are rewarded with a competitive salary and comprehensive benefits package which includes: health, dental, and vision benefits with coverage for families and domestic partners, vacation, retirement plans including 401k contributions and matches, paid holidays, tuition reimbursement, bonus eligibility, sick leave, and disability insurance. To learn more about our benefits, click here:

Dominion Energy is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin and/or status as a protected veteran or individual with a disability.

You can experience the excitement of our company - it's the difference between taking a job and starting a career.

About the company

There are many reasons to work at Dominion Energy, but below are the top three reasons employees have shared with us. Click on each of the links to learn more! About Dominion Energy I am your warm cup of coffee in the morning and I light your home at night. I am the cool breeze from your A/C on the hottest day in summer, and the red coil that heats your soup pot on a frigid winter's day. I am sustainable, reliable and affordable. I am not just any energy… I am Dominion Energy. We're transforming the way we do business to build a more sustainable future for the planet, our customers, our team and our industry. We're shaping the future of energy in America. Join us! Facts: ·17,000 employees ·Headquarters: Richmond, VA ·16 states in the US ·$100 billion of assets ·Nearly $35 million in charitable contributions ·100,000+ volunteer hours recorded in the community Our Commitment to NetZero by 2050 Dominion Energy is committed to helping address climate change. We have cut emissions sharply as we aim for Net Zero carbon and methane emissions by 2050. Learn more at. Nearest Major Market: Richmond Job Segment: Database, SQL, Data Warehouse, Computer Science, Engineer, Technology, Engineering

Apply for this position