Data Warehouse Engineer II | Remote

Full Time
Remote
Posted
Job description

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. 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.

#LI-DP1

www.colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, www.colinoncars.com is the ideal place to find your next job.

Intrested in this job?

Related Jobs

All Related Listed jobs