Freelance Latin America

Data Scientist

• Translate business briefs in English into clear technical plans, execution steps, and deliverables.
• Work independently during the first 2–3 months, managing active data projects from raw data review to final dashboard delivery.
• Design analytical data architectures, including dimensional models, star schemas, table relationships, and transformation strategies.
• Build real-time or near real-time Power BI dashboards and reporting solutions for executive decision-making.
• Develop advanced DAX measures and structure scalable Power BI semantic models.
• Define, calculate, and validate KPI logic such as cost of goods, waste, loss index, profitability by product/client/period, cash flow, and operational KPIs.
• Use Microsoft 365 tools to automate data intake, processing, and reporting workflows.
• Assess which tools, licenses, and technical resources are required for each project and advise on the most efficient setup.
• Review unstructured raw data files, identify inconsistencies, document gaps, and ask the right questions before moving forward.
• Validate all figures before delivery, ensuring zero calculation errors in client-facing dashboards and reports.
• Document assumptions, sources, formulas, data logic, workflows, and technical decisions for long-term maintainability.
• Establish working standards such as file structure, naming conventions, Git workflow, and reusable project kickoff templates.
• Support the future growth of the data team by helping onboard, delegate to, and supervise junior/intermediate profiles and additional support roles.
• Provide technical mentoring, feedback, and quality control once the team expands.

Senior BI & Data Integration Lead

General

• Build and manage ETL/ELT pipelines using tools such as n8n, Microsoft Power Automate, and SQL.
• Connect data sources through REST APIs, including OAuth authentication, JSON parsing, and webhook management.
• Query, clean, and manipulate data using SQL, including PostgreSQL or T-SQL.
• Prepare and transform complex datasets using advanced Power Query / M and Python before they feed into analytical models.
• Configure, monitor, and troubleshoot Power BI Gateway connections, refresh schedules, and pipeline errors.
• Create stable API integrations with third-party platforms such as ERP, POS, CRM, Excel, and SharePoint systems.
• Establish and follow standards for folder structures, API logging, documentation, Git workflows, branches, and pull requests.
• Document integration architecture, pipeline flows, data sources, and troubleshooting procedures.

Senior BI & Data Integration Lead

Data Integration Specialist