Senior Credit Analytics Engineer

Aqua Finance, Inc.; Northern (KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Aqua Finance, Inc. seeks a Senior Credit Analytics Engineer to design and maintain analytics-ready datasets for underwriting, pricing, originations, and portfolio analytics.

You will build scalable data workflows and reusable SQL assets while partnering with Data Engineering, IT, and Operations to ensure data quality and governance. Responsibilities include developing reporting assets with Power BI or Sigma, establishing best practices, and documenting data products for analysts and leaders.

Qualifications

• Bachelor's degree in a quantitative field or commensurate work experience.
• 5 years of analytics engineering/data engineering/BI/advanced analytics experience required.
• Advanced SQL proficiency; experience with Python, dbt, and Git required.
• Experience building analytics-ready datasets across multiple systems.
• Snowflake experience preferred; Power BI or Sigma reporting experience preferred.

Responsibilities

• Design, develop, and maintain analytics-ready datasets supporting underwriting, credit risk, pricing, originations, collections, and portfolio analytics.
• Build reusable SQL objects, dimensional models, data marts, and curated datasets to enable consistent analysis.
• Develop scalable data transformation workflows using SQL, Python, dbt, Git, and Snowflake scheduling/automation.
• Produce trusted reporting assets and documentation; promote BI best practices and standardized logic.
• Collaborate with analysts and stakeholders to translate needs into reusable data products and quality controls.

Skills

SQL

Python

dbt

Git

Snowflake

Education

Bachelor's degree in a quantitative field

Tools

Power BI

Sigma

Job description

The Senior Credit Analytics Engineer is responsible for building and maintaining the analytical data foundation that supports underwriting, pricing, originations, collections, performance, and portfolio analytics. Embedded within the Credit Strategy & Analytics team, this role develops analytics-ready datasets, reusable SQL assets, scalable data models, and reporting solutions that enable analysts and business leaders to move quickly and make informed decisions. Working closely with Data Engineering, IT, and Operations, the Senior Analytics Engineer simplifies and integrates data across the lending platform. Leveraging SQL, Python, dbt, Git, Snowflake, and business intelligence tools, this role translates complex lending data into trusted, well-documented, and easy-to-use analytical assets while balancing rapid delivery with long-term quality, maintainability, and scalability.

Essential Functions

Design, develop, and maintain analytics-ready datasets supporting underwriting, credit risk, pricing, originations, collections, dealer oversight, performance, and portfolio analytics. Own and evolve the analytical data layer by developing reusable SQL objects, dimensional models, data marts, and curated datasets that enable consistent analysis and decision-making. Build and maintain scalable, reliable data transformation workflows using SQL, Python, dbt, Git, and Snowflake-native scheduling and automation capabilities. Simplify, consolidate, integrate, and reconcile data from lending and operational systems into trusted, business-facing analytical data products. Partner with analysts and business stakeholders to convert recurring or one-time analytical needs into reusable data products and standardized business logic that reduce duplicate effort and accelerate time-to-insight. Establish and promote reporting and business intelligence best practices, including consistent metrics, reusable datasets, semantic models, documentation, organization, and quality controls. Develop, maintain, and share ownership of reporting solutions using Power BI, Sigma, or comparable tools while enabling analysts to build and support reports efficiently. Design analytical solutions that balance speed, flexibility, performance, maintainability, and alignment with longer-term data architecture. Collaborate with the Data Engineering, IT, and Operations to align analytical solutions with enterprise standards, system capabilities, and business processes. Implement automated testing, validation, monitoring, and documentation to ensure analytical data assets are accurate, reliable, transparent, and trusted.

Required Education and Experience

Bachelor's degree in Computer Science, Information Systems, Data Science, Statistics, Mathematics, Engineering, Economics, or a related quantitative field, or commensurate work experience required. 5 years of experience in analytics engineering, data engineering, business intelligence, or advanced analytics required. Advanced SQL proficiency and experience with Python, dbt, and Git required. Experience developing, validating, reconciling, and troubleshooting complex analytical datasets across multiple systems. Experience designing analytics-ready datasets required. Snowflake experience preferred. Experience supporting reporting solutions in Power BI, Sigma, or a comparable platform preferred. Banking, consumer lending, financial services, fintech, credit risk, or collections experience preferred. Strong communication, analytical, problem-solving, and organizational skills required.

Physical Demands

While performing the duties of this job, the employee is frequently required to sit, stand, walk, visualize, talk, hear, and handle or touch objects or controls. The employee may occasionally lift, push, or pull up to 20 pounds. This position is an office-based position where you must be able to sit for long periods of time. The employee will be working on a computer 90% of the time.

Aqua Finance (Aqua) delivers flexible and consumer-friendly financing programs so families across the U.S. can bring their dreams to life. Our financing solutions make clean water, home renovations, and the great outdoors more affordable. We're a growing, national company with values that are deeply rooted in a midwestern culture that cares about you as an individual. We succeed when you succeed and celebrate what you bring to Aqua. Here are Aqua, we say "Yes" to helping you succeed! Beyond finding your dream career, we aim to be a first-choice employer.