Data Engineer at DivcoWest

View job on Handshake

Employer: DivcoWest

Expires: 04/01/2020

JOB SUMMARYDivcoWest is looking for a savvy Data Engineer to join our growing team of analytics experts. The hire will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder who enjoys optimizing data systems, and building them from the ground up. The hire must be self-directed and comfortable supporting the data needs of multiple teams, systems and products.ESSENTIAL DUTIES & RESPONSIBILITIESCreate and maintain optimal data pipeline architectureIdentify, design and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalabilityDesign, develop, and deploy a high-volume ETL pipelining system to manage complex real-time, data collectionWork with stakeholders including the Executive, Data and Infrastructure teams to assist with data-related technical issues and support their data infrastructure needs Cross-train with the rest of the data team members, to support business functions during team members absenceStay current with developments in new market trends and innovations in technology, especially those related to commercial real estateSKILLS AND ABILITIESAdvanced working SQL knowledge and experience working with relational databases A successful history of manipulating, processing and extracting value from large disconnected data setsExcellent oral and written communication skills, including the ability to explain technology solutions in business terms and translate business requirements into technical specificationsProven analytical and problem-solving abilities with keen attention to detailsKnowledge of commercial real estate operations an assetMicrosoft SQL Server 2012 or Highero  Data warehouse design, development and maintenance, optimization for reporting and analysiso  SQL Server Integration Services (SSIS) – ETL design, development and maintenanceo  SQL Server Analysis Services (SSAS) – OLAP cube design, development and maintenanceo  SQL Server Reporting Services (SSRS) – web enabled report design, development and maintenanceStrong Microsoft Excel skills including Visual Basic for Applications competencyProficient designing, implementing custom REST-ful APIs for usage in integrations with cloud/web-based 3rd party applicationsAdept at consuming 3rd party web-based APIs and integration end points (REST-ful, SOAP, SFTP file transfer, etc.) Proficiency with Microsoft C#, .Net Framework preferred.Familiarity with MRI real estate enterprise resource planning (ERP) system a plusQUALIFICATIONSBachelor’s degree in Information Technology, Software Engineering, Computer Science or related field or higherAt least 4-5 years of experience in IT, preferably within 1 or more commercial real estate organizationsExperienced with systems integrations, business intelligence systems, and database managementDivcoWest is an Equal Opportunity Employer. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical​ condition, pregnancy, genetic information, gender, sexual orientation, gender identity or ​expression, veteran status, or any other status protected under federal, state, or local law.Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.