Senior Analytics Engineer

Job not on LinkedIn

🔥 0 minutes ago

🇧🇷 Brazil – Remote

⏰ Full Time

🟠 Senior

📊 Analytics Engineer

👻 Ghost score 10%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Stefanini Brasil

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1987

💼 Consulting

🏥 Healthcare

📦 Logistics

Consulting • Healthcare • Logistics

Stefanini Brasil is a leading provider of digital transformation solutions, offering a range of services including artificial intelligence, cybersecurity, cloud enablement, and consulting. With over 35 years of experience, the company focuses on integrating innovative technologies to help organizations enhance their operations and customer experiences across various industries. Their expertise extends to sectors like healthcare, retail, and industrial goods, enabling businesses to optimize processes and drive value through technology.

📋 Description

• Lead the refactoring and standardization of the transformation layer in GCP • Eliminate monolithic SQL queries and duplicated logic • Define and implement SQL engineering standards in BigQuery using Dataform and/or dbt • Develop packages and macros in JavaScript/TypeScript or Jinja/Python • Structure clear transformation layers, code reuse, and dimensional/denormalized modeling • Implement incremental loading patterns with idempotent reprocessing • Implement Data Quality frameworks and the Write-Audit-Publish pattern in BigQuery • Audit processed data and trigger Circuit Breakers to block corrupted data • Structure transformation models and templates for standardized AI-generated code • Maintain a documented repository of canonical Staging, Intermediate, and Marts examples • Work with consumer teams to design optimized semantic layers and Data Marts • Use Authorized Views, Aggregate Tables, and Materialized Views accelerated by BI Engine • Ensure high performance, low read costs, and consistent KPIs in Looker Studio

🎯 Requirements

• Expert-level proficiency in advanced SQL in BigQuery, including Window Functions/QUALIFY, advanced UNNEST/ARRAY_AGG manipulation, and procedural scripting • Experience with Dataform, including JavaScript for dynamic SQL generation, and/or dbt (Jinja) • Deep experience in data modeling for Cloud Data Warehouses • Knowledge of Kimball methodology adapted for columnar databases • Experience with One Big Table and nested RECORD/REPEATED fields • Experience with Slowly Changing Dimensions (SCD Type 2) • Knowledge of Partition Pruning and Clustering on high-cardinality keys • Experience with incremental modeling to reduce bytes scanned and slot consumption • Experience integrating, cataloging, and optimizing data sources for BI tools • Knowledge of Looker Studio and BI Engine • Proven experience creating automated data tests, including schema tests, referential integrity tests, and volume and freshness anomaly detection • Excellent verbal and visual communication skills for translating complex business rules into clean data models • Ability to conduct rapid root cause analyses (RCA) • Preferred: experience migrating legacy pipelines to Dataform/dbt • Preferred: knowledge of LookML/Looker, Cube, or the dbt Semantic Layer • Preferred: experience analyzing lineage graphs (DAGs)

🏖️ Benefits

• Meal or food allowance • Discounts on courses, universities, and language institutions • Stefanini Academy — a platform offering free, up-to-date online courses with certificates • Mentoring • Benefits club offering discounts on consultations and medical tests • Medical insurance • Dental insurance • Benefits and discounts club at leading establishments • Travel club • Pet benefits program

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume