Data Warehouse Engineer II | Remote

Who We Are:

Cardinal Financial is a nationwide direct mortgage lender that focuses on creating solutions for our borrowers, partners, and employees—to provide the very best experience. We are genuine and hard-working individuals who are not scared to improve and intentionally push beyond what is considered “good enough.”

Looking to join a company that values its people, innovates and expands on its proprietary technology, and is growing at a ridiculous rate?! Apply below!

Who We Need:

The Data Warehouse Engineer II is responsible for maintaining, expanding and improving the data warehouse and surrounding systems and processes

What You Will Do:

• Design ETLs for data sources that can automatically run and reliably maintain data in the data warehouse
• Make improvements to the processes and scripts surrounding the data warehouse and ETLs as directed for performance, reliability and ease of maintenance
• Trace possible data discrepancies through any report/external logic, data transformations and the source of the data to identify the root cause of the issue
• Collaborate with stakeholders to ensure the established data definitions match their expectations
• Uphold data security and data governance best practises
• Collaborate with greater engineering team in an agile environment
• Manage your tasks completely, including prioritization, working with stakeholders for design and specs, communicating status to all, completing the work, and documenting what you've done
• Participate in code reviews and daily interactions to ensure our warehouse meets our high standards. We mix up the review teams so you'll get exposed to the whole system

What You Need:

• Bachelor’s degree in Computer Science, Data Science or related field or equivalent experience
• 3-7 years experience designing, creating and maintaining ETLs moving data into a data warehouse
• You communicate well whether you’re getting specs from a stakeholder, writing those specs, explaining a design to your colleagues, or patiently helping a user
• Knowledge of data warehouse design and best practises (e.g. star schemas)
• Familiarity with python scripts to automatically interact with databases
• Ability to understand and untangle complex business rules and data structure
• You love having agency in your work and finding new ways to be better. Learning, creation, change and thoughtful debate are things you enjoy
• You’re comfortable working in a team where each of us has a huge impact and we depend on each other to get things done
• Familiarity and experience with any of the following: Shell scripts, AWS Step Functions, Jenkins, Pentaho, Looker, Git, BigQuery

What We Offer:

• Strength, Stability, and Vision.
• Great compensation package.
• Opportunity for career growth.
• A commitment to be a relevant market leader - we are aiming for the top!
• Octane, our engineered proprietary technology that is transforming the mortgage industry.
• An empowered culture where your ideas are important and your voice matters.
• Full Benefits, beginning the first day of the month following your start date, including – Medical, Dental, Vision, Life, Disability Insurance, and much more.
• Generous paid time off package that also includes all major holidays.
• 401K w/ 50% match - Beginning the 1st of the month following 30 days of employment.

Cardinal Financial is an Equal Opportunity Employer. We respect and aim to empower individuals and support the diverse cultures, perspectives, skills and experiences within our workforce. California residents click here to review Cardinal's California Employee Privacy Policy & Notice at Collection. The expected base salary for this position ranges from one hundred and four thousand dollars to one hundred thirty-five thousand dollars, determined based on the applicant's experience, skillset, education, training, certificates, and licenses.