Data Integration & Pipeline Engineer

Job Summary

The Data Integration & Pipeline Engineer (P3) builds and maintains reliable, scalable data pipelines that power analytics, reporting, and operational systems. This role ensures data flows efficiently across platforms while embedding technical controls for quality, performance, and observability.

Key Responsibilities

• Build and maintain ETL/ELT pipelines for structured and unstructured data
• Integrate APIs, third-party data, and operational systems
• Design and optimize curated (bronze/silver/gold) data layers
• Automate data ingestion, transformation, and orchestration
• Implement monitoring, logging, and observability frameworks
• Ensure scalability, reliability, and performance of pipelines
• Troubleshoot data failures and performance bottlenecks
• Embed validation checks and quality controls within pipelines
• Support MDM integrations and data synchronization processes
• Collaborate with Governance & Quality Engineer to implement steward-defined rules

Qualifications

• Required:
• 5+ years in data engineering
• Strong SQL and programming skills (Python, Scala, etc.)
• Experience building pipelines in cloud data platforms
• Familiarity with CI/CD and DevOps practices for data
• Understanding of data modeling concepts and data warehouse/lakehouse design
• Preferred:
• Experience implementing data quality frameworks, validation rules, and pipeline testing
• Familiarity with metadata management and data catalog platforms (Collibra, Alation, Purview)
• Experience supporting analytics and BI platforms such as Power BI, Tableau, or Looker
• Experience working in agile data teams with strong collaboration between engineering, governance, and analytics

Job Requirements

This is an in-office role, requiring on-site presence in our office a minimum of three days per week with hybrid flexibility of working remotely two days per week, subject to manager and policy approval. Applicants must have current authorization to work for any employer in the United States on a full-time basis without the need for an employment visa now or in the future. Employer visa sponsorship is not available for this role.

About the Role

LRE (Leeward Renewable Energy) is forging an American energy future with integrity, innovation, and positive impact. Born in Texas in 2003, we own and operate over 30 utility-scale wind, solar, and energy storage projects in local communities across the United States, totaling 4 gigawatts (GW) of generating capacity. LRE continues to help meet increased U.S. energy demand through our robust pipeline of new projects every year. Domestic jobs and manufacturing are fundamental to our full-lifecycle approach to projects, along with a long-term ownership model and a company culture dedicated to our community partners and protecting the natural environment.