PowerBI and Data Analyst (FP&A and Business Systems)

OpenKrill; United States; Remote; USD 90,000 - 120,000; Full time

Benefits offered by this job

People Academy webinars

Wellness Week and programs

Culture Club events

Volunteer leave

Women into leadership programs

Awards ceremony

Job summary

TLC Worldwide is seeking a Power BI Data Analyst to transform how we use data across our business, focusing on Finance and FP&A reporting. Build scalable BI solutions and partner with Finance, Data and Technology to automate reporting workflows.

You will design dashboards, transform data from enterprise systems, and create semantic models to drive insights across budgets, forecasts and profitability analysis.

Qualifications

• Strong Power BI reporting experience for Finance/FP&A
• Advanced Power Query, DAX, and data modelling skills
• Strong SQL and data transformation ability
• Experience with Microsoft Dataverse or Dynamics 365 data
• Ability to translate business needs into scalable reports and dashboards
• Knowledge of FP&A concepts: budgets, forecasts, actuals, profitability analysis

Responsibilities

• Design, build and maintain Power BI dashboards and reports for Finance/FP&A
• Transform data from enterprise sources into trusted datasets
• Create semantic models and calculations to support decision making
• Cleanse and blend data from multiple sources using Power Query and SQL
• Develop reporting across revenue, budgets, forecasts, profitability and variance reporting
• Collaborate with Finance, Data and Tech to improve reporting processes

Skills

Power BI

Power Query

DAX

SQL

Dataverse

Dynamics 365

Data modelling

Tools

Azure Cosmos DB

Azure SQL

SQL Server

Power BI Service

Fabric Lakehouse

Job description

WE ARE HIRING A POWERBI AND DATA ANALYST (FP&A AND BUSINESS SYSTEMS)Ever opened a new bank account and got a weekend away? Spent on fashion and received a personal styling session? Picked up groceries and walked away with cinema tickets?If so, you’ve probably experienced a TLC Worldwide campaign - without even knowing it.At TLC, we help the world’s biggest brands drive customer acquisition, loyalty and engagement with emotionally engaging, experience-led rewards. From global banks to high street retailers, our programs are designed shift behaviour, boost ROI and build genuine brand love – at the fraction of the cost of discounting and cash offers. Backed by COSMOS, our all-in-one program platform, we deliver personalised campaigns at scale with live data, smart insights, and seamless customer journeys.We’ve spent 30 years mastering what moves customers; combining deep consumer insight, a global network of 100,000+ rewards, and a unique ability to drive measurable ROI for brands.We’re 400+ people strong, across 15 global hubs. A collective of marketers, creatives and strategists who care about doing great work - and having fun while we do it. We celebrate bold thinking, empower growth, and champion the kind of culture that helps people thrive.

Here are a few things that we've got to offer:

• Dynamic & collaborative team in a creative environment with exposure to global clients & colleagues - Check out our clients
• Weekly webinars to support your development through our People Academy
• Annual TLC Wellness Week and programmes throughout the year
• TLC Culture Club - including seasonal social events, tasty lunches & more
• TLC Gives Back - volunteering opportunities, including off site visits and volunteering leave
• TLC Rise - supporting and empowering women into leadership roles
• 'Frankies' - Our very own awards ceremony where we walk down the TLC red carpet in our best outfits
• TLC Owner's Club - Everyone that is part of the TLC experience contributes to our success, which is why we all own a piece of TLC as part of our share holder scheme

We're looking for a Power BI Data Analyst to help transform how we use data across our business. This is an exciting opportunity to build and shape our Finance and FP&A reporting capability, turning complex operational and financial data into trusted insights that inform smarter decisions across the organisation.

You'll sit at the intersection of Finance, Data and Technology, helping TLC move from manual reporting processes to automated, scalable and insightful business intelligence solutions.

Reporting & Business Intelligence

• Design, build and maintain engaging Power BI dashboards and reports focused on Finance and FP&A reporting.
• Transform data from Microsoft Dataverse, Cosmos DB and other enterprise systems into trusted, reporting-ready datasets.
• Create high-quality semantic models, dimensional data structures and DAX calculations that support business decision-making.
• Use Power Query, SQL and the Microsoft data ecosystem to cleanse, transform and combine data from multiple sources.
• Translate business requirements into meaningful reports, KPIs and analytical insights.
• Develop reporting across revenue, profitability, budgets, forecasts, costs, client performance, variance analysis and management reporting.

Data Quality & Continuous Improvement

• Ensure reporting outputs accurately reconcile back to source systems and can be trusted by stakeholders.
• Investigate and resolve data quality issues in partnership with Finance, Data and Technology teams.
• Optimise Power BI models and reports for performance, usability and scalability.
• Apply consistent KPI definitions, governance standards and appropriate security controls.
• Document datasets, business rules, calculations and reporting logic.
• Drive continuous improvement by identifying opportunities to automate and streamline reporting processes.

Partnering With The Business

• Collaborate with Finance, FP&A, Data, Technology and commercial teams across the organisation.
• Build strong stakeholder relationships and become a trusted advisor for reporting and analytics.
• Present insights and recommendations clearly to both technical and non-technical audiences.

Who we're looking for:Essential Experience

• Strong commercial experience developing Power BI reports and dashboards.
• Advanced skills in Power Query, DAX and Power BI data modelling.
• Strong SQL skills and the ability to investigate, validate and transform data independently.
• Experience working with Microsoft Dataverse, Dynamics 365 data or similarly complex operational datasets.
• Experience building reporting solutions that require substantial data preparation and transformation.
• Strong understanding of data modelling principles including star schemas, facts, dimensions and relationship design.
• Experience gathering requirements and translating business needs into scalable reporting solutions.
• Confidence working with financial data and partnering with Finance stakeholders.
• Understanding of FP&A and financial reporting concepts including budgets, forecasts, actuals, profitability analysis, variance reporting and management reporting.

Nice To Have

• Experience with Azure Cosmos DB, Microsoft Fabric, Azure SQL or SQL Server.
• Experience with Power BI Service administration, deployment pipelines or Dataflows.
• Experience with Fabric Lakehouse, Warehousing or modern Microsoft data platforms.
• Experience with source control, structured BI deployment practices or CI/CD.
• Exposure to budgeting, planning or FP&A systems.

At TLC, attitude is just as important as capability. We're looking for someone who is:

We're looking for someone who is:

• Curious about the story behind the data, not just the dashboard.
• Analytical, methodical and passionate about accuracy.
• Comfortable challenging assumptions and asking great questions.
• A strong communicator who can simplify complex concepts.
• Collaborative and relationship-focused.
• Continuously looking for smarter, faster and more scalable ways of working.
• Excited by the opportunity to build something rather than simply maintain it.

Being a people-led business, we hire upon values and believe that our people are what make the beloved TLC culture so unique.At TLC we aim to create a ‘world within the world’ that is free from prejudice, bias and inequity.A world where diversity is valued and celebrated, and where we work hard to ensure all our wonderful people are given equal opportunity to succeed.