Senior Engineer - Data Systems

23 Nov 2024

Vacancy expired!

Senior Engineer - Data Systems in Detroit, Michigan Posted 10/27/21

THE TEAM YOU WILL BE JOINING:
  • Top 25 U.S. digital financial services company committed to developing award-winning technology and services.
  • Named one of the top three fastest-growing banking brands in the U.S. in 2020.
  • Offers a full suite of products including mortgage lending, personal lending, and a variety of deposit and other banking products (savings, money-market, and checking accounts, certificates of deposit (CDs), and individual retirement accounts (IRAs)), self-directed and investment-advisory services, and capital for equity sponsors and middle-market companies.

WHAT THEY OFFER YOU:
  • Fast paced, highly collaborative, teamwork-oriented environment
  • Make an immediate impact in this high visibility role
  • Base salary of $110-125k + bonus and excellent benefits package
  • Top-notch leadership committed to developing people

LOCATION
  • CHARLOTTE, NC OR DETROIT, MI - 100% remote for now, then will sit Hybrid (3 days in office, 2 days remote) when staff transitions back into the office after January/February.

WHAT YOU WILL DO

The Senior Engineer will be responsible for delivering relevant technical solutions based on best practices primarily using various database technologies. The ideal candidate should be self-driven, able to work with minimum supervision and have extensive experience in data modeling, Data Warehousing, PL/SQL, ETL processing, Reporting and a background in cloud engineering. This role will be expected to work as an individual contributor as well as provide oversight and direction to other technical resources as required.
  • The Sr. Database Administrator will be a part of team that supports database and PL/SQL development
  • Background in AWS and other Cloud based technologies
  • Design, implement, code, test and maintain database technologies
  • Prepare and review system documentation composed by development teams
  • Perform modifications to and maintenance of operational programs and procedures
  • Develops effective and efficient PL/SQL packages, procedures, triggers and functions according to design specifications
  • Applies best practice for tuning for overall system performance
  • Supports software development and test teams throughout the software development lifecycle
  • Includes incremental script execution and defect resolution
  • Provides support for software releases
  • Research interfaces to identify and code required updates to support integration.

HOW YOU ARE QUALIFIED:
  • 3+ years of experience required
  • Data migration experience
  • Extensive experience with database development tools, ETL and integration technologies
  • Firm understanding of the overall architecture required to support common schema-based objects used to store data and implement business logic
  • Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures
  • Ability to setup, maintain and enhance partition table spaces
  • Experience with managing and resolving problems on a live production system
  • Solid understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports etc.
  • Experience with software development lifecycle and software development common practices (code reviews, unit testing etc.)
  • Strong written and oral communication skills are essential
  • Solid work ethic, self-driven with the ability to work with minimal supervision.