Strategic BI Data Architect - Snowflake & Power BI

Level60 Consulting; Bogotá ciudad; Presencial; COP 60.000.000 - 120.000.000; Jornada completa

Descripción de la vacante

Level60 Consulting is seeking a Business Intelligence Data Developer to design, build, and maintain curated data layers and semantic models powering enterprise reporting across the Inspire Brands portfolio. You will own the reporting foundation with Snowflake views and Power BI models, ensuring accurate, scalable, secure data for business consumption.

You will collaborate with stakeholders and data teams, implement governance, security, and CI/CD, and optimize performance through incremental

Formación

• 4-year degree in CS/IS/Analytics/Business/Stats/Engineering or related field.
• Preferred: Microsoft or Snowflake certification (Power BI Data Analyst Associate, Fabric Analytics Engineer Associate, SnowPro Core).
• Minimum: 3+ years building semantic models or curated reporting layers in Power BI and a cloud data warehouse, with strong SQL.
• Preferred: 5+ years BI/analytics engineering experience in multi-brand retail/restaurant/franchise setting.

Responsabilidades

• Build and maintain curated Snowflake views that serve as the foundation for downstream Power BI work.
• Match the grain of every view and model to how the business analyzes performance across brand, region, period, and franchisee.
• Build Power BI semantic models on top of those views, including relationships, measures, calculations, and metadata.
• Implement row level security in Power BI models, covering brand, region, and franchisee scope.
• Write efficient SQL and DAX; profile queries, tune joins, and optimize measure context transitions.
• Implement data quality checks across views and models, including row counts and referential integrity.
• Coordinate with reporting engineers as primary consumers of these models; communicate changes early.
• Coordinate with upstream data platforms on schema changes, late arriving data, and deployment windows.
• Document every view and semantic model, including grain, source, refresh cadence, and owner.
• Contribute to modeling standards and code reviews across Snowflake and Power BI.
• Handle multiple brands/domains and meet delivery dates.
• Stay current on Snowflake and Power BI capabilities and bring useful options into the team.

Conocimientos

SQL

Power BI

Snowflake

DAX

Data modeling

CI/CD

Git

Educación

Bachelor's degree in CS/IS/Analytics/Business/Stats/Engineering or related field

Microsoft or Snowflake certification (Power BI Data Analyst Associate, Fabric Analytics Engineer Associate, SnowPro Core)

3+ years of experience building semantic models with Power BI and a cloud data warehouse

Herramientas

Power Query (M)

Azure/AWS/GCP

Snowflake features (materialized views, dynamic tables)

Descripción del empleo

Level60 Consulting is seeking a Business Intelligence Data Developer to design, build, and maintain curated data layers and semantic models powering enterprise reporting across the Inspire Brands portfolio. You will own the reporting foundation with Snowflake views and Power BI models, ensuring accurate, scalable, secure data for business consumption.

You will collaborate with stakeholders and data teams, implement governance, security, and CI/CD, and optimize performance through incremental