Data Engineer I-SR
Job Description
Entergy Corporation is hiring a Data Engineer I-SR for a full-time hybrid role based in The Woodlands, TX, supporting corporate data initiatives that improve decision-making and operational performance. In this position, you will design, build, and maintain data infrastructure and pipelines, partnering with IT, Analytics, and the AI team to ingest and optimize data with a focus on reliability, quality, performance, and accessibility.
What you’ll do
- Design and implement robust, scalable ETL/ELT pipelines to ingest, transform, and load data from multiple sources to support a single source of truth.
- Build data snapshot capturing and management.
- Architect queries in data lakes and relational databases, optimizing queries and indexing for performance and creating user-friendly datasets from complex data.
- Create connectors and integration workflows to consolidate data across disparate systems and APIs, with an emphasis on enabling usage of dark data to increase value.
- Design data processing modules to improve data quality, link disparate data sources, and add value to datasets.
- Design, construct, and maintain data tooling and applications that support data correction, manipulation, and processing, enabling analytics and data science teams to build and optimize product capabilities.
- Implement automations such as condition or routine emails and job scheduling.
- Define data quality standards, validation rules, and documentation; apply best practices in governance, quality, storage, and manipulation; regularly evaluate data sources and methodologies to maintain integrity and surface patterns or insights.
- Ensure data security and compliance with all Federal, state, local requirements and Entergy policies.
- Administer business team virtual servers and manage schemas within data lakes.
- Partner with AI developers, data analysts, data scientists, and business stakeholders to understand requirements and deliver solutions, including contributing to the analytics roadmap.
- Provide actionable insights into operational efficiency, reliability, and other key business performance metrics.
- Create comprehensive documentation plus unit and integration tests for data pipelines and systems through end-user views.
Required qualifications
- Bachelor’s degree in Computer Science, Engineering, Mathematics, or a related field.
- 3+ years of 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, with familiarity in big data or cloud databases such as Google BigQuery and Snowflake.
- Strong proficiency in Apache Airflow, Python, SQL, and PowerBI.
- Solid understanding of relational databases and SQL, specifically MS SQL Server.
- Experience with cloud platforms including AWS, Azure, and GCP and associated data services.
- Familiarity with data warehouse technologies such as Snowflake and Redshift.
- Strong problem-solving skills with 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 of change management and continuous improvement frameworks.
Technologies you’ll work with
- Apache Airflow
- Microsoft SQL Server Integration Services (SSIS)
- Python
- Google BigQuery
- Snowflake
- SQL
- PowerBI
- MS SQL Server
- AWS, Azure, GCP
- Redshift
- ETL, ELT
Preferred qualifications
- At least 4 years developing and using tools to prepare, extract, and manipulate data to create connected datasets (data lakes) for analytics.
- 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 support systematic, thorough completion of assignments, including identifying critical pathways and risks.
- Deep expertise leading development of data and information analyses to support business decision-making, including reports for business insights and data trends.
Working conditions
- Full-time position
- Hybrid work arrangement
- Occasional travel may be required; travel percentage up to 25%
- Relocation: no relocation offered
Additional note: As an essential services provider, Entergy expects employees to be available to work additional hours, work in alternate locations, and/or perform additional duties in connection with storms, outages, emergencies, or other situations deemed necessary by the company. Exempt employees may not be paid overtime associated with such duties.
Job details: 1 opening, REQ ID 125603, PS Job Title: Data Engineer II, FLSA Status: Professional, Union: NON BARGAINING UNIT, Job function: Corporate, Primary location includes Texas (The Woodlands), with other listed locations: Little Rock (AR), New Orleans (LA), Jackson (MS).