Business Intelligence Data Developer (@ Inspire Brands)

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

The Business Intelligence Data Developer is responsible for designing, building, and maintaining the curated data layers and semantic models that power enterprise reporting and analytics across the Inspire Brands portfolio. This role owns the reporting foundation, including curated views in Snowflake and Power BI semantic models, ensuring data solutions are accurate, scalable, secure, and optimized for business consumption.

The position works across the analytics lifecycle, partnering with business stakeholders, reporting engineers, and data platform teams to gather requirements, develop data models, implement governance and security standards, and support enterprise reporting needs. The developer leverages SQL, DAX, Power BI, Snowflake, Microsoft Fabric, and modern data modeling practices to deliver high-quality analytics solutions.

Day to day, this role develops and optimizes semantic models, implements data quality controls, row-level security, incremental refresh strategies, and performance improvements while supporting deployment and CI/CD processes. Success is measured by the reliability, usability, and business value of the data assets delivered, and the trust placed in those solutions by analysts, reporting engineers, and stakeholders across the organization.

RESPONSIBILITIES

• Build and maintain curated views and reporting models in Snowflake 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, calculation groups, aggregations, and metadata.
• Implement and maintain row level security in Power BI semantic models, covering brand, region, and franchisee scope.
• Write efficient SQL and DAX. Profile queries, tune joins, tune measure context transitions, and use the right Snowflake and Power BI features for each workload.
• Implement data quality checks across views and models, including row counts, freshness, referential integrity, business rule validation, and DAX measure regression checks.
• Coordinate with the reporting engineers as the primary consumers of these semantic models. Communication breaking changes early and version models when needed.
• Coordinate with upstream data platform teams on schema changes, late arriving data, and deployment windows.
• Document every view and every semantic model, including grain, source, refresh cadence, key measures, RLS scope, known caveats, and owner.
• Contribute to the team’s modeling standards and code review process across Snowflake and Power BI.
• Pick up work across all brands and domains. The same developer may build a sales rollup one week and a labor semantic model the next.
• Stay current on Snowflake and Power BI capabilities, including features such as dynamic tables, materialized views, calculation groups, and aggregations, and bring useful options into the team’s work where they fit.
• Support the development of end-to-end data solutions, including data ingestion, transformation, modeling, and semantic layer design using modern data warehousing principles.
• Implement and optimize incremental refresh, partitioning, and other performance tuning strategies to support large-scale analytical workloads.
• Participate in the deployment and promotion of data and semantic model changes across development, testing, and production environments, ensuring proper validation and stakeholder sign-off.
• Contribute to CI/CD processes and deployment automation for analytics solutions, supporting reliable and repeatable releases across data and BI platforms.
• Analyze existing data models, semantic layers, and data pipelines to identify opportunities for performance improvements, scalability enhancements, and operational efficiencies.
• Identify and recommend process improvements, best practices, and emerging technologies that enhance the effectiveness, reliability, and governance of enterprise analytics solutions.

QUALIFICATIONS

• Minimum: 4 year degree in Computer Science, Information Systems, Analytics, Business, Statistics, Mathematics, Engineering or a related field.
• Preferred: Microsoft or Snowflake certification, such as the Power BI Data Analyst Associate, Fabric Analytics Engineer Associate, or SnowPro Core credential.
• Minimum: 3+ years of experience building semantic models or curated reporting layers in Power BI and a cloud data warehouse, with strong SQL skills.
• Preferred: 5+ years of BI or analytics engineering experience, with hands on Snowflake and Power BI work in a multi brand, retail, restaurant, or franchise setting.

REQUIRED KNOWLEDGE AND SKILLS

• Knowledge of modern data warehousing architectures and data lifecycle concepts, including data integration, transformation, and semantic layer design.
• Experience working with cloud-based analytics and data platforms such as Microsoft Fabric, Azure, AWS, or GCP.
• Exposure to automation frameworks, command-line tools, or CI/CD practices that support efficient deployment and management of data and business intelligence solutions
• Strong SQL skills, including window functions, CTEs, query optimization, and the ability to read execution plans.
• Hands on Snowflake experience, including warehouses, roles and access controls, query profiling, materialized views, dynamic tables, and streams.
• Familiarity with Power Query (M) and data transformation best practices for developing and maintaining enterprise reporting solutions
• Solid working knowledge of DAX, including iterators, time intelligence, variables, context transition, and calculation groups.
• Experience building Power BI semantic models end to end, including relationships, measures, aggregations, RLS, and metadata.
• Strong understanding of dimensional modeling, including star schemas, slowly changing dimensions, fact and dimension relationships, and the importance of grain.
• Experience implementing data quality checks, freshness monitoring, and DAX measure regression checks across views and semantic models.
• Ability to translate business questions into the right grain and the right measures, in coordination with reporting engineers and business stakeholders.
• Clear written and verbal communication skills, with the ability to explain modeling decisions to engineers, analysts, and business partners.
• Comfortable working on multiple models at once, prioritizing brands and domains, and meeting committed delivery dates.
• Familiarity with version control (Git), code review, and deployment pipelines for both Snowflake objects and Power BI semantic models.
• Familiarity with advanced analytics, artificial intelligence, large language models (LLMs), and emerging data technologies is considered a plus