Job Description

Regular or Temporary:

Regular

Language Fluency: English (Required)

Work Shift:

1st shift (United States of America)



Please review the following job description:

POSITION DESCRIPTION: Design, develop and deliver Business Intelligence (BI) solutions in the form of presentation objects, reports and dashboards to meet business needs. Support Mortgage BI solution needs and play an active role in Mortgage data warehouse and reporting initiatives. Interact with Mortgage line of business (LOB) management, system users and other team members to determine requirements. Partner with data modelers and architects in designing and enhancing data architecture. Design, develop and evolve presentation objects, reports and dashboards for delivery of BI solutions to meet business needs of secondary channel marketing pricing analytics of Mortgage Lending division of the bank. Develop and design data models, semantic layers, and data processing and transformation rules for proper data representation. Perform 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. Understand and become an expert in the pricing data flow between the bank and its partners - mortgage originators, aggregators and investors. Create and maintain data analytics processes through extensive use of analytical software tools to consolidate and analyze data from multiple sources and create pricing strategy. Prepare system and data specifications and create appropriate documentation such as business dimensional models and data mapping diagrams. Develop 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. Use analytics and forecasting techniques on the collected data to create future mortgage origination forecasts for the bank so that the overall mortgage pricing and staffing decisions can be fine-tuned. Validate design with business requirements to ensure completeness of the BI solution. Actively contribute to design reviews. Participate in design workshops, providing technical insight and knowledge. Apply architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability. Ensure that solutions are designed for optimal access and usefulness, and leverage existing technologies, when possible. Develop and apply a structured BI architecture approach and methodology that aligns with the key strategies of the organization. Define, implement and refine the BI solution development methodology based in industry best practices. Participate and lead research and development efforts (e.g. proofs of concept, prototypes) as subject matter experts when introducing new technologies. Identify data quality issues and support data governance initiatives by participating in necessary activities including data profiling. Create interactive data visualization dashboards. Communicate results clearly and professionally, demonstrating the value and usability of the data product. Create and develop end user training and documentation for BI solutions. Oversee ongoing support and maintenance of deployed BI solutions.

REQUIREMENTS: Masters degree in Management Information Systems, Statistics, Business, Finance, Economics or other quantitative field of study plus 1 year experience as a Programmer, Software Engineering Analyst or related IT occupation. Foreign equivalents accepted.

SPECIAL REQUIREMENTS: Experience is required and must include: converting business user needs to quantifiable requirements then performing data analytics activities to meet those needs; collecting structured and unstructured data from varied data sources, cleaning and manipulating utilizing Python, Excel and SQL; building statistical models such as regression for analysis and prediction utilizing SAS; developing SAS programs to build and enhance predictive models such as regression, time series forecasting, and neural network models on the data to analyze past progression and predict future trend; and creating complex structured language queries to extract data from databases such as Oracle and Teradata and manipulating data using SAS. Must have SAS certification.