Designs, develops and delivers analytics and Business Intelligence (BI) solutions in the form of decision systems, presentation objects, reports and dashboards to support pricing analytics and portfolio management strategies and objectives. Plays an active role in Mortgage data management and reporting initiatives. Interacts with Mortgage line of business (LOB) management, system users and other team members to determine data analytics requirements. Partners with data modelers and architects in designing and enhancing data architecture.
Essential Duties and Responsibilities
Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.
Designs, develops and evolves presentation objects, reports and dashboards for delivery of BI solutions to meet business needs of pricing analytics division of mortgage lending.
Develops and designs data models, semantic layers, and data processing and transformation rules for proper data representation.
Performs dimensional modeling and serve as subject matter expert on slowly changing dimensions, historic data capture, error capture and reporting thus developing business decisions regarding pricing changes.
Supports mortgage portfolio management through enhanced data analytics and forecasting to meet or exceed profitability targets and balance sheet growth strategies. Understands and becomes an expert in the pricing data flow between the bank and its partners - originators, aggregators and investors.
Creates and maintains data analytics processes through extensive use of analytical software tools to consolidate and analyze data from multiple sources and create pricing strategy.
Prepares system and data specifications and create appropriate documentation such as business dimensional models and data mapping diagrams.
Develops data validation strategies for data from varied sources and reach out to new data sources to meet the business requirements of pricing strategy adjustment analytics.
Validates design with business requirements to ensure completeness of the BI solution. Actively contribute to design reviews, workshops, and provide technical insight and knowledge.
Applies architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability. Ensures that solutions are designed for optimal access and usefulness, and leverage existing technologies, when possible.
Develops and applies a structured BI architecture approach and methodology that aligns with the key strategies of the organization. Defines, implements and refines the BI solution development methodology based in industry best practices.
Identifies data quality issues and supports data governance initiatives by participating in necessary activities including data profiling.
Creates and develops end user training and documentation for BI solutions, as well as oversee ongoing support and maintenance of deployed BI solutions.
Position can be located in Richmond, VA or Greenville, SC.
Required Qualifications:
The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Bachelor's degree in a quantitative discipline, or equivalent education and related training.
4+ years of experience in analysis, design, development, customization, implementation and testing of data and analytics applications and products, out of which two years of presentation layer development experience, and two years of experience with data warehousing and database programming.
Knowledge of BI tool (e.g. MicroStrategy, SAS, Tableau, QlikView, SAP) architecture, functions and features.
Experience with queries, data warehouse architecture, data quality and data profiling; strong understanding of database concepts like referential integrity, indexes and keys.
Ability to work with a wide range of business and technical staff.
Strong analytical, troubleshooting and problem-solving skills.
Strong verbal and written communication skills allowing the ability to work independently or in conjunction with a team.
Demonstrated proficiency in basic computer applications, such as Microsoft Office software products.
Preferred Qualifications:
Advanced knowledge in developing queries and procedures in SQL, SAS or other programming languages.
Experience in Hadoop and/or Netezza data environments.