About the Role
IANS is looking for a Data Engineer / Data Architect Consultant to build the foundational data architecture that powers all of our products as we become a data-first company. You'll design and implement scalable data systems across Azure SQL Server, PostgreSQL, Elasticsearch, Salesforce integrations, and Azure cloud services — creating the infrastructure that enables initiatives like content metadata enrichment, new data-driven product offerings (e.g., Vendor Intelligence), analytics, and AI/ML workloads. This is about building the foundation once and building it right, so it scales across everything we do. This is a full-time, ongoing consulting engagement — we hire contractors to keep them as long as we can.
What You'll Do
- Design and build a scalable, org-wide data architecture that serves as the backbone for all current and future products.
- Design, build, and maintain data pipelines and ETL/ELT processes across Azure SQL Server, PostgreSQL, Elasticsearch, and third-party sources (Salesforce, APIs).
- Evaluate and support a potential migration from MSSQL to PostgreSQL, including feasibility analysis, schema translation, deadlock remediation, performance benchmarking, and migration planning.
- Build and maintain a centralized data warehouse or data platform to support analytics, reporting, AI/ML workflows, and our broader data-as-a-service:
- Architect metadata models, taxonomies, and tagging systems that enable content enrichment across products (e.g., tagging content with vendors, team size, revenue, industry).
- Collaborate with engineering, product, and AI teams to define data models and ensure clean, consistent data flows across systems.
- Implement data quality checks, monitoring, and alerting to maintain data integrity across all data products.
- Document data architecture, lineage, and dictionary standards for the engineering team.
- Support and improve existing Azure SQL databases, Redis caching layers, and Elasticsearch clusters.
- Id
📌 Data Engineer (Bogotá)
🏢 IANS
📍 Bogotá