The Data Architect Manager will work with developers and technical managers to determine logical and physical database designs for new business solutions, data architecture design and maintenance, coordinating, leading and supporting project teams in the development of the application. This individual will also lead a team of database and ETL developers and designers to design, implement, optimize new and existing database solutions and will work with DBA on configuration and database architecture.

Job Description

• Manage logical and physical database design and analysis for all projects in all account/product groups, including new projects and ongoing enhancements within existing databases.
• Maintain changes to all database designs within a meta-data repository for existing and new schemas.
• Maintain, enforce, and enhance corporate database design and naming standards.
• Maintain the development and support of production jobs that load data to the application-specific databases, and the development and support of common data loads.
• Maintain client and system-wide common tables and associated views.
• Manage personal queue of requests/tickets.
• Lead DA team members with questions/issues regarding their requests/tickets. The team receives requests from multiple development teams and the DA team manager must be able to multi task to help address them.
• Review requests to determine if the request meets standards and/or is not already implemented via other existing solution (tables or jobs)
• Identify which common tables are needed by a project and how to replicate/filter them.
• Implement changes to schema tables, following DA policies and Procedures, in the meta-data repository and development databases
• Identify and manage data quality issues
• Lead DA team members in the design and implementation of complex data cleansing (name and address standardization, merging and house holding) processes.
• Contain problems by quickly identifying the source of the problem, correct the problem, put measures into effect to prevent future problems, and communicating all steps of the problem resolution process to all affected parties in a calm, professional manner.
• Proactively look for potential problem areas and take action to reduce or eliminate them.
• Ensure that all departmental processes are followed. Communicate and collaborate with the DA team on new processes that need to be developed when a process is lacking or ineffective.
• Lead team of other Data Architects, coordinate their work activity, and be responsible for mentoring and performance evaluation.
• Provide mentoring in design practices for other Data Architects
• Perform other related duties as required and assigned
• Demonstrate behaviors which are aligned with the organization’s desired culture and values

Ideal Candidate will have the following:

• Demonstrated understanding of database normalization methods (i.e., 3NF, Dimensional)
• Demonstrated experience in Star Schema design.
• Experience with Analystics, ETL tools and reporting platforms.
• Heavy exposure to data engineering practices and tools (ETL, data cleansing and standardization, merge/purge processing, etc.)
• Must be highly proficient in Excel and Word
• Must be a team player with strong attention to detail and able to work independently
• Proven track record at delivering timely and accurate information in a fast-paced environment
• Excellent critical thinking, problem solving, mathematical skills and sound judgment
• Financial Services and, if possible, mortgage industry experience preferred
• Strong business acumen and ability to interface with executive management