Junior Data Warehouse Engineer

Please Note:

This is a Utah-based hybrid position, which will require some regular in-office days each week. Additionally, employment with Medallion Bank is contingent on passing both a background check and maintaining a clean background.

At Medallion Bank we finance fun! We are an industrial loan bank that specializes in providing consumer loans for the purchase of recreational vehicles, boats, home improvement, and offering loan origination services to fintech partners. We work directly with thousands of dealers, contractors and financial service providers serving their customers throughout the United States. Medallion Bank is a small company with a big impact.

We recognize our employees as our greatest asset and have a culture to prove it!

Responsible for designing, developing, and maintaining data warehousing solutions to support the organization’s data integration, analysis, and reporting needs. They are also responsible for overseeing the maintenance and security measures of the company databases.

• Designs and architects’ data warehouse solutions that meet scalability, reliability, and performance goals.
• Develops and implements data models, schemas, and ETL processes to extract, transform, and load data from various sources into the data warehouse.
• Implement data quality controls and validation processes to ensure data integrity and consistency.
• Identify and resolve data-related issues, including data quality problems, data transformation errors, and performance bottlenecks.
• Provides general direction, design, maintenance, and control of company databases.
• Responsible for troubleshooting and solving problems relative to current environment and architecture using a wide range of techniques to detect, identify and eliminate database problems.
• Develops, documents and enforces standards for access to the database.
• Write SQL queries to support ad-hoc reporting and data analysis.
• Develop documentation on report development processes and procedures.
• Perform other duties as assigned.

• Thorough knowledge of SQL to build and maintain data warehouses.
• Strong programming skills.
• Strong technical skills including data analysis and programming in SQL and other database and server languages.
• Ability to be a strong self-starter.
• The ability to work independently, when necessary, as well as with a team.
• Excellent verbal and written communication.

• Bachelor’s degree in information technology, computer science or related field strongly preferred.
• Minimum of 2 years professional experience that includes coding and database administration expertise with SQL servers.

• Comprehensive benefits including medical, dental, vision, disability, and life insurance
• 401K with a company match
• PTO including 11 federal paid holidays off, vacation time and sick time
• Financial Wellness Program
• Volunteer Opportunities
• Awesome company culture and co-workers who love to work here!
• Work Life Balance – We don’t use that term lightly!
• Company Wide Open Door Policy