Security, data integrity, and governance are core pillars of this role. This is a senior, hands-on position for someone who thrives in building modern data platforms and enabling business decision-making through analytics and AI.

Key Responsibilities

Data Architecture & Modeling

• Design and maintain enterprise-grade data models, including dimensional models, star schemas, and data vault architectures
• Build and optimize Snowflake data warehouse structures for scalability, performance, and cost efficiency
• Define data standards, naming conventions, and modeling best practices
• Ensure data reliability, availability, and long-term maintainability

ETL & Data Engineering

• Lead end-to-end data pipeline development using Matillion
• Integrate data from multiple sources, including ERP systems, CRMs, APIs, flat files, and streaming sources
• Build automated, fault-tolerant, auditable data pipelines
• Optimize data transformation processes for performance and cost

Analytics & Business Intelligence

• Develop advanced analytics solutions and dashboards using Qlik Sense
• Translate business requirements into clear KPIs, metrics, and analytics models
• Enable self-service analytics for business users
• Ensure data accuracy, consistency, and trust across all reporting

AI & Advanced Analytics

• Design and implement AI agents powered by internal company data
• Build secure and scalable RAG (Retrieval-Augmented Generation) pipelines
• Integrate with AI platforms such as OpenAI, Azure AI, and AWS Bedrock
• Develop intelligent data products including chatbots, insight engines, and forecasting tools
• Ensure AI outputs are explainable, auditable, and aligned with business needs

Security, Governance & Compliance

• Implement data access controls, encryption, and data masking
• Ensure compliance with applicable regulations such as GDPR, SOC 2, and HIPAA (if applicable)
• Design and maintain data governance frameworks and data lineage tracking
• Monitor data quality and integrity across the platform
• Partner with security teams to prevent data leaks and unauthorized access

Project Ownership & Collaboration

• Own data initiatives from requirements through design, build, deployment, and support
• Work cross-functionally with Product, Finance, Operations, and Engineering teams
• Document data architecture, processes, and standards
• Mentor and support junior engineers and analysts

Required Qualifications

• 7+ years of experience in data engineering or analytics architecture
• Strong hands-on experience with:

Snowflake, including performance tuning and cost optimization

Matillion for ETL orchestration

Qlik Sense / Qlik Analytics

• Advanced SQL expertise
• Strong data modeling experience (Kimball, Data Vault)
• Experience building AI-driven data solutions
• Working knowledge of:

Python

APIs

Cloud platforms (AWS, Azure, or GCP)

• Experience with CI/CD for data pipelines
• Proficiency with Git and version control
• Experience with Infrastructure as Code (Terraform preferred)
• Strong understanding of data security and governance
• Excellent communication and stakeholder management skills

Preferred Qualifications

• Experience building AI chatbots and RAG pipelines
• Familiarity with vector databases such as Pinecone, Weaviate, or FAISS
• Experience with dbt, Airflow, or Kafka/streaming pipelines
• Snowflake and/or Qlik certifications
• Experience working in regulated industries

What Success Looks Like

• A scalable and trusted data warehouse supporting analytics and AI workloads
• High-performing Qlik dashboards adopted across the organization
• Reliable, automated Matillion pipelines
• Production-ready AI agents using internal company data
• A secure, governed, and compliant data environment
• Business teams confidently making data-driven decisions

Soft Skills

• Strong sense of ownership and accountability
• Strategic thinker and problem solver
• Ability to translate complex technical concepts to business stakeholders
• Comfortable leading initiatives independently
• High attention to detail

This is a contractor role, remote, open to those who are living in Columbia and Brazil.