Director, Data Warehouse And Analytics

International Market Centers Las Vegas , NV 89134

Posted 5 months ago

Position: Director, Data Warehouse and Analytics

JOB SUMMARY

The Director, Data Warehouse and Analytics will have responsibility for implementing the strategy, architecture, and design of the data architecture of the enterprise Business Intelligence and Data Warehouse environment. They will be expected to contribute to the definition of and then implement the overall database structure, including recovery, security, backup, and capability specifications, as well as support the architecture for the platform. They will participate in the enterprise effort to create and maintain a standard common business vocabulary and define strategic data requirements. They will create high level database designs to meet these requirements while aligning with enterprise business and technology strategy and related architecture. The Director, Data Warehouse and Analytics is expected to work closely with our software and application teams to recommend database structures based on the data storage and retrieval needs within each domain. They will examine new data system requirements and implement migration models.

ESSENTIAL JOB FUNCTIONS

The primary responsibilities of this position include:

  • Participate in all aspects of an implementation project including, but not limited to, Requirements Analysis and design, configuration, development, conversions, system testing, cut over and production support.

  • Understand Business Requirements and Develop BI solutions using Modern and/or Traditional Data Architectures (Data Lakes, NoSQL Databases, Cloud Databases, Traditional Relational DBs).

  • Design Data Sourcing approaches and Change Data Capture mechanisms.

  • Define and Design or Adopt Data Quality Screening mechanisms at various stages of the ETL process.

  • Define and Design or Adopt Metadata Capture mechanisms as part of a BI solution.

  • Define Data Models using Dimensional Modeling Techniques, design cubes as required and build BI models for the Microsoft Azure stack and Power BI.

  • Provide guidance to Power BI Developers for the creation of Data Analytics reports and queries.TECHNICAL SKILLS AND EXPERIENCE


  • 3 years of experience in a in BI a developer or database manager role.

  • Proven experience building Data Marts and Enterprise Data Warehouses

  • Hands-on experience with relational databases and building star schemas using MSSQL DB Technologies.

  • Strong experience with Business Intelligence concepts and patterns

  • Ability to create SQL queries to database involving complex queries, window functions, common table expressions etc.

  • UML knowledge and modeling experience

  • Create status reports efficiently

  • Contribute to deployment plans

  • UML knowledge and modeling experience

  • Create status reports efficiently

  • Understanding of Data Lake based architectures is a plus

  • Experience with waterfall and agile projects a plus

NONTECHNICAL SKILLS AND EXPERIENCE

  • Creative thinking, problem solving and decision making. Proactive and self-starter.

  • Has high degree of initiative, dependability and ability to work with little supervision.

  • Responds to and handles unfamiliar situations with little supervisory guidance.

  • Ability to solve problems that are complex, varied and only mildly related to those seen before. Simply determining what the problem is requires major individual effort and/or consultation with others within the department.

  • A high degree of analytical ability and inductive thinking may be required to solve highly intricate, technically complex problems. Must be able to develop new and nonstandard approaches. Independent judgment is required to study previously established, often partially relevant guidelines; plan for various interrelated activities; and coordinate such activities within the operating environment or while completing a project.

  • Ability to completes work that requires developing imaginative and complex methods, procedures, products or systems. This is an important part of the job and results generally affect several departments within the organization.

  • Has excellent written and verbal communication skills, interpersonal and collaborative skills, and the ability to communicate technical concepts to both technical and nontechnical audiences.

  • Requires regular contacts with internal persons of importance and influence involving considerable tact, discretion and persuasion in obtaining desired actions and/or the handling of difficult personal relationships.

  • Requires regular external contacts to carry out organization programs and to explain specialized matters. Position requires contacts with customers or the public involving persons of some importance on matters requiring explanation and discussion and where the effort to influence becomes important.

  • Strong communication and interpersonal skills to work within a team environment.

  • Excellent organizational and troubleshooting skills with attention to detail.

  • Strong presentation and documentation skills.

  • Has managerial skills needed for providing limited supervision for one or more functions within a department. Formally plans, assigns, directs, and coordinates the work of these functions. May perform staff evaluations and make recommendations regarding pay and/or performance.

  • Must have high proficiency in spoken and written English

  • Experience in Real Estate a plus

EDUCATION

  • Bachelor's Degree in Computer Sciences/MIS or related field preferred
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Director Of Treasury Quantitative Analytics

Diamond Resorts Corporation

Posted 3 weeks ago

VIEW JOBS 2/1/2020 12:00:00 AM 2020-05-01T00:00 JOB SUMMARY The Director of Treasury Quantitative Analytics supports Diamond Resort's ability to monetize receivables and develop predictive modeling on receivables related financing facilities performance. The Director also collaborates with the internal treasury team as well as other stakeholders to support the Company's ability manage working capital and treasury related duties. ESSENTIAL JOB FUNCTIONS * Collaborates with the Financial Services team to develop, monitor, and forecast performance of all portfolio related facilities (including default projections, asset cash flow generation, transaction waterfall, performance triggers, weighted average interest rate, excess spread requirements, eligible receivables, etc.). * Supports and prepares all quantitative data deliverables for new portfolio related financing transactions: optimal collateral characteristics; timing of new securitizations; portfolio stratifications; optimal structure for best execution and/or stress testing various scenarios; data tapes; historical performance data; transaction waterfall; debt issuance costs; risk retention and/or prepayments and defaults scenarios; and, cash flow models. * Partners with Financial Services to monetize receivables' borrowing bases and/or funding requests with and with treasury team cash flow needs. * Collaborates with Financial Services to prepare all monthly service reports for securitizations and warehouse facilities. * Forecasts and coordinates with Financial Services on portfolio-related performance including but not limited to defaults, upgrades, prepayments, cash flow, etc. * Forecasts availability of receivables to be monetized from sale date to custodial trust receipts for cash and/or working capital planning. * Collaborates with various stakeholders to forecast and/or prepare budgets and budget vs. actual and/or forecast all portfolio related debt facilities. * Works with stakeholders to prepare portfolio static pool data and forecast defaults, prepayments, and/or upgrades and overall portfolio performance for financing purposes. * Develops strategies and recommendations for defaults and/or substitutions and repurchases and/or rapid amortization prevention, excess spread, and various portfolio related performance requirements. * Prepares "what if" and stress testing data analytics and/or modelings for new initiatives and new financing transactions. * Creates predictive modeling on performance and cash flow modelings for each of the securitization and warehouse facility. * Collaborates with Director of Treasury and/or Director of Capital Markets on building predictive models for working capital, excess spread, and interest rates hedging strategies, etc. * Collaborates with Financial Services on portfolio-related initiatives as they impact treasury and the Company's working capital. * Builds data mining queries, analytical models, and special projects as directed. * Prepares quarter-end and year-end-related analyses with respect to debt as needed for the Accounting team. * Collaborates with Financial Planning &Analysis, Accounting, and Investor Relations teams on data requests. * Assists with treasury strategic initiatives such as treasury work stations, cash flow modeling (corporate and HOAs), and predictive tools by collaborating with other departments to get necessary data to support efforts. * Completes all required Company trainings and compliance courses as assigned. * Adheres to Company standards and maintains compliance with all policies and procedures. * Performs other related duties as assigned. EDUCATION * Bachelor's degree with a specialized degree in mathematics, statistics, finance, economics, and/or data science, or equivalent experience in related field. EXPERIENCE * A minimum five (5) years of experience in the technical quantitative field required. * A minimum five (5) years of supervisory experience in the technical quantitative field required. SUPERVISORY RESPONSIBILITIES This position spends the majority of the time (50% or more) achieving organization objectives, often through the coordinate achievements of subordinate staff. A portion of the time may be spent performing individual tasks related similar to those performed by direct reports, but primary duties are supervisory or organizational-goal related. Analyzes and resolves problems, determines work techniques, monitors for regulatory compliance, maintains production, interprets and creates policies, and demonstrates solid subject matter knowledge. Establishes departmental goals and objectives, functions with independence, and makes decisions on matters of significant importance. Manages human, financial, and/or physical resources; proactively assesses risk to establish systems and procedures to protect organizational assets. Exercises judgment within defined procedures and policies to determine appropriate action; develops systems to ensure subordinates adhere to policies and procedures in compliance with organizational goals and objectives. Specific supervisory duties include, but are not limited to the following: * Determines and creates policies, procedures, and manuals for direct reports. * Establishes objectives and goals for the team; plans, organizes, and manages work flow. * Assigns, monitors, and reviews work; evaluates direct report's performance. * Recruits, interviews, trains, disciplines, and terminates direct reports. * Orientates and trains direct reports. * Approves time records and time off requests; submits payroll for direct reports. * Investigates and resolves concerns and complaints. * Provides assistance and support; maintains a positive and professional working environment. LICENSE & CERTIFICATIONS * This position does not require licenses or certifications. SKILLS & ABILITIES This position requires the capability to understand and follow both oral and written directions as well as knowledge and usage of correct business English and office practices. Must be able to communicate effectively with others, analyze and resolve problems, maintain effective working relationships, and interact successfully with internal and external customers. Specific skills and abilities include, but are not limited to the following: * Working knowledge in capital markets products, financing, quantitative analysis, data science, and/or statistics required. * Proven skills in asset-backed securities and/or fixed income structuring. * Extensive working knowledge of financial analyses, planning, and treasury. * Expert Excel modeling skills and data mining skills. * Must be willing to work under dynamic and fluid and matrix organization work environments. * Ability to self-direct and solve problems with minimum direction. * Ability to partner with cross-functional teams, communicate and work well with other departments. * Ability to work under pressure with tight deadlines and conflicting priorities. * Ability to handle multiple projects and demands at the same time. * Ability to be flexible and switch direction as situations require. * Expert working knowledge with statistical analysis, predictive modeling, and data mining. * Proven skills in business intelligence, query, and scripting tools, including but not limited to VBA, Tableau, SQL, SAS, Python, Matlab, R. * Ability to handle large volume and complex datasets, and to synthesis into meaningful and predictive models to help drive business decisions. * Computer proficiency in Microsoft Word, PowerPoint, Excel, and Outlook. * Understand how to develop and implement business strategies. * Ability to interpret and create policies, procedures, and manuals. * Excellent customer service skills. * Proficient in time management; the ability to organize and manage multiple priorities. * Ability to take initiative and effectively adapt to changes. * Recognizes an emergency situation and takes appropriate action. * Able to establish and maintain a cooperative working relation. * Ability to interpret and create spreadsheets. * Able to use sound judgment; work independently, with minimal supervision. * Strong analytical and problem solving skills. * Able to perform a variety of duties, often changing from one task to another of a different nature, with impending deadlines and/or established timeframes. * Competent in public speaking. * Performs well with frequent interruptions and/or distractions. * Advanced math skills. '231381 Diamond Resorts Corporation Las Vegas NV

Director, Data Warehouse And Analytics

International Market Centers