Senior Credit Analytics Engineer

Jobtailor; Illinois; On-site; USD 110,000 - 160,000; Full time

Job summary

Aqua Finance seeks an experienced analytics engineer to design and maintain analytics-ready datasets supporting underwriting, credit risk, pricing, originations, collections, and portfolio analytics in Illinois.

You will build scalable data transformations using SQL, Python, dbt, and Snowflake, collaborate with analysts and business stakeholders, and implement BI solutions with Power BI or Sigma to deliver trusted data products.

Qualifications

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

Responsibilities

• Design, develop, and maintain analytics-ready datasets supporting underwriting, credit risk, pricing, originations, collections, and portfolio analytics.
• Develop reusable SQL objects, dimensional models, data marts, and curated datasets.
• Build scalable data transformation workflows using SQL, Python, dbt, Git, and Snowflake automation.
• Consolidate data from lending and operational systems into trusted analytical data products.
• Partner with analysts and business stakeholders to create reusable data products and standard logic.
• Establish BI best practices, metrics, datasets, semantic models, and data quality controls.
• Develop and share reporting solutions using Power BI, Sigma, or comparable tools.

Skills

Advanced SQL Proficiency

Python Development

dbt

Data Transformation Workflows

Analytics Engineering

Data Validation

Data Reconciliation

Dimensional Models

Data Marts

Analytics-Ready Datasets

Data Engineering

Reporting Solutions

Education

Bachelor’s degree in Computer Science / related quantitative field

Tools

Power BI

Sigma

Snowflake

Git

dbt

Job description

• Design, develop, and maintain analytics-ready datasets supporting underwriting, credit risk, pricing, originations, collections, dealer oversight, performance, and portfolio analytics
• Develop reusable SQL objects, dimensional models, data marts, and curated datasets
• Build and maintain scalable data transformation workflows using SQL, Python, dbt, Git, and Snowflake-native scheduling and automation
• Simplify, consolidate, integrate, and reconcile data from lending and operational systems into trusted analytical data products
• Partner with analysts and business stakeholders to convert analytical needs into reusable data products and standardized business logic
• Establish 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
• Design analytical solutions balancing speed, flexibility, performance, maintainability, and longer-term data architecture
• Collaborate with Data Engineering, IT, and Operations to align solutions with enterprise standards, system capabilities, and business processes
• Implement automated testing, validation, monitoring, and documentation for analytical data assets
• Support Aqua Finance's consumer-friendly financing programs for clean water, home renovations, and outdoor purchases

Requirements

• 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
• Must be able to sit for long periods of time
• Must be able to work on a computer 90% of the time
• May occasionally lift, push, or pull up to 20 pounds

Core Competencies

Demonstrates expertise in designing and developing analytics-ready datasets, utilizing advanced SQL, Python, and dbt for data transformation workflows. Proficient in implementing reporting solutions with Power BI and ensuring data quality through best practices in business intelligence.

Highest-signal resume keywords

• Advanced SQL Proficiency
• Python Development
• Data Transformation Workflows
• Reporting Solutions in Power BI
• Analytics Engineering Experience

ATS Optimization Keywords

Hard Skills

• SQL
• Python
• Dbt
• Data Engineering
• Analytics Engineering
• Data Validation
• Data Reconciliation
• Dimensional Models
• Data Marts
• Analytics-Ready Datasets

Soft Skills

• Strong Communication
• Analytical Skills
• Problem-Solving Skills
• Organizational Skills

Industry Keywords

• Banking
• Consumer Lending
• Financial Services
• Fintech
• Credit Risk
• Collections

Tools & Technologies

• Power BI
• Sigma
• Snowflake
• Git
• Aqua Finance