Design, develop, test, and maintain applications and processes to parse, extract, transform, and load data from multiple data sources to the data warehouse.Responsibilities
Develop applications for parsing, extracting, and loading data in Base SAS.
Document, test and debug data programs prior to implementation in the live production environment using standard testing and validation protocols.
Group and summarize data to optimize performance for scheduled processes and end user reporting.
Maintain, support and develop the SAS data warehouse.
Develop data feeds and reports for external and internal clients as requested. Question users to determine fields and array of data needed to fulfill requests. Create and document reports available in the report library. Build dynamic end user reporting systems to generate standard scheduled reports and easy interface functionality for ad hoc reporting needs.
Develop data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and internal OLTP database systems.
Develop close working relationships with project management and end users to understand issues arising with the reporting and data systems and deliver accurate and time-saving solutions through the data warehouse.
Serve as a mentor to less experienced data warehouse technicians to develop their skills. Act as a resource for the team by providing advice and guidance on programming issues and concerns. Brainstorm solutions with the team and provide feedback as needed. Qualifications
An undergraduate degree in a related field or an equivalent combination of training and experience.
A minimum of 3 years related data warehouse development, data modeling or SAS programming experience.
Previous financial services industry experience a plus.
Strong working knowledge of SAS technologies including Base SAS, SAS DI Studio, SAS Data Management, DataFlux, Integration Technologies, Enterprise Guide, and Metadata Server.
Excellent verbal, written, and interpersonal communication skills.
Self-motivated with the ability to effectively work independently and as a team member in a multi-tasking environment.
Proficient in Microsoft Office suite, e.g. Excel, PowerPoint, Word, Outlook
The Bancorp is an Equal Opportunity EmployerVEVRAA Federal ContractorWe Request Priority Protected Veteran and Disabled Referrals for all of our locations
Associated topics: data architect, data center, data integration, data integrity, data manager, data quality, data scientist, erp, mongo database administrator, teradata