Data Engineer: ETL/ELT, API & Data Warehouse

Wyyerd Group; Boulder (CO); On-site; USD 110,000 - 150,000; Full time

Job summary

Wyyerd Group is seeking a Data Engineer to build, maintain, and optimize data integration solutions. The role may be filled at mid or senior level based on experience and expertise.

Ideal candidate will have a strong foundation in SQL, data integration, and API-based development across ETL/ELT processes. Responsibilities include designing ETL/ELT pipelines, API integrations, data quality, and collaborating with stakeholders to meet reporting needs.

Qualifications

• Bachelor’s degree in CS, Data Science, IT, or related field.
• 5-9 years of hands‑on data engineering experience.
• Strong foundation in SQL, data integration, and API-based development.

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.
• 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 best practices for data engineering.
• Expand data warehouse and analytics capabilities
• Transform program data for use in reporting warehouse
• Monitor emails from automation and handle errors when they happen
• Identify poorly designed queries that can be optimized.
• Analyze refresh cycles that take too long and implement optimizations to reduce execution time.
• Prioritize tasks in work queue
• Manage and implement the necessary automation to ensure the data warehouse is kept up to date, including daily, hourly, and real-time data updates.
• Work with external vendors for regulatory (FCC) reporting

Skills

SQL

Data integration

API development

ETL/ELT

PostgreSQL

Education

Bachelor's degree in Computer Science, Data Science, IT, or related field

Tools

SnapLogic

Job description

Wyyerd Group is seeking a Data Engineer to build, maintain, and optimize data integration solutions. The role may be filled at mid or senior level based on experience and expertise.

Ideal candidate will have a strong foundation in SQL, data integration, and API-based development across ETL/ELT processes. Responsibilities include designing ETL/ELT pipelines, API integrations, data quality, and collaborating with stakeholders to meet reporting needs.