Senior Data Engineer: AI-Driven Analytics & Data Pipelines

Aquent; Boncarbo (CO); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Health benefits

Retirement match

Professional training

Job summary

Aquent is partnering with a leading financial services organization to hire a Data Engineer who will design, build, and maintain scalable data infrastructure powering analytics and AI-enabled capabilities. The role emphasizes data foundations for advanced analytics, robust pipelines, and production-grade data products.

You will work with cloud platforms, REST APIs, and analytical data models to transform raw data into trusted insights for reporting and decision making, while ensuring data

Qualifications

• Experience in data engineering, analytics engineering, or a related technical field.
• Advanced SQL skills with ability to write complex queries from scratch.
• Proficiency in Python for API integration, data extraction, automation, and transformation.
• Hands-on experience designing and building data pipelines and analytical data models.
• Experience integrating data from REST APIs or other third-party interfaces.

Responsibilities

• Design and build scalable data marts and automated pipelines within a leading cloud platform.
• Develop automated pipelines that ingest data from third-party vendor APIs.
• Utilize Python to create reusable API integrations, extraction processes, and data-transformation components.
• Manage API authentication, pagination, response processing, error handling, and logging for robust data ingestion.
• Create well-structured analytical data models that support reporting and AI use cases.
• Write complex SQL to transform, integrate, validate, and prepare datasets.

Skills

Advanced SQL

Python

Data pipelines

REST APIs

Data modeling

Documentation

Collaboration

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

dbt

DuckDB

Tableau

Power BI

Looker

Job description

Aquent is partnering with a leading financial services organization to hire a Data Engineer who will design, build, and maintain scalable data infrastructure powering analytics and AI-enabled capabilities. The role emphasizes data foundations for advanced analytics, robust pipelines, and production-grade data products.

You will work with cloud platforms, REST APIs, and analytical data models to transform raw data into trusted insights for reporting and decision making, while ensuring data