PropTech Data Engineer — Automation & BI Specialist

StratifyIQ; Bogotá; On-site; COP 60,000,000 - 120,000,000; Full time

Job summary

StratifyIQ is seeking a Data & PropTech Analyst to join our technology team in building data workflows, automations, integrations, and BI reporting for real estate operations and technology initiatives.

This hands-on role blends data analysis and engineering, workflow automation, API integrations, and BI. The ideal candidate enjoys solving messy data and translating business needs into reliable technical solutions.

Qualifications

• Strong proficiency in Python for data cleaning, transformation, automation, and API integrations.
• Solid knowledge of SQL and querying relational databases.
• Strong Power BI experience, including dashboard/report development.
• Experience with Google Apps Script or similar tools for automating workflows.
• Experience with REST APIs and third-party integrations.
• Ability to work with messy, inconsistent, or incomplete datasets.
• Analytical and problem-solving mindset with practical solutions.
• Strong communication skills and ability to work independently with cross-functional teams.
• Ability to translate business requirements into technical solutions.

Responsibilities

• Clean, standardize, transform, and de-duplicate data from multiple sources using Python and SQL.
• Build and maintain data scripts, workflows, and pipelines moving information between systems while preserving data quality.
• Develop and maintain workflow automations connecting internal systems with external APIs and services.
• Use Google Apps Script or low-code platforms to streamline repetitive processes.
• Build and maintain Power BI dashboards and reports showing campaign performance, sales pipelines, lead activity and KPIs.
• Work with Zoho Analytics or similar BI platforms when required.
• Integrate third-party systems and services through REST APIs.
• Support data-driven onboarding, outreach, reporting, and operational tools.
• Troubleshoot data, integration, automation, and reporting issues and propose practical fixes.
• Collaborate with internal teams to translate business requirements into data/tech solutions.
• Occasionally engage with clients or stakeholders to clarify requirements and explain solutions.

Skills

Python

SQL

Power BI

Google Apps Script

REST APIs

Data cleaning

Automation

Tools

Zoho Analytics

No-code/low-code platforms

CRM/Real estate platforms

Job description

StratifyIQ is seeking a Data & PropTech Analyst to join our technology team in building data workflows, automations, integrations, and BI reporting for real estate operations and technology initiatives.

This hands-on role blends data analysis and engineering, workflow automation, API integrations, and BI. The ideal candidate enjoys solving messy data and translating business needs into reliable technical solutions.