Supervisor - IT SQL/ETL Development

Selene Holdings is a multiple-lines business financial services firm with a mortgage servicing company, a loan diligence company, a title company, an insurance brokerage, and a real estate owned company. We have office locations in Dallas, TX, Jacksonville, FL, and Salt Lake City, UT. Founded in 2007 to address needs in the mortgage industry, Selene strives to provide amazing client and borrower experiences. A positive attitude coupled with proven creative thinking and actions are all attributes we seek in every one of our employees. If you want to make a difference, then Selene is the place for you!

Position Summary:

The Supervisor of SQL/ETL Development will be responsible for managing a team of resources that will be designing and building applications primarily in SQL Server and Azure. The development will involve everything from front-end applications to database development to middle-tier services.

This position will lead a dynamic team that is dedicated to delivering applications and processes for high-quality, on-time software releases leveraging best-of-breed agile and DevOps practices with a focus on how to enable the operations of those applications through a combination of infrastructure solutioning, continuous delivery & integration, and efficient system sustainment planning.

This role is responsible for working with the Line of Business and the VP of Engineering to determine priorities, capacity, velocity within our Agile Sprint planning methodology. They also will be considered a technical expert and general business SME for the database development team.

Essential Functions:

Manage and lead both on-shore and off-shore developers

Designs, analyzes code, optimizes, and maintains Microsoft SQL Server databases, tables, stored procedures, indexes, triggers, data extraction, transformation, and validation.

The ability to develop SSIS packages to address complex business needs as well as troubleshoot and maintain existing SSIS packages

The ability to develop ADF pipelines to address complex business needs as well as troubleshoot and maintain existing ADF pipelines

Support the refactoring and re-architecting of existing software

Lead developers to identify and create common reusable packages and procedures.

Drive technical consolidation and reduction of duplicate effort across projects

The candidate should have a strong understanding of agile software development and how that impacts the operations of software; and must participate in strategy discussion with all levels of management and business sponsors

Work closely with the VP of Engineering to understand the technology roadmap and assist in enforcing the enterprise architecture standards

Support testing & deployment cycles, including working with project managers to coordinate user acceptance testing (UAT) and gathering feedback from pre-release testers.

Ability to log, track, and manage issues, bugs, and enhancement/ features requests logged in Azure DevOps (ADO).

Participate in software release and post-release activities

Capture, mitigate and /or escalate risks & issues that the development team may face in a timely fashion

Ensure development standards and consistency of specifications across sub-systems

Write and/or review deliverables, solution blueprints, and architecture documentation

Qualifications:

3-5 years in a team leadership position

5-10 years in SQL Server, database design, performance tuning, and troubleshooting

5-10 years in SQL Server/ETL Development:

T-SQL

SSIS

ADF

SSRS

Deployment of .NET apps to IIS and/or Azure App Service

Deployment of pipelines to Azure Data Factories (ADF)

Azure DevOps or similar and Git knowledge (required)

Experience with Azure SQL databases is highly desirable.

Experience with Azure Postgres databases is a plus

Proven hands-on experience developing and executing test procedures for software components

Familiarity with Agile Environments, SCRUM, Kanban etc.

Collaborating with cross-functional team to ensure understanding of all requirements

Able to work quickly and efficiently with a strong focus on achieving tasks

Experience in mortgage technology (preferred)

Experience with both relational and non-relational database systems

Why Selene?

Benefits

Selene Finance LP is committed to the total wellbeing of its employees and therefore offers one of the best benefits packages available in the industry today, which includes:

Paid Time Off (PTO)

Medical, Dental &Vision

Employee Assistance Program

Flexible Spending Account

Health Savings Account

Paid Holidays

Company paid Life Insurance

Matching 401(k) Plan

The job requirements listed above are representative of the knowledge, skills, and/or abilities required. This job description is not an inclusive list of all duties and responsibilities of this position. Incumbents will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments. Selene reserves the right to amend and change responsibilities to meet business and organizational needs.

Privacy Policy - Selene (seleneadvantage.com)

JR112317