SQL Data Architect

SQL Data Architect

Responsibilities

• Facilitate collaboration for development of long-term strategic plans of production databases in conjunction with data owners, business units, IT product owners, and Enterprise Architecture
• Participate in enterprise information architecture discussions around needs and alignment to business goals
• Collaborate with Database Administrators and other staff to resolve data issues, performance issues and to ensure the highest possible degree of data integrity
• Validate and fix information management issues related to data quality framework (completeness, accuracy, availability, timeliness, consistency, etc.)
• Assist business units and project management in developing the budget projections based on short- and long-term goals and objectives
• Develop and maintain data models and data flows that represent essential data consumed and produced
• Develop and maintain documentation that maps data models to information systems and business applications
• Be resourceful in the use of enterprise data, including guidance in understanding and exploitation of the underlying data and business models, and identifying optimal data sourcing and mapping
• Analyze the logical and physical database models to ensure models are in accordance with standards
• Assist in building of enterprise architecture information blueprints that illustrate how information is stored, processed, and accessed.

Qualifications

• Bachelor's degree in a technical field or equivalent work experience
• 5+ years of experience as a Data Architect/Data Engineer
• 10 years of strong working knowledge of Microsoft SQL server, SSIS and SSAS (multidimensional model)
• In-depth understanding of database structure principles
• Ability to write complex SQL queries for ETL or reporting
• Familiarity with data visualization tools (eg Tableau, XLCubed, ESRI, SSRS etc.)
• Familiarity with Python for data analysis is a plus
• Experience with Yardi or any other Real Estate Property/Accounting/Asset Management system is a plus

If this is an opportunity that you're interested in please email your resume to:

(see below)