Join the team as a Data Visualization Associate in Home Lending, your main job is to identify the reporting needs of the business and develop operational reports, executive dashboards and ad-hoc analysis to support the line of business. This includes gathering requirements from the business, identifying the data sources, collaborating with Data teams to build the best data solution for reports and development of reports in Alteryx, SSRS, Tableau and other delivery platforms and with strong SQL development skills using Oracle, SQL Server, Teradata and other related RDBMS. The position requires Mortgage servicing business knowledge together with data science and data management skills with a focus on focus on design, build and implementation of reports and digital dashboards.
Job Responsibilities:
- Develops, tests and produces analytical and operational reports and metrics using SQL, Alteryx, SSRS, Power B, Tableau or equivalent reporting tools to assist the business in meeting operational objectives.
- Ensures adherence to internal policies and procedures and identify risks and controls within the operation.
- Adheres to technology architecture standards, technology risk management and security policies, and data management policies.
- Reviews reports and develop analytical recommendations.
- Maintains and launches reports on a recurring basis, examining logic for alignment between multiple, dynamic data sources and business report requirements.
Required qualifications, capabilities and skills:
- SQL and Power BI expertise is required
- At least 5 years Development experience on RDBMS such as SQL and Oracle
- At least 5 years Development experience on reporting tools such as Alteryx, SSRS, SSIS
- At least 5 years Development experience on dashboarding such as Power BI, Tableau
- MS Office (required)
- Experience with compliance operations testing/production or process automation
- Experience in reviewing technical specifications, process improvement and process mapping
- Strong decision-making capabilities and the ability to identify problems, propose solutions, and influence/execute change
- Demonstrated ability to positively interface with other departments, colleagues, and senior management
Preferred qualifications, capabilities and skills:
- SSRS/Tableau
- Experience using SharePoint, JIRA and Business Intelligence tools (preferred)
- Knowledge in Home Lending LOB/functions (preferred)
- Good communication skills (written and verbal in a clear/concise manner)
- Good time management and prioritization skills
- Ability to work independently yet interact with a wide variety of groups. Ability to negotiate to find creative solutions to reach goals of the group and achieve win/win solutions
- Ability to communicate effectively with all audience types (clients, operations, management, etc.). Ability to recognize/foresee downstream impact(s) before presenting recommendations
- Ability to design flexible solutions that can be seamlessly leveraged/reused for additional clients