Job Title: BI Developer / Analyst

Location: Medellín, Colombia

Work Mode: Work from Office

Experience Required: 8+ Years

Employment Type: Full-Time

About the Role

Key Responsibilities

- Design, develop, and maintain enterprise-scale BI solutions, dashboards, scorecards, and executive reporting platforms using Power BI, SSRS, and other BI technologies.
- Lead the architecture and implementation of data warehouses, data marts, and analytical data models.
- Develop and optimize complex SQL queries, stored procedures, views, and database objects for high-performance reporting.
- Design, build, and maintain robust ETL/ELT pipelines using modern integration tools and cloud technologies.
- Integrate data from multiple enterprise systems, including ERP, CRM, HR, Finance, and operational platforms.
- Follow best practices for data governance, data quality, metadata management, and master data management.
- Partner with stakeholders to gather business requirements and translate them into scalable analytical solutions.
- Implement and maintain cloud-based data platforms such as databricks, AWS, Azure, or GCP.
- Conduct data profiling, validation, and quality assurance activities to ensure data accuracy and consistency.
- Mentor junior BI developers and analysts while providing technical guidance and best practices.
- Support data migration, system modernization, and enterprise data transformation initiatives.
- Collaborate within Agile teams and participate in sprint planning, technical design reviews, and solution architecture discussions.

Requirements
- Bachelor's degree in Computer Science, Information Technology, Engineering, Data Science, or a related field.
- 8+ years of experience in Business Intelligence, Data Engineering, Data Warehousing, or Database Development.
- Strong expertise in SQL Server, PostgreSQL, Snowflake, or other enterprise database platforms.




- Advanced SQL programming skills, including performance tuning and query optimization.
- Proven experience designing and implementing ETL/ELT processes and enterprise data integration solutions.
- Hands-on experience with Power BI and enterprise reporting solutions.
- Strong understanding of data warehouse architecture, dimensional modeling, star schemas, and data marts.
- Experience working with cloud-based analytics platforms and data lakes.
- Knowledge of data governance, data lineage, metadata management, and data quality frameworks.
- Excellent problem-solving, analytical, and stakeholder communication skills.
- Experience working in Agile/Scrum environments.

Preferred Qualifications

- Experience with databricks, Snowflake, AWS S3, Azure Data Factory, Matillion, Airflow, or similar cloud data technologies.
- Experience implementing enterprise data governance and data catalog solutions.
- Knowledge of Python for data automation and analytics.
- Experience leading data migration and modernization projects.
- Exposure to healthcare, finance, logistics, or other highly regulated industries.
- Experience mentoring technical teams or serving as a technical lead.

Technical Skills Business Intelligence & Reporting

- Power BI
- SSRS
- Dashboard Development
- KPI Design
- Executive Reporting

Data Engineering & Warehousing

- ETL/ELT Development
- Data Warehousing
- Data Modeling
- Data Lakes
- Data Integration

Databases

- SQL Server
- Snowflake
- PostgreSQL
- MySQL

Cloud Technologies

- AWS
- Azure
- GCP

Programming & Automation

- SQL
- Python

Data Governance

- Data Quality
- Data Profiling
- Data Lineage
- Metadata Management
- RBAC Security

Nice-to-Have Domain Experience

- Healthcare Analytics
- Clinical Data Reporting
- ERP/CRM Integrations
- Enterprise Data Migration Projects
- Regulatory and Compliance Reporting

Job Type: Full-time

Language

- English (Required)

Work Location: In person

📌 BI Developer / Analyst (Medellín)
🏢 Interscripts
📍 Medellín