Job Description

The Westgate Mortgage Reporting and Analytics team manages a MS-SQL based data warehouse that supports the needs of the team as well as other groups in the organization. The data warehouse connects and consolidates data from many disparate data sources and APIs, as well as pushes data out through different channels. Managing and ensuring a high performance DW is what allows our team to operate at scale, answering and solving many of the complex questions/problems that arise in our business.

We are seeking a SQL Server Database Administrator with three to five years of experience. This role will be responsible for supporting the DW, ensuring high uptime, performance tuning, API integrations, as well as data engineering and development.

We are looking for an individual that not only understands how to manage a SQL server, but also enjoys working with and developing the underlying data. The incumbent would have a natural affinity for learning new technologies and applying that in a business context. They understand and know how to utilize causal and dependent relationships.

The ideal candidate would have experience administering a SQL server, as well as a balanced blend of data engineering, data discovery, and answering ad hoc business-related questions with Excel or Tableau.

To perform this job successfully, an individual must be able to perform each essential duties and responsibilities satisfactorily. Additionally, the person must possess and adhere to the following core company values:

• Integrity
• Passion
• Work Ethic

Responsibilities:

• Take ownership in managing all aspects of the DW and its core functions.
• Monitor SQL Server Agent to ensure daily/monthly SSIS packages execute successfully; troubleshoot and resolve intermittent job failures, occasionally outside of normal business hours (including weekends).
• Test and deploy enhancements to SSIS packages and data transfer protocols, including QA to avoid downstream data dependency errors.
• Integrate 3rd party data sources using API’s / SFTP, and support changes to existing integrations.
• Maintain account management policies; recommend and implement approved security policies.
• Assess historical performance, and recommend strategies for optimizing the data processing model, data storage, and indexing structure.
• Detect issues concerning data integrity and assume responsibility for resolving those issues.
• Document SQL server changes and SSIS package enhancements in Azure DevOps; document key datasets and database structure.
• Become a subject matter expert of our existing datasets and infrastructure; provide technical guidance to BI developers and SQL Server end-users by assisting with query tuning and educating on best practices.
• Collaborate with cross functional teams across the organization to establish robust data processes/pipelines.
• Actively participate in the expansion of the mortgage analytics team to support other business units and initiatives that help elevate the team.

Qualifications

Experience:

• Three to five years of progressive experience managing a MS-SQL Server-based environment, as well as directly developing data.
• Experience in a large public or private company or large public accounting firm.
• Experience with proven ability to interact with all levels of the organization.

Education & Certifications:

• Bachelor’s degree from an accredited university in business, finance, engineering, IT, or a related field.

Skills/Knowledge:

• Experience with SSMS, SSIS, SSAS, PowerShell/Batch scripting, CData, and other API integrations.
• Deep understanding of data architecture, process optimization and indexes; analyzing execution plans for query tuning and index optimization.
• Familiarity with monitoring features (Extended Events, SQL Trace, SQL profiler, etc) to monitor health and performance of the DW.
• Keen ability to document observations made through research, data discovery, and/or root-cause analysis, and communicate findings/recommend solutions to leadership.
• Ability to quickly learn, adapt, and integrate new technologies.
• Self-starter with superior analytical, critical thinking, communication, organization, and decision-making capabilities.
• Excellent attention to detail, strong problem-solving skills, ability to deal with ambiguity, and work successfully and effectively on cross-functional teams.
• Ability to manage multiple tasks at once and possess a work ethic based on a strong desire to exceed expectations.
• The ability to read, write, understand, optimize, and simplify SQL required.

Additional Information

Why Westgate?

• Comprehensive health benefits – medical, dental and vision
• Paid Time Off (PTO) – vacation, sick, and personal
• Paid Holidays
• 401K with generous company match
• Get access to your pay as you need it with our Daily Pay benefit
• Family benefits including pregnancy, and parental leave and adoption assistance
• Wellness Programs
• Flexible Spending Accounts
• Tuition Assistance
• Military Leave
• Employee Assistance Program (EAP)
• Life, Disability, Accident, Critical Illness & Hospital Insurance
• Pet Insurance
• Exclusive discounts for Team Member (i.e., hotels, cruise, resorts, restaurants, entertainment, etc.)
• Advancement & development opportunities
• Community Involvement Programs

Westgate Resorts is an Equal Employment Opportunity employer. __ All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status or any other protected status under federal, state or local law. If you have a disability and believe you need a reasonable accommodation in order to complete your application or any part of the recruiting process, please email WGAccommodations@wgresorts.com with the job title and the location of the position for which you are applying.