Business Intelligence / Analytics Engineer (Senior, LATAM)

Evolvesquads inc.; United States; Remote; USD 120,000 - 180,000; Part time

Job summary

Evolvesquads inc. seeks a Senior Business Intelligence / Analytics Engineer to drive data modeling, dbt transformations, and semantic governance for multinational clients. You will work across data sources like ON24, Airtable, Supabase, and MongoDB, delivering scalable dashboards and robust data models.

You will mentor junior analysts, collaborate with engineering on CI/CD, and ensure data quality across DEV/UAT/PROD, with flexible, remote work hours.

Qualifications

• 4–6+ years of experience in Analytics Engineering, BI, or Analysis.
• Expertise with dbt and dimensional modeling techniques.
• Strong SQL skills in Snowflake or similar warehouse.
• Experience building governance for semantic layers and dashboards.

Responsibilities

• Cutover modeling, transformations, and staging for migrations from multiple sources.
• Manage semantic governance in Sigma and enable complex client reporting.
• dbt modeling and architecture in Snowflake with modular standards.
• BI architecture and scalable dashboards across client endpoints.
• CI/CD and automated testing for data models and dashboards.

Skills

dbt expert

Data modeling

SQL mastery

Semantic layer

BI dashboards

Cloud data warehouses

Git workflows

Technical leadership

Tools

Snowflake

Sigma

Looker

Power BI

Git/GitHub

Supabase

MongoDB

Job description

Business Intelligence / Analytics Engineer (Senior, LATAM) #2699

... create world-changing products using God-given talents . .

PROJECT DESCRIPTION:

Our Client is leading B2B media and marketing organization dedicated to connecting life sciences professionals with industry suppliers to accelerate research, development, and manufacturing. The organization helps professionals identify market opportunities through strategic partnerships and meaningful business connections, supporting the advancement of innovative therapies, medical devices, and healthcare solutions. It delivers high-quality, engaging, and informative content to a loyal professional audience while providing comprehensive sales and marketing solutions that help partners build, strengthen, and maintain a robust business development pipeline.

PROJECT STACK and TEAM:

The contract is 6 months with possible extension (very likely).

Working hours US Eastern Time.

Location: LATAM

Stand ups: Daily 10 a.m. EST stand-ups; 1:30 p.m. EST every other Tuesday; 2-3 pm EST on Wednesdays every other week.

Start Date:ASAP

MAIN REQUIREMENTS:

Experience: 4–6+ years of progressive experience in Analytics Engineering, Business Intelligence, or Analysis, with a strong emphasis on data modeling and front-end analytics delivery.

Transformation Stack: Expert-level proficiency with dbt (dbt Core or dbt Cloud) and advanced dimensional modeling techniques (Facts, Dimensions, Data Vault, or semantic layers).

SQL & Warehouse Expertise: Master-level SQL skills applied within Snowflake (or equivalent cloud data warehouses), including optimization of complex analytical queries, window functions, and views.

Semantic Layer & BI Tools: Demonstrated experience building and governing semantic layers, metrics definitions, and enterprise dashboards in modern BI platforms (specifically Sigma, or tools like Looker/Power BI).

Platform Integration Skills: Familiarity with ingesting and modeling data from SaaS platforms, IDP/authentication systems (Supabase), relational document databases (MongoDB), and event tracking tools.

Version Control & Engineering Rigor: Proficient with Git/GitHub workflows, environment management (DEV/UAT/PROD), and automated testing practices for data models.

Technical Leadership: Proven ability to mentor junior/mid-level analysts, translate ambiguous business requirements into extensible data models, and independently drive technical projects to completion.

GOOD TO HAVE:

Effective Communication– Clear, professional, and adaptable.

Teamwork & Collaboration– Works well with others to achieve goals.

Problem-Solving– Thinks critically and finds solutions.

Adaptability– Flexible and open to change.

Time Management– Prioritizes tasks and meets deadlines efficiently.

JOB RESPONSIBILITIES:

Cutover Modeling & Transformations: Own data modeling, transformations, and staging layers for ongoing platform cutovers and migrations, specifically incorporating data from ON24, Airtable, Supabase, and legacy databases (SQL Server, Postgres and MongoDB).

External BI & Semantic Governance: Manage technical modeling, permissions, plugins, and semantic layer governance in Sigma to scale our Internal / client facing reporting. Serve as the primary technical unblocker for internal analyst teams as they request complex calculations, plugins, and new features in Sigma.

dbt Modeling & Architecture: Design, build, and maintain production-grade dimensional models in Snowflake using dbt. Establish modular dbt code standards, semantic metrics, and testing suites to ensure data integrity from raw tables down to presentation layers.

BI Architecture & Scalable Frameworks: Architect high-performance reporting templates, semantic models, and embedded analytics structures in Sigma. Design the core design patterns and automated frameworks that enable a small analyst team to efficiently scale, manage, and maintain dashboards across hundreds of client endpoints.

CI/CD, Testing & Analytics Support: Partner with engineering to maintain versioned release workflows (DEV to PROD) for semantic models and dashboards using Git/GitHub. Establish automated data quality tests in dbt and Sigma to prevent upstream breaking changes from impacting client reporting.

SUMMARY:

Work your way– Enjoy the freedom to work from anywhere, with flexible hours that match your natural rhythm.

Work with global clients– Collaborate directly with international teams to create real impact.

Great people, no micromanagement– Join a supportive, results-focused team where you’re trusted to do your best work.

This flexibility allows developers…

A better work-life balance

Increased productivity

The ability to work any time around the clock