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