Regulatory Data Analyst
Description:
• Develop operational, management, and exception reports using T-SQL in a controlled, production environment
• Create ad-hoc reporting for individual regulatory requests and Stored Procedures for production reporting
• Interpret regulatory requirements into actionable specifications
• Mine, analyze, and interpret data from multiple sources
• Work closely with multiple business units to define requirements and validate report results
• Perform tests for validity, reasonableness, and accuracy through standard methods and application of specific subject-area knowledge
• Perform regular maintenance and testing on production reports
• Assist in developing documentation of existing reports, data dictionaries and reference documents
Requirements:
• 1 - 5 years of recent experience as a data analyst or another related title in a financial or banking environment
• Formal SQL query language training classes or certificate program
• Strong proficiency with the SQL query language, preferably Microsoft T-SQL
• Strong proficiency with the Microsoft Office Suite package including an expert knowledge of Excel
• Demonstrated ability to effectively communicate with both internal and external customers, peers, and management
• Experience with Mortgage Servicing and/or familiarity with MSP as a mortgage servicing platform is preferred
Benefits:
• medical
• dental
• vision
• 401k
• PTO/paid sick leave
• employee stock purchase plan
Apply Now
• Develop operational, management, and exception reports using T-SQL in a controlled, production environment
• Create ad-hoc reporting for individual regulatory requests and Stored Procedures for production reporting
• Interpret regulatory requirements into actionable specifications
• Mine, analyze, and interpret data from multiple sources
• Work closely with multiple business units to define requirements and validate report results
• Perform tests for validity, reasonableness, and accuracy through standard methods and application of specific subject-area knowledge
• Perform regular maintenance and testing on production reports
• Assist in developing documentation of existing reports, data dictionaries and reference documents
Requirements:
• 1 - 5 years of recent experience as a data analyst or another related title in a financial or banking environment
• Formal SQL query language training classes or certificate program
• Strong proficiency with the SQL query language, preferably Microsoft T-SQL
• Strong proficiency with the Microsoft Office Suite package including an expert knowledge of Excel
• Demonstrated ability to effectively communicate with both internal and external customers, peers, and management
• Experience with Mortgage Servicing and/or familiarity with MSP as a mortgage servicing platform is preferred
Benefits:
• medical
• dental
• vision
• 401k
• PTO/paid sick leave
• employee stock purchase plan
Apply Now