Analytics Engineer – Data Modeling

Consórcio Embracon

Data Engineer designing and implementing data solutions using Databricks techniques at Embracon. Collaborating across teams to standardize and optimize data integration processes.

Posted 7/17/2026full-timeSantana de Parnaíba • 🇧🇷 BrazilMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing enterprise data integration layers using Data Vault modeling and Databricks, while ensuring data quality, governance, and compliance. Proficient in SQL and Python for data engineering, with a strong focus on pipeline orchestration and analytical requirements.

Highest-signal resume keywords

SQL Advanced ProficiencyPython for Data EngineeringApache Spark (PySpark)Databricks (Delta Lakehouse, Unity Catalog)Data Vault Modeling

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonApache SparkData Vault ModelingDimensional Star SchemaPipeline OrchestrationData Quality PracticesIncremental IngestionData TestingData Governance

Tools & Technologies

DatabricksUnity CatalogCI/CDGit

Industry Keywords

Data IntegrationData NormalizationData LineageInformation SecurityRegulatory ComplianceMedallion Architecture

Tech Stack

Tools & technologies

ApachePySparkPythonSparkSQLUnityVault

About the role

Key responsibilities & impact

Design, model, implement and maintain the enterprise data integration layer, primarily the Silver layer on Databricks, using Data Vault modeling (Raw Vault and Business Vault)
Integrate data from multiple systems, ensuring standardization, deduplication, normalization and traceability of information
Apply identity resolution techniques across distinct sources to ensure correct unification of entities such as customers, contracts and transactions
Normalize and standardize analytical attributes, including handling of marketing identifiers and digital channels (e.g., UTM), ensuring consistency for analytical consumption
Build and maintain unified entities by applying structural business rules and ensuring semantic coherence across domains
Provide the integrated and semantic data layer as the official source for Business Intelligence consumption, supporting dimensional modeling in the Gold layer
Collaborate with BI, Data Engineering and business areas to gather analytical requirements and identify information gaps
Ensure new analytical projects adopt the integrated data layer as the corporate standard from the start
Implement data quality practices, including validations, automated tests and continuous monitoring
Document, catalog and maintain data lineage in Unity Catalog, with complete metadata and clear ownership definitions
Define and maintain naming, semantic and data modeling standards together with the relevant stakeholders
Orchestrate, monitor and optimize pipelines under your responsibility, ensuring performance, stability, security and cost control
Work with the company’s Governance function to enforce access policies, information security and regulatory compliance

Requirements

What you’ll need

SQL (Advanced proficiency, including analytical queries, modeling and optimization)
Python (applied to data engineering and analytics)
Hands-on experience with Apache Spark (preferably PySpark)
Experience with Databricks (Delta Lakehouse, notebooks, DLT, Unity Catalog)
Strong knowledge of data modeling (Data Vault and dimensional star schema)
Familiarity with the Medallion architecture (Bronze, Silver and Gold layers)
Experience with incremental ingestion and historical data handling
Experience with pipeline orchestration and observability (freshness, quality and alerts)
Desirable: experience with Data Governance and information security applied to data (masking, RBAC/ABAC and LGPD)
Knowledge of code versioning, Git, CI/CD and data testing

Benefits

Comp & perks

Health, dental and psychological care
Transportation voucher
Meal or food allowance
Partnership with gym and wellness networks
Life insurance
Birthday day off
Quality-of-life programs
"We’re Expecting!" programs (parental support)
Recognition programs
Private pension plan
Education scholarship
Student transportation allowance
Wedding benefit
6-month maternity leave
20-day paternity leave
Payroll-deductible loans
Discounted employee consortium purchases
PPR (Profit-Sharing Program)
UCE (Embracon Corporate University)