Assistant Vice President, Data Engineer

Responsibilities

• Designing, building, and maintaining scalable and efficient data pipelines to extract, transform, and load (ETL) data from various sources into Enterprise Data Platform (EDP).
• Designing and implementing data marts, including dimensional modeling, schema design, and optimization techniques.
• Integrating and consolidating data from diverse sources, such as databases, sftp’s, APIs, and streaming platforms, ensuring data quality, consistency, and integrity.
• Creating and maintaining data models, defining data structures, relationships, and data storage requirements, using techniques like entity-relationship diagrams and data flow diagrams.
• Developing data transformation processes, including data cleansing, normalization, aggregation, and enrichment, to prepare data for analytics and reporting.
• Identifying and resolving performance bottlenecks in data processing and storage systems, optimizing query performance, and improving overall data pipeline efficiency.
• Implementing data quality assurance processes, performing data validation, testing data pipelines, and resolving data quality issues.
• Monitoring data pipelines, diagnosing and troubleshooting issues, performing system upgrades and maintenance tasks to ensure data reliability and availability.
• Collaborating with cross-functional teams, including Business Liaisons, analysts, and software engineers, and documenting data engineering processes, workflows, and best practices. Supports training of Harrison Street team members on how to properly organize findings and read data collected.
• Partners with Technology Infrastructure and Support Operations team to identify, design, and implement internal process improvements: e.g., automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability.
• Partners with Technology Infrastructure and Support Operations teams to build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Microsoft Fabric.
• Understand how Harrison Street’s data platform integrates within the overall technical architecture.

Data Visualization

• Solid understanding of data visualization principles, best practices, and design aesthetics.
• Develop, maintain, and manage advanced reporting, analytics, dashboards using Tableau and Power BI.
• Perform data analysis and validations.
• Ability to translate business requirements into technical solutions and effectively communicate with stakeholders.
• Experience in data analysis and interpretation to drive actionable insights.

Project Management

• Work closely with stakeholders to define project goals, scope, and deliverables.
• Create project plans, tasks, and timelines using Azure Dev Ops.
• Monitor progress to ensure timely completion of milestones and deliverables.
• Conduct meetings, provide progress reports, and manage expectations to ensure alignment and stakeholder satisfaction.
• Develop risk mitigation and contingency plans to address potential setbacks.
• Apply organizational and communication skills to ensure project objectives are met, and deliverables are of high quality within the defined constraints.

Cybersecurity Collaboration

• Collaborate with the Cybersecurity team to adhere to organizational security standards, secure coding practices, and compliance requirements.
• Work jointly with Cybersecurity teams on authentication, authorization, identity management, and secure Enterprise Data Platform development.

Miscellaneous

• Stay current on emerging technologies for data architecture, data engineering, cloud services, security practices, and AI platform capabilities.
• Document system configurations, platform architectures, processes, and operational procedures.
• Participate in training, workshops, and internal knowledge-sharing sessions.
• Perform other duties as assigned to support evolving business and technology needs.