Data & Proptech Analyst

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

Full-Time | Data Engineering, Automation & Real Estate Technology

About the Role

We are looking for a Data & PropTech Analyst to join our growing technology team and help build the data workflows, automations, integrations, and reporting solutions that support real estate operations and technology initiatives.

This is a hands-on individual contributor role that combines data analysis and engineering, workflow automation, API integrations, and business intelligence. You’ll work with real-world data from multiple sources, develop solutions that improve operational efficiency, and create dashboards that turn complex information into actionable insights.

The ideal candidate is someone who enjoys solving problems, working with messy data, building practical automations, and translating business needs into reliable technical solutions.

What You'll Do

• Clean, standardize, transform, and de-duplicate data from multiple sources using Python and SQL.
• Build and maintain data scripts, workflows, and pipelines that move information between systems and databases while maintaining data quality and integrity.
• Develop and maintain workflow automations connecting internal systems with external APIs and services.
• Use Google Apps Script and/or low-code automation platforms to streamline repetitive processes.
• Build and maintain Power BI dashboards and reports that provide visibility into campaign performance, sales pipelines, lead activity, and operational 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 identify practical solutions.
• Collaborate with internal teams to understand business requirements and translate them into effective data and technology solutions.
• Occasionally work directly with clients or stakeholders to understand requirements, explain solutions, and support ongoing projects.
• Continuously identify opportunities to improve data processes, reporting accuracy, and operational efficiency.

What We're Looking For

• Strong proficiency in Python, particularly for data cleaning, transformation, automation, and API integrations.
• Solid working knowledge of SQL and experience writing queries against relational databases.
• Strong Power BI experience is required, including dashboard and report development.
• Experience with Google Apps Script or similar tools for automating spreadsheet- and document-based workflows.
• Experience working with REST APIs and third-party integrations.
• Strong attention to detail and the ability to work confidently with messy, inconsistent, or incomplete datasets.
• Analytical and problem-solving mindset with a focus on practical solutions.
• Strong written and verbal communication skills.
• Ability to work independently while collaborating effectively with cross-functional teams.
• Ability to understand business requirements and turn them into functional technical solutions.

Nice to Have

• Experience with Zoho Analytics or other BI/reporting platforms.
• Experience with no-code or low-code automation platforms.
• Experience with serverless or edge functions.
• Experience with low-code application builders.
• Previous experience in real estate, PropTech, MLS data, or real estate technology.
• Familiarity with CRM, lead generation, marketing automation, or real estate technology platforms.
• Experience working with large or complex datasets from multiple sources.

Why Join Us?

• Work at the intersection of data, automation, AI, and real estate technology.
• Take ownership of meaningful projects and see your solutions directly improve business operations.
• Work with modern data, automation, BI, and API technologies.
• Gain exposure to real-world PropTech and real estate data challenges.
• Collaborate with both technical and business stakeholders.
• Be part of a growing, technology-driven environment where your ideas and problem-solving skills can make a real impact.

The Ideal Candidate

You are a data-driven problem solver who enjoys figuring out how systems connect and how processes can be made better. You are comfortable moving between Python, SQL, APIs, automation tools, and Power BI, and you don't need everything to be perfectly structured before you start solving the problem.

If you enjoy building, automating, analyzing, and improving, we'd love to hear from you.