Senior Data EngineerThe Senior Data Engineer is responsible for designing, building, and optimizing scalable data pipelines and cloud-based data systems that support analytics and data-driven decision-making across the organization. This role requires expertise in data architecture, ETL development, and modern cloud technologies, with a focus on ensuring high-quality, reliable, and efficient data solutions. The ideal candidate will have strong proficiency in Python, SQL, AWS services such as S3 and Redshift.
Experience integrating Salesforce data and working with orchestration tools such as Airflow or AWS Glue is also highly valued.In this role, the Senior Data Engineer will collaborate closely with data analysts, scientists, software engineers, and business stakeholders to improve data accessibility, performance, and scalability.
Key responsibilities include developing and maintaining automated ETL frameworks, managing enterprise data products, implementing DevOps and CI/CD practices, and ensuring data quality and governance standards are met. The position also involves researching and adopting emerging technologies to continuously enhance the organization's data infrastructure and operational efficiency.The ideal candidate will possess strong problem-solving abilities, excellent communication skills, and experience working within agile development environments. Preferred qualifications include certifications in cloud or data engineering platforms, familiarity with non-relational databases and OpenSearch technologies, and exposure to business intelligence tools such as Tableau or Power BI. Success in this role will be measured by pipeline performance, data reliability, cross-functional collaboration, and contributions toward innovation and infrastructure optimization.1. Pipeline Development & Data Integration (50%) Design, develop, optimize, and maintain scalable ETL/ELT pipelines and cloud-based data integrations across enterprise systems, APIs, and operational platforms including Yardi and Salesforce. Build reliable, high-performance workflows that support the movement and transformation of data from SQL Server and other source systems into AWS-based analytics platforms including Redshift and S3.Key Areas:ETL/ELT pipeline development and optimizationSQL Server, API, Yardi, Salesforce, and third-party integrationsAWS S3 and Redshift data workflowsAirflow and AWS Glue orchestrationPipeline monitoring, reliability, and SLA management2. Collaboration with Analytics, Data Science, and Stakeholders and Data Enablement 30% Develop and maintain enterprise datasets, models, and transformation frameworks while partnering with Analytics, Data Science, AI Initiatives, and Business teams to refine requirements, improve data accessibility, and deliver trusted datasets that support reporting, analytics, and operational decision-making.Key Areas:Data modeling and warehousingData quality, governance, and documentationCross-functional collaboration with business, analytics and AI teamsDataset refinement and business requirements gatheringSupport for BI, AI/ML, and operational analytics initiatives3. Architecture, Strategic Initiatives & Operational Excellence (20%) Contribute to enterprise data platform and strategy through participation in large-scale initiatives, complex integration design, and modernization of data infrastructure. Support scalable and reliable operations through DevOps, automation, CI/CD, and infrastructure management best practices.Key Areas:Enterprise data architecture and integration designStrategic technology evaluation and innovationInfrastructure automation and CI/CD practicesDocker, Terraform, and deployment managementAgile/Scrum participation and operational supportEducation:Undergraduate (Bachelor) Degree in MIS, Computer Science, Information Technology requiredWork Experience:5 - 7 Years of experience developing ETL & System Integration pipelines required5 - 7 Years of experience designing, building, and improving large data models in complex environments required5 - 7 Years experience with Cloud Technologies like Airflow, Glue, or similar ETL Tools5 - 7 Years of experience with SQL, Redshift, Snowflake or similar data warehouse solutions required5 - 7 Years of experience developing complex Python code to support various integration needsTravel:Travel up to 20% of the time; rarely travelGreat Incentives!Brookfield Properties cares about the well-being and work-life balance of our valued associates! To show how much we care, we offer awesome incentives that include:Full benefits packageGenerous paid time off401(k) with company matchGrowth and advancement opportunitiesEqual Opportunity Employer: Minorities/Religion/Sex/Protected Veterans/Disability/Sexual Orientation/Gender Identity/Marital Status/Pregnancy/Age/National Origin/Genetic Information. Drug free workplace