Data Engineer I-SR
Aws Data Engineer
Azure Data Engineer
Business Intelligence
Cloud Data Engineering
Data
Data Architecture
Data Engineer
Data Engineering
Data Integration
Data Pipeline
Data Processing
Data Warehouse
Database
Databases
ETL
Gcp Data Engineer
Integration
Programming Language
Programming Languages
Reporting and Analytics
SQL
Job Description
Data Engineer I-SR role at Entergy Corporation in The Woodlands, TX (hybrid), focused on building and maintaining reliable data infrastructure and pipelines for analytics and AI-enabled decision-making.
Responsibilities
- Design and implement robust, scalable ETL/ELT pipelines to ingest, transform, and load data from multiple sources into a single source of truth for decision support and process optimization.
- Design and implement data snapshot capturing and management.
- Architect queries for data lakes and relational databases; optimize query performance and indexing; synthesize complex datasets into user-friendly datasets.
- Build connectors and integration workflows to consolidate data across disparate systems and APIs; support enabling usage of dark data to increase value from all data.
- Design and implement data processing modules to improve data quality, link disparate data sources, and add value to data.
- Design, construct, and maintain applications that enable data correction, manipulation, and processing; create data tools supporting analytics and data science teams to build and optimize products.
- Design, construct, and maintain automations such as condition/routine emails and job scheduling.
- Define data quality standards, validation rules, and documentation; apply best practices in data governance, quality, storage, and manipulation.
- Regularly evaluate data sources and methodologies to ensure data integrity and identify patterns or insights.
- Ensure data is secure and compliant with all Federal, state, local requirements and Entergy policies.
- Administer business team virtual servers and manage schema within data lakes.
- Partner with AI developers, data analysts, scientists, and business stakeholders to understand requirements and deliver solutions; contribute to the analytics roadmap.
- Provide actionable insights into operational efficiency, reliability, and other key business performance metrics.
- Create comprehensive documentation and unit/integration tests for pipelines and systems through end user views.
- Maintain availability for additional hours and duties tied to storms, outages, emergencies, or other situations as needed by Entergy.
Requirements
- Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field.
- 3+ years professional experience as a Data Engineer or in a closely related role.
- 3+ years developing ETL pipelines using Apache Airflow, Microsoft SQL Server Integration Services, and Python; familiarity with Google BigQuery and Snowflake.
- Strong proficiency in Apache Airflow, Python, SQL, and PowerBI.
- Solid understanding of relational and SQL databases, specifically MS SQL Server.
- Experience with cloud platforms (AWS, Azure, GCP) and associated data services.
- Familiarity with data warehouse technologies (Snowflake/Redshift).
- Strong problem-solving skills and attention to detail.
- Ability to create and sustain a safe working environment by identifying and mitigating safety hazards.
- Ability to develop and maintain process and technical documentation.
- Foundational knowledge in change management and continuous improvement frameworks.
Technologies
- Apache Airflow
- Microsoft SQL Server Integration Services
- Python
- Google BigQuery
- Snowflake
- SQL
- PowerBI
- MS SQL Server
- AWS
- Azure
- GCP
- Redshift
- ETL
- ELT
Preferred Qualifications
- At least 4 years developing and utilizing tools that prepare, extract, and manipulate (big) data to create connected datasets (data lake) for analytics purposes.
- Proficiency with data orchestration and workflow tools.
- Experience with Alation and Jira.
- Experience with real-time data processing.
- Familiarity with Entergy Work Practices and Processes.
- Deep expertise applying project management principles to ensure systematic, thorough completion of assignments, identifying critical pathways and risks to delivery.
- Deep expertise leading data/information analyses to assist the business in decision making; provide business insights and data trends through detailed reports.
Working Conditions
- Full-time position
- Hybrid work arrangement
- Occasional travel may be required (up to 25%)
- Relocation: No Relocation Offered
- Primary location: Texas - The Woodlands (hybrid)
- Additional potential locations: Arkansas - Little Rock, Louisiana - New Orleans, Mississippi - Jackson
- Job function: Corporate
- FLSA status: Professional
- Union: NON BARGAINING UNIT
- Number of openings: 1
- Req ID: 125603
- PS Job title: Data Engineer II
Similar Jobs
C