Marcum Search LLC has a high profile, International real estate equity firm with an immediate full time job opening for a full time in house Data Engineer.Essential Duties and ResponsibilitiesExpand and optimize our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. Optimize or in some cases re-design our company’s data architecture to support our digital transformation into the cloud and our next generation of applications and data initiativesExtensive hands-on experience in data warehousing design, ETL/ELT, BI process developmentBuilds foundational infrastructure for data pipelines Participate in enterprise data management (EDM) initiative(s)Work with business application software vendors and internal teams to build custom integrations between SaaS (Software as a Service) applications, on-premise systems, and enterprise data warehousePerform routine database administration to keep environments healthyAssist with Azure and other data cloud environment implementationsDocument data models across the company in a centralized location that is highly visible to stakeholdersHands-on experience implementing full-cycle cloud enterprise data warehousing (EDW) projectsWrite and maintain custom scripts to increase system efficiency and lower human intervention time on repetitive tasksParticipate in proof-of-concept testingQualifications and Experience5+ years of data architecture, data analysis, data modeling Bachelor’s degree in Engineering/Computer ScienceAzure Data Engineer Certification preferredExperience with Azure data factoryExpertise in building Automated Data pipeline by Metadata ingestion for analyzing & reportingHands-on technical experience with BI technologies (PowerBI, Tableau)Hands-on experience with databases in relation to cloud-based FP&A (Financial Planning & Analysis systems)Technical project/change managementShould be familiar with SQL, C, PowerShell, bash, and python scriptingMarcum Search LLC is an Equal Opportunity EmployerMarcum Search LLC does not discriminate on the basis of race, ancestry, national origin, color, religion, gender, age, marital status, sexual orientation, disability, veteran status, or any other protected classification under the law.JOBPOSTREF M