Data Engineer

The Data Engineer position at Wyyerd Group LLC focuses on delivering and improving data integration capabilities across ETL/ELT pipelines, databases, and workflow automation. The role is based in Texas and requires hands-on experience building reliable data flows that support reporting and warehouse updates.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines.
• Build and support integrations between internal systems and third-party applications.
• Write, optimize, and troubleshoot complex PostgreSQL queries and database objects.
• Ensure data quality, integrity, and reliability across integrations.
• Monitor, troubleshoot, and optimize existing data pipelines for performance and stability.
• Develop and maintain REST API integrations.
• Create and maintain data workflows using SnapLogic.
• Collaborate with business stakeholders, analysts, and application teams to understand reporting and integration requirements.
• Document data flows, integration processes, and technical solutions.
• Participate in code reviews and contribute to data engineering best practices.
• Expand data warehouse and analytics capabilities.
• Transform program data for use in the reporting warehouse.
• Monitor emails from automation and handle errors when they occur.
• Monitor server performance and identify poorly designed queries that can be optimized.
• Analyze refresh cycles that take too long and implement optimizations to reduce execution time.
• Support database upgrades.
• Prioritize tasks in the work queue.
• Implement required automation to keep the data warehouse up to date with daily, hourly, and real-time data updates.
• Work with external vendors for regulatory (FCC) reporting.

Required Qualifications

• Bachelor’s degree in Computer Science, Data Science, IT, or a related field.
• 5-9 years of hands-on data engineering experience.
• Strong SQL skills.
• PostgreSQL experience.
• Strong database design skills.
• Strong query optimization skills.
• Basic script skills for Linux/MacOS.
• Working knowledge of GIT.
• Working knowledge of AWS.
• Python experience preferred.

Technologies Used

• SQL
• PostgreSQL
• REST API
• SnapLogic
• Linux
• MacOS
• GIT
• AWS
• Python

Location

Onsite in Texas