Main Duties & Responsibilities:
- Provide subject matter expertise with data exchange challenges with Cloud SaaS/PaaS providers
- Analyze data sources (including data profiling), requirements and business rules, and perform logical data modeling mapping and gap analysis
- Assume the role of subject matter expert (SME) on emerging data related technologies
- Develop logical data models, metadata definitions and models
- Ensure development and maintenance of robust data architecture documentation using ER/Studio and ER/Business Architect
- Design and develop solutions that identify data issues and report errors for further analysis
- Collaborate with other data architects for data model management, version control, and potential system interactions
- Partner with data architects to instill industry best practices and generally accepted procedures across the enterprise
- Provide guidance on steering existing data dependencies into future API based interaction solutions
- Analyze system architectures and their relationships to database needs
- Collaborate with application teams to create source to target mapping documents
- Collaborate with application and services teams to design databases and interfaces which fully meet business and technical requirements
- Research, collect and document current state data architecture, data dependencies, and processes
- Specify the approach(es) that will be used to address data migration requirements
- Develop and document a plan to evolve current data architecture to an improved future state data architecture which meets established, developing, and anticipated needs
- Establish standards, policy, and processes for data architecture use concerning transport methods, platforms, monitoring standards, recovery requirements, data privacy, encryption, security and overall effectiveness/efficiency particularly with respect to cloud dependencies.19)
- Provide consultation on future data architecture strategies
Qualifications:
- Experience working with cloud to on-premise data dependencies
- Demonstrated ability to handle multiple priorities and stakeholders
- Working experience with SalesForce.com is desired
- Experience in reverse engineering of existing source system data structures
- Experience in conducting data model reviews with project team members
- Experience in providing API based data access solutions around “eventual consistency ” concepts
- Experience designing data model solutions for various transactional and/or analytical databases
- Strong data analysis skills
- Experience with data modeling tools, such as ER Studio
- Expert understanding of RDBMS and ETL concepts
- Experience in application software development methodologies, techniques, processes and tools