We are looking for a Power BI Specialist to lead the business logic and analytical layer of a remote data platform for multi-site SMB reporting. This role transforms raw automated data into decision-ready financial and operational dashboards, with a strong focus on accuracy, business storytelling, and financial insight.

Duties / Task to perform

• Translate ambiguous business briefs into clear analytical requirements, dimensional models, and Power BI-ready structures.
• Design and maintain star schema models and semantic layers for financial and operational reporting.
• Build advanced DAX measures for financial KPIs, including time intelligence, contribution margin, variance analysis, COGS, profitability, and margins.
• Create executive dashboards and automated weekly management reports with clear business storytelling.
• Audit source data and validate calculations before delivery to ensure high accuracy and quality.
• Collaborate with data integration team members to define required table structures, views, and schemas.
• Document business rules, formulas, assumptions, definitions, and reusable Power BI patterns.
• Support future junior data roles through guidance, onboarding, and best-practice sharing as the team grows.

Requirements

• Advanced Power BI experience, including data modeling, semantic layers, and RLS.
• Expert-level DAX skills, including CALCULATE, variables, and time intelligence.
• Strong financial and operations analytics background, with understanding of COGS, profitability analysis, contribution margin, and variance analysis.
• Intermediate SQL skills to query, review, and validate data sources.
• Strong attention to detail and a quality-control mindset with a low tolerance for calculation errors.
• Ability to work independently in a startup-style environment and help build naming conventions, documentation standards, and workflows from scratch.
• Excellent written English communication skills for documentation, business briefs, and reporting.
• Fluent or professional English required.

Schedule: Monday to Friday, 8:00 AM – 12:00 PM (EST)

Benefits

• Fully remote work environment
• Stable, long-term collaboration with potential to scale
• Clear scope of responsibilities and structured workflows
• Training and onboarding support
• Opportunity to work with international teams
• Exposure to modern BI, analytics, and financial reporting 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.