Tasks & Duties
• Review, analyze, and document the current data architecture across all relevant systems, including existing data model designs, data integrations, and data flows. Validate and document findings and gaps between the current state and business requirements.
• Translate business requirements into recommendations, enhancements, and technical specifications. Define the desired future state of the data architecture that aligns with business objectives and requirements.
• Create, document, and implement data management processes and procedures.
• Ensure database adheres regulations and security standards when dealing with PII data.
• Identify database gaps by evaluating client operations and application workflow.
• Develop/Modify database model to support scalability and security.
• Implement effective use geocoding and address validation tools, including the NYC Department of City Planning (DCP) Geographic Online Address Translator (GOAT), to correct and/or normalize landlord & property address information.

Required Skills
• Minimum 4 Years Experience in Data Modeling and Database Design
• Minimum 4 Years Experience in all phases of data modeling, from conceptualization to database optimization.
• Minimum 4 Years MS SQL programming experience
• Minimum 4 Years Experience in data visualization and data integration.
• Minimum 4 Years Proficiency with a statistical software package, such as R, SAS, Stata, SPSS, or MATLAB
• Minimum 4 Years Experience with database design and development
• Minimum 4 Years Able to work in a fast-paced environment and respond to multiple stakeholder groups
• Minimum 4 Years Ability to be creative, flexible, strategic, collaborative, and innovative
• Minimum 4 Years Excellent organizational, interpersonal, and communication skills