In this role, you will be responsible for designing and maintaining an enterprise-class data model. As part of this effort, they also reverse engineer complex new datasets, providing documentation to developers instructing how to map these new datasets to the existing model.
In this role, you will implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other distributed data like linked server issues.
The applicant will be working with the application developers on correct database access procedures and will be asked to write and debug Java code. The applicant may also support the test team by developing scripts that provide scenario data for their environment.
Lead design of exception handling and data cleansing / standardization procedures and business transformation rules and logic. Leads the development of processes to avoid redundancy in data elements, where applicable.
In this role, the selected candidate must have experience with meta data creation, management and governance inside and outside a tool; experience working with accounting SMEs and other non-technical personnel.
Ability to present solutions precisely to various levels of management and work across different groups as well as perform limited project management to implement the proposed solutions. Previous experience with database related project management desired.
Position requires the ability to provide technical architectural artifacts and supporting documentation in both Enterprise and Data designs for customer-based business requirements and priorities in accordance with standard development practices.
In this role, you will define enterprise data architecture vision, strategy, principles and standards of data management, MDM across various Line of Business Apps, ERP, get buy in from stakeholders. The successful candidate will design processes for data governance.
In this role, the selected candidate must have experience in developing, testing, and troubleshooting SQL Server Integration Services (SSIS) packages that implement complex Extract, Transform, and Load (ETL) processes.