Power BI Lead (Teradata, Snowflake, Microsoft Fabric)

Power BI Lead (Teradata, Snowflake, Microsoft Fabric)

Location: 100% Remote - Mexico or South America (Brazil, Argentina, Chile, Colombia, Peru, Uruguay, Ecuador)

Engagement: Contract, long term, full time

Hours: US Central Time working hours

Experience: 10+ years in BI / data; 6+ years hands-on Power BI; 3+ years leading a BI team

Language: Fluent spoken and written English (client-facing daily); resume in English

Based in: Mexico or South America

Screening: Technical screen on DAX, data modeling and Teradata / Snowflake SQL

About The Role

Our client, a large US consumer products and retail company, is looking for a Power BI Lead to own its enterprise reporting. You will lead a team of Power BI developers and BI analysts, act as Scrum Master, and help move legacy BI to Microsoft Fabric.

Responsibilities

• Lead design and delivery of enterprise Power BI solutions: dashboards, executive reports and operational analytics.
• Build data models (star / snowflake schema), advanced DAX measures and Power Query transformations.
• Build semantic and composite models with Import, DirectQuery, Direct Lake and incremental refresh.
• Set Power BI governance: workspaces, security (RLS / OLS), deployment pipelines and CI/CD from dev to production.
• Tune report rendering, dataset refresh and DAX query performance.
• Write and tune complex SQL, views and stored procedures on Teradata and Snowflake. Read query plans, statistics and indexing.
• Validate reports against source systems and reconcile data differences.
• Build analytics on Microsoft Fabric (Lakehouse, Warehouse, OneLake, SQL endpoint). Bring in data from Teradata, Snowflake and other sources.
• Manage and mentor the BI team: assign tasks, set standards, run code and design reviews, remove blockers.
• Act as Scrum Master: run sprint planning, stand-ups, reviews and retrospectives. Manage the backlog with Product Owners, estimate effort and plan capacity.
• Work with business stakeholders, architects, DBAs and platform teams. Turn business needs into user stories and BI solutions.
• Own production support: refresh failures, performance issues, monitoring, alerts, release readiness and documentation.

Required

• 6+ years hands-on Power BI (Desktop + Service), with advanced DAX, Power Query and data modeling.
• RLS / OLS, deployment pipelines, Import / DirectQuery / Direct Lake.
• Strong SQL on Teradata and Snowflake, including performance tuning.
• Hands-on Microsoft Fabric (Lakehouse, Warehouse, OneLake, Direct Lake).
• 3+ years leading and mentoring a BI / Power BI team.
• Scrum Master experience: sprint planning, backlog, capacity planning, delivery risk.
• Strong stakeholder communication.

Preferred

• Retail domain experience.
• Scrum Master certification (CSM / PSM) or Microsoft Power BI / Fabric certification (PL-300, DP-600).
• Experience moving legacy BI or a data warehouse to Fabric.

Interview process

Recruiter screen technical round (Power BI, DAX, SQL) client manager round.