Database Design Engineer

Yrefy, LLC; Phoenix, Northern (AZ, KY); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

100% Employer Paid Medical for you and

Immediate vesting 401(k)/Roth with 4%

Dental, vision, life, disability

Student loan repayment assistance

Tuition reimbursement

Stocked kitchens

Collaborative team environment

Job summary

Yrefy, LLC in Phoenix, AZ is seeking a Database Design Engineer to design, optimize, and maintain secure, high-performing data structures and database solutions supporting transactional systems and analytics.

The ideal candidate will translate business requirements into scalable designs, collaborate with software engineers, analytics, QA and stakeholders, and focus on accuracy and data quality within a regulated fintech environment.

Qualifications

• Bachelor’s degree in computer science, information systems, data engineering, or related field, or equivalent practical experience.
• 3-5 years of experience in database engineering, design, or data architecture.
• Strong proficiency in SQL and relational database design.
• Experience with data modeling for transactional and analytical systems.
• Hands-on experience with performance tuning, indexing, query optimization, and troubleshooting.
• Knowledge of database security, backup/recovery, and change management.
• Experience supporting ETL/ELT processes, migrations, or integrations.
• Ability to document technical designs clearly and communicate with technical and non-technical stakeholders.
• Strong analytical thinking, problem-solving, and attention to detail.
• Ability to manage multiple priorities in a collaborative team.

Responsibilities

• Design and maintain logical and physical database schemas to support development, reporting, and workflows.
• Create and optimize tables, indexes, views, stored procedures and queries for performance and reliability.
• Partner with engineers and stakeholders to translate requirements into effective data models and solutions.
• Support data integration, migration, and transformation across platforms and third-party systems.
• Monitor performance, troubleshoot bottlenecks, and implement tuning strategies.
• Maintain data integrity and validation standards across environments.
• Document database standards, naming conventions, and design artifacts.
• Assist with backup, recovery, and disaster recovery planning.
• Collaborate on security controls and compliant data handling.
• Participate in release planning, testing, and production support for changes.
• Contribute to architectural improvements and data governance.

Skills

SQL proficiency

Data modeling

Performance tuning

Data security

ETL/ELT

Documentation

Communication

Analytical thinking

Prioritization

Education

Bachelor’s degree or equivalent practical experience

Tools

Microsoft SQL Server

Azure DevOps

Jira

Data warehousing concepts

Job description

Database Design Engineer

Full-time, primarily onsite role in Phoenix, Arizona.

Looking for a young, dynamic and growing company to contribute your talents? Yrefy is a private fintech company, specializing in assisting borrowers and co-borrowers in relieving the burden of student loans through refinance. The Invessio team supports the data and platform capabilities that help drive reliable operations, informed decision-making, and scalable growth across multiple businesses. We are seeking a Database Design Engineer to design, optimize, and maintain secure, high-performing data structures and database solutions that support transactional systems, analytics, and internal applications. If you are passionate about helping people and thrive in a growing environment, we invite you to consider joining our team!

Position Summary

The Database Design Engineer is responsible for translating business and application requirements into scalable logical and physical database designs. This role partners closely with software engineering, analytics, QA, and business stakeholders to build reliable data models, improve system performance, strengthen data quality, and support secure access to critical business information. The ideal candidate combines strong SQL and data modeling expertise with a practical mindset, sound documentation practices, and a commitment to accuracy in a regulated financial services environment.

Key Responsibilities

• Design and maintain logical and physical database schemas that support application development, reporting, and operational workflows.
• Create and optimize tables, indexes, views, stored procedures, and queries for performance, scalability, and reliability.
• Partner with software engineers and business stakeholders to translate business requirements into effective data models and database solutions.
• Support data integration, migration, and transformation efforts across internal platforms and third‑party systems.
• Monitor database performance, troubleshoot bottlenecks, and implement tuning strategies to improve response times and stability.
• Establish and maintain data integrity, referential consistency, and validation standards across database environments.
• collaborate on and document database standards, naming conventions, dictionaries, and technical design artifacts.
• Assist with backup, recovery, and disaster recovery planning to protect business‑critical data assets.
• Collaborate with security, compliance, and engineering partners to ensure proper access controls and secure handling of sensitive information.
• Participate in release planning, testing, and production support for database changes and deployments.
• Contribute to the continuous improvement of database architecture, development practices, and data governance processes.
• Perform other related duties as assigned.

Required Qualifications

• Bachelor’s degree in computer science, Information Systems, Data Engineering, or a related field, or equivalent practical experience.
• 3-5 years of experience in database engineering, database design, data architecture, or a similar technical role.
• Strong proficiency in SQL and experience designing relational database structures.
• Experience with data modeling concepts for transactional and analytical systems.
• Hands‑on experience with database performance tuning, indexing strategies, query optimization, and troubleshooting.
• Knowledge of database security, backup and recovery practices, and change management.
• Experience supporting ETL/ELT processes, data migrations, or system integrations.
• Ability to document technical designs clearly and communicate effectively with both technical and non‑technical stakeholders.
• Strong analytical thinking, problem‑solving skills, and attention to detail.
• Ability to manage multiple priorities and work effectively in a collaborative team environment.

Preferred Qualifications

• Experience working in financial services, lending, fintech, or other regulated environments.
• Familiarity with cloud‑based data platforms and modern data warehousing concepts.
• Experience with Microsoft SQL Server, or similar enterprise database platforms.
• Exposure to Azure DevOps, Jira, or similar work management tools.
• Experience supporting reporting, analytics, or business intelligence initiatives.
• Knowledge of data governance, audit readiness, and sensitive data handling best practices.
• Comfort working in a fast‑paced environment with evolving business priorities.

What We Value

• Practical problem-solvers who build scalable solutions and follow through on details.
• Professionals who communicate clearly, collaborate well, and take ownership of outcomes.
• Team members who value data quality, thoughtful design, and continuous improvement.
• People who can balance speed, accuracy, and security in a business‑critical environment.

What We Offer

• 100% Employer Paid Medical for employee and whole family, including the Mayo Clinic.
• 401(k)/Roth plan with 4% match and immediate vesting.
• Dental, vision, life, and short‑and long‑term disability insurance.
• Student loan repayment assistance and tuition reimbursement.
• Stocked kitchens, and a collaborative team environment.
• Opportunity to contribute to a fast‑growing company with meaningful impact.

This is a primarily onsite role with genuine flexibility. Core collaboration hours are 10 AM – 3 PM; manage your full schedule around that. Need a morning at home for an appointment? Handle it. We don’t track hours or micromanage — we hire professionals and treat them accordingly. We encourage experimentation, learning from mistakes, and continuous improvement across teams.