Senior Data Engineer

Agility Partners; Cincinnati (OH); On-site; USD 85,000 - 115,000; Full time

Job summary

Agility Partners is seeking a Data Engineer in Cincinnati to support a client in the banking industry. This role focuses on building scalable, reliable data systems for analytics and predictive insights. You'll work with modern cloud data platforms and engage with engineers and data scientists.

Key responsibilities include designing data pipelines, optimizing SQL-based models, and collaborating across teams. Qualifications involve a technical degree, strong SQL, and experience with databases like Snowflake and MongoDB.

Qualifications

• Strong experience with relational and non-relational databases.
• Advanced SQL skills with hands-on data modeling experience.
• Experience using dbt for data transformation and pipeline development.

Responsibilities

• Design, build, test, and maintain scalable data pipelines.
• Develop and optimize SQL-based data models using dbt.
• Collaborate to improve data quality and accessibility.

Skills

Relational databases (SQL)

Non-relational databases (NoSQL, MongoDB)

Advanced SQL skills

Data modeling experience

Data pipeline development using dbt

Background in data engineering or backend development

Familiarity with cloud data platforms

Education

Technical degree or equivalent professional experience

Tools

Snowflake

dbt

Hadoop

Power BI

Job description

Agility Partners is seeking a Data Engineer to support a client in the banking industry. This role focuses on building scalable, reliable data systems that enable analytics, reporting, and predictive insights. You’ll work hands‑on with modern cloud data platforms and partner closely with engineers, architects, and data scientists.

Key Responsibilities:

• Design, build, test, and maintain scalable data pipelines and data management systems
• Develop and optimize SQL‑based data models and transformations using dbt
• Build high‑performance analytical solutions and support predictive use cases
• Collaborate with cross‑functional teams to improve data quality, reliability, and accessibility
• Ensure data systems align with business needs and industry best practices

Qualifications:

• Technical degree or equivalent professional experience
• Strong experience with relational and non‑relational databases (SQL, NoSQL, Snowflake, MongoDB, Hadoop, etc.)
• Advanced SQL skills with hands‑on data modeling experience
• Experience using dbt for data transformation and pipeline development
• Background in data engineering or backend development (Java, J2EE, or similar)
• Familiarity with cloud‑based data platforms and modern data architectures
• Nice to have: financial services experience, regulatory reporting, or Power BI

Why You’ll Love This Role:

• Work with modern data tools like Snowflake and dbt in an enterprise environment
• High‑impact role influencing how critical data is structured, governed, and used
• Collaborative team culture with strong partnerships across engineering and analytics
• Exposure to complex, real‑world data challenges within a regulated industry