

Senior SQL Developer
Apply NowDescription
SUMMARY
The Senior SQL Server Developer within the Corporate Analytics division reports directly to the Director of Data Management and is responsible for the design, development, testing and promotion of database objects to support the Corporate Analytics initiatives
The Senior SQL Server Developer will be responsible for creating new database objects, maintaining existing objects , ETL processes and producing comprehensive documentation of all developed objects and repositories
The Senior SQL Developer will be responsible for identifying, documenting and consuming new data sources within the Corporate Analytics data environment. This includes documenting application source system databases, data requirements, development of database objects and promote objects and ETL processes to the production environment
The resource will also be responsible for providing oversight and technical guidance to the Data Management team as well as other areas within Corporate Analytics
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Write and modify complex T-SQL queries, stored procedures, views and triggers in addition to the development of other T-SQL database objects to support overall corporate objectives
- Develops data models to ensure that the data objects provided are completely and accurately represented
- Perform ad-hoc data queries in response to critical business needs
- Create and maintain documentation related to applications, data sources, and ETL movement within the Corporate Analytics data environment.
- Maintain and regularly update database coding standards, ETL processes and procedures. Provide guidance, training and mentoring to all the development team members on coding standards and best practices.
- Reviews and identifies opportunities to optimize SQL queries for peak performance
- Enforce, follow and improve Application Change Management procedures
- Design, develop, manage, and support all existing job processes to ensure service levels are met
- Perform regular monitoring, analysis and tuning of databases to achieve optimum performance
- Implement automation of routine processes with appropriate monitoring controls
- Develop, implement and maintain change control / testing processes for migration of database objects across environments.
DESIRED SKILLS AND EXPERIENCE
- In-depth knowledge of the mortgage industry
- Development of use cases, test scripts and documentation to support database development
- Strong communication, interpersonal and presentation skills
- Demonstrated ability to work in teams and build collaborative relationships
- Experience operating in a complex and changing environment
- Advanced analytical skills in the realm of modeling, data normalization, data mining, data manipulation and visualization
MINIMUM QUALIFICATIONS
- Bachelor’s degree in Computer Science or related field and/or equivalent experience
- Minimum of 7 years’ experience in successively progressive positions in database development using Microsoft SQL Server
- Extensive experience (5+ Years) in the development, design, tuning and maintenance of SSIS packages
- In depth experience with Microsoft Business Intelligence Suite – SSRS & Power BI.
- Strong knowledge, understanding and experience related to database modeling, design, and complex report development
- Experience in implementation of control and reconciliation reports
- Proficiency with Microsoft Office tools (Access, Excel, PowerPoint and Visio)
- Experience with SAS /Snowflake software products and integration with MS SQL Server a plus
- Experience with Control-M for Databases.
- Ability to analyze and comprehend complex data
- Solid time management skills with the ability to organize and prioritize multiple tasks at the same time
#LI-KK1
Benefits
Career development and advancement
Working at Freedom, you have the chance to invest in yourself. From on-the-job training to advancement opportunities, and from tuition assistance to our annual internal leadership conference, we’re focused on upskilling, achieving, and celebrating.
Learn MorePhilanthropy
We run huge company-sponsored donation events and contests, as well as offer paid volunteer time so you can commit your support to the causes which you care about most.
Learn MoreHolidays and paid time off
We offer ample paid time off including multiple paid holidays — because your downtime and well-being are just as important to us as your time in work mode.
Learn MoreYour Wallet
Our salaries are competitive — rewarding your experiences, contributions, and hard work. We also have a 401K plan which provides a matching contribution.
Learn More
Medical
We offer several medical benefits plans and options to choose from including dental, vision, disability and life insurance, dependent care and flexible spending.
Learn MorePet insurance
Pets are part of the family too! We offer comprehensive vet insurance to make sure your cats are cared for, your pups are prioritized, and your lizards looked-after.
Learn MoreJoin us
Featured Roles
Senior Risk Manager- Corporate
**REMOTE POSITION** Summary This position is part of a newly created team that will focus on enterprise corporate risks The role will be tasked with assisting with sharing and implementing risk framework…
Senior Loan Advisor (Remote)
The Senior Loan Advisor is a customer focused, inside sales position within the Call Center. Will be responsible for both in-bound and out-bound calls through marketing campaigns. Will conduct the initial pre-qualification phone screen, an…
Senior Loan Coordinator
Summary The Senior Loan Coordinator is responsible for coordinating Title Related Functions needed as part of the Loan Application Process. This position may include but is not limited to analyzing Title Commitment…
VP - IT Run Operations ( Leadership Role)
ESSENTIAL DUTIES AND RESPONSIBILITIES The VP of Technology Operations will be responsible for the overall management of the Freedom Technology Command Center. The Command Center will include …
Loan Advisor, Senior
The Senior Loan Advisor is a customer focused, inside sales position within the Call Center. Will be responsible for both in-bound and out-bound calls through marketing campaigns. Will conduct the initial pre-qualification phone screen, and prep…
Loan Advisor, Senior
The Senior Loan Advisor is a customer focused, inside sales position within the Call Center. Will be responsible for both in-bound and out-bound calls through marketing campaigns. Will conduct the initial pre-qualification phone screen, and prep…
Call Center Sales Incentive Compensation Manager
Summary Develops and implements incentive programs for the Call Center, assessing behavioral and cultural impact, revenue generation and impact to the Call Center and its customers. Drives the strategic design of v…
Sr IT Salesforce Business Analyst
The Sr Business Analyst will be responsible to capture business objectives and transforming into functional requirements by documenting the current/future state of critical business operations, automated systems process and reporting through a c…
Business Analyst
Summary: The Business Analyst is responsible for developing complex reporting with an understanding of current business processes and metrics as they relate to the mortgage industry. This includes gathering requi…
Loan Advisor, Senior
The Senior Loan Advisor is a customer focused, inside sales position within the Call Center. Will be responsible for both in-bound and out-bound calls through marketing campaigns. Will conduct the initial pre-qualification phone screen, and prep…