Senior BI & Data Integration Lead

We are looking for a highly autonomous Senior BI & Data Integration Lead to act as the technical right hand for a growing consulting team serving SMB clients. This role combines senior-level Power BI development, data integration, automation, and business analysis. You will work independently during the initial transition period, then help structure workflows, documentation, and mentoring practices for future junior data team members. The dashboards and reports you build will support executive and CEO-level decisions, so accuracy, structure, and analytical rigor are essential.

Duties / Task to perform

• 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

• 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.

Schedule & availability

Part-time: Monday to Friday, 8:00 AM to 12:00 PM (GMT -5-00) Eastern Time (US & Canada), Bogota, Lima; with strong potential to transition to full-time in the future.

Benefits

• 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

📌 Before You Apply, Please Read:

At Freelance Latin America, we’re excited to connect you with meaningful remote opportunities. However, we want to be clear:

⏰ These are professional roles with set schedules defined by the client.
Consistent availability is expected. You will have a set work schedule determined by the client, and you are expected to be present during those hours.

🤝 You will be part of the client’s team.

You’ll follow their company guidelines, communication practices, and workflows, ensuring seamless collaboration.

📈 KPIs and goals matter.

Your performance will be measured to ensure alignment with client expectations and project objectives.

🧑‍🏫 Training may be required.

You might need to complete training to fully understand your role, tools, and client processes.

🎯 Commitment and responsibility are essential.
We work with clients who rely on your dedication to deliver consistent, high-quality results. This is key to building trust and long-term partnerships.

🚀 Ready to grow your career with us?

Apply only if you are ready to commit, learn, and take ownership of your role.