Senior BI & Data Integration Lead

Freelance Latin America

Senior BI & Data Integration Lead serving SMB clients with focus on Power BI, data integration, and business analysis. Supporting executive decision-making with accurate dashboards and reports.

Posted 6/25/2026part-timeRemote • 🇻🇪 VenezuelaSeniorWebsite

Tech Stack

Tools & technologies

ETLPandasPostgresPythonSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

Expert-level Power BI Desktop experience, including advanced data modeling, DAX, semantic layers, and row-level security.
Expert knowledge of dimensional modeling and star schema design.
Advanced SQL skills, ideally with PostgreSQL and/or T-SQL.
Advanced Power Query / M language skills.
Intermediate Python / pandas experience for ETL and data transformation.
Intermediate Git experience, including branches, pull requests, and code reviews.
Intermediate Microsoft 365 knowledge, including SharePoint and Power Automate.
Experience using automation tools and workflows; Make experience is a plus.
Strong ability to build real-time or near real-time dashboards and automated reporting processes.
Experience working with complex business data across SMB sectors such as manufacturing, distribution, professional services, transport, or similar environments.
Ability to perform basic business analysis, including waste, losses, profitability, and operational performance calculations.
Strong technical judgment to recommend the right tools, licenses, and data architecture for each project.
Ability to read unstructured raw data files and quickly identify the underlying business logic.
Strong written English communication skills for briefs, documentation, feedback, and reporting.
Extremely autonomous, organized, and structured; comfortable working without close supervision.
Curious and proactive mindset, with the confidence to ask questions when data is ambiguous or incomplete.
Absolute rigor with numbers; deliverables must be fully validated before submission.
Ability to flag risks, gaps, inconsistencies, and assumptions before they become delivery issues.
Pedagogical mindset and ability to explain complex analytical concepts to junior team members.
Startup mindset: adaptable, fast-moving, and comfortable building structure from scratch.

Benefits

Comp & perks

Fully remote work environment
Stable, long-term collaboration
Clear scope of responsibilities and structured workflows
Training and onboarding support
Opportunity to work with international teams
Exposure to modern tools and professional processes
Supportive and collaborative work culture
Opportunity for skill development and career growth

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Power BIDAXdimensional modelingstar schemaSQLPostgreSQLT-SQLPower QueryPythonpandas

Soft Skills

written communicationautonomyorganizationcuriosityproactivityrigorpedagogical mindsettechnical judgmentbusiness analysisteam mentoring