Data Administrator – Engineering and Modeling

Spassu

Administrador de Dados focado em modelagem e integração de dados para projetos em BI e Big Data na Spassu. Buscamos profissionais inquietos e que queiram crescer com a empresa.

Posted 6/13/2026full-timeRemote • 🇧🇷 BrazilMid-LevelSeniorWebsite

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

data modelingSQLDDLDMLDCLdata normalizationETLdatabase integrationdata validationdata governance

Soft Skills

consultancymentorshipcontinuous improvementcommunication

Tools & Technologies

OracleSQL ServerPostgreSQLDB2MongoDBPowerDesignerErwinCA-GenInformatica PowerCenter

Certifications & Qualifications

Microsoft SQL ServerPostgreSQLOracleDB2SAP ASESAP IQMySQL

Industry Keywords

business rulesmetadata qualityBI systemsBig DataKPIdashboardsrelational modelingdimensional modelingdata access securitydata distribution

Tech Stack

Tools & technologies

ETLInformaticaMongoDBMS SQL ServerMySQLNoSQLOraclePostgresSQL

About the role

Key responsibilities & impact

Keep data models and the logical and physical data structures up to date, ensuring they remain consistent with business rules.
Ensure metadata quality, considering its usefulness to the company’s various departments.
Participate in the evaluation of automation solutions whenever they affect information production and use, monitoring model implementation and verifying the quality of database contents to ensure alignment with business objectives.
Define conceptual, logical and physical modeling of the information required to meet business needs;
Design, propose, maintain and update data models, ensuring data normalization, eliminating or minimizing redundant data, and promoting data consistency at the model level for implementation in the database;
Define data access security procedures;
Redefine data models based on specifics of physical implementation to improve database performance;
Identify data distribution requirements and work with DBAs on physical implementation;
Work on architecture modeling and deployment of BI & Big Data systems and of KPIs and dashboards to support executive decision-making;
Design and develop the architecture for data services across the technology and platform ecosystem (Relational, Analytical, NoSQL) to support data consumption by BI applications;
Promote and develop BI best practices focused on results and deliverables, providing consultancy, support and mentorship to business areas, with recommendations and guidance for continuous improvement and to sustain the established organizational model;
Participate in the development and updating of data management and governance methodology;
Support the specification of integration mechanisms such as services, ETL specifications, database links and other DBMS-based integration mechanisms;
Write SQL scripts for data validations, report specifications, etc.

Requirements

What you’ll need

Bachelor's degree in Information Technology, or completion of any higher education degree accompanied by a postgraduate certificate (specialization, master’s or doctorate) in Information Technology of at least 360 hours.
DESIRABLE CERTIFICATION: Hold at least one certification in one of the following databases: Microsoft SQL Server, PostgreSQL, Oracle, DB2, SAP ASE, SAP IQ, MySQL
Preferred experience: 3 years of experience in data modeling and large-volume data integration in analytical and transactional environments.
Knowledge of relational and dimensional modeling;
Advanced SQL, DDL, DML, DCL;
Platforms: Oracle, SQL Server, PostgreSQL, DB2, MongoDB;
Modeling tools: PowerDesigner, Erwin, CA-Gen;
Knowledge of integrations via DBMS, Database Links and ETL (e.g., Informatica PowerCenter).

Benefits

Comp & perks

Health plan
Dental plan
Life insurance
Meal or food allowance
Transportation allowance
WellHub - Gympass