Senior Programmer Analyst - Data Engineer
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.
This position does not offer relocation assistance.
Job Summary As a core member of team of Data Engineers/ETL Developers, responsibilities include but not limited to:
- Design, Develop and maintain secure, consistent and reliable ETL solutions supporting critical business processes across the various Business Units.
- Ensure data solutions are compliant with enterprise security standards
- Work in complex multi-platform environments on multiple project assignments.
- Develop and perform tests and validate data flows and prepare ETL processes to meet complex business requirements, including designing and implementing of complex end-to-end solutions using BI platforms.
- Coordinate with analysts and developers to ensure jobs designed and developed meet minimum support standards and best practices before migration into the production environment.
- Partner with various infrastructure teams, application teams, and architects to generate process designs and complex transformations to various data elements to provide the Business with insights into their business processes.
- Uses strategies such as Indexing and partitioning to fine tune the data warehouse and big data environments to improve the query response time and scalability.
- Define and capture metadata and rules associated with ETL processes.
- Assist production support team in providing resolutions to production job failures, data issues and performance tuning
ETL Development and Process Support, may require weekend/off business hours work.
Required Knowledge, Skills, Abilities & Experience 7+ years directly related experience in programming or systems analysis.
- Strong understanding of Data warehousing (Dimensional Modeling, ETL etc.) and RDBMS concepts
- Minimum 5 years working experience with Talend ETL tool
- Minimum 5 years working experience in SQL, Stored Procedures and Table Design
- Minimum 5 years working experience in SQL Query optimization and ETL Data loading Performance
- Minimum 3 years working experience in as a Data Engineer in Hadoop Platforms on components like HIVE, KAFKA, NiFi, Spark etc is a big plus.
- Minimum 2 years working experience in Snowflake Cloud Data warehouse
- Minimum 2 years working experience in shell scripting
- Experience in real time streaming technologies is preferred
- Experience deploying machine learning models and automating processes in production is a plus
- Experience with cloud technologies (AWS, Azure, GCP) is big plus
Education Requirements 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): Business, Computer Engineering, Computer Science, Information Systems, Mathematics
Other disciplines may be substituted for the preferred discipline(s) listed above.
Licenses, Certifications, or Quals Description Working Conditions Office Work Environment 76 -100%
Travel Up to 25%
Other Working Conditions Test Description No Testing Required
Export Control 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.
Other Information We offer excellent plans and programs for employees. Employees are rewarded with a competitive salary and comprehensive benefits package which may include: health benefits with coverage for families and domestic partners, vacation, retirement plans, paid holidays, tuition reimbursement, and much more. 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.
Top 3 Reasons to Work at Dominion Energy 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: Data Warehouse, Systems Analyst, Information Systems, Programmer, Database, Technology