Technical Services Specialist
Core
Design, build, and test data warehouse and business intelligence solutions for commercial real estate and facility management clients, focusing on ERP integration, automation, and reporting.
Role type
Senior IC data engineer and BI specialist
Builds
Production BI dashboards, automated data pipelines, and ERP integrations for Strategy, Portfolio Administration, and Facilities service lines
Domain
Commercial Real Estate / IWMS / Business Intelligence
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Data warehouse design, Business Intelligence, ETL/ELT, SQL (T-SQL), Python scripting, Alteryx, Power BI, DAX, Data modeling, ERP system knowledge, Visual Studio debugging
Preferred skills
C#/.NET, Microsoft Dynamics 365, Tableau, Qlikview, ServiceNow, Project Management, ITIL
Technologies
Microsoft Dynamics 365, Alteryx, Python, SSIS, Power BI, DAX, SQL Server, Visual Studio, Tableau, Qlikview, ServiceNow, Lease Harbor, Tririga, CoStar, Expesite, Primavera, Archibus, FM:Systems
Responsibilities
Create technical specifications for functional requirements; build data models and measures in DAX; conduct root cause analysis on code level; manage data migration and validation; develop automation scripts; create reports and dashboards; support client delivery and implementation; maintain existing BI solutions
Seniority
Mid-Senior, hands-on IC