Data Modeling Specialist

Keep IT Simple

. Design and maintain enterprise conceptual, logical, and physical data models .

Posted 10/9/2026contractSão Paulo • BrazilSeniorLeadWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in designing and maintaining enterprise data models, including conceptual, logical, and physical structures, while ensuring alignment with business capabilities and data governance standards. Proficient in utilizing Azure Synapse Analytics and Databricks Lakehouse for data architecture and analytics solutions.

Highest-signal resume keywords

Data ModelingAzure Synapse AnalyticsDatabricks LakehouseSQL ProficiencyEnterprise Data Governance

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 ArchitectureDimensional Data Modeling3NF Data ModelingData Transformation DesignETL/ELT ProcessesData Quality ManagementSource-to-Target MappingData LineageMetadata ManagementData Stewardship

Soft Skills

CollaborationMentoringProblem-SolvingCommunicationGuidance

Tools & Technologies

Oracle DatabaseSQL ServerErwin Data ModelerSAP PowerDesignerMicrosoft PurviewCollibraInformatica Metadata ManagementPythonDatabricks Unity CatalogDataOps

Industry Keywords

InsuranceFinancial ServicesRegulated IndustriesData GovernanceCloud Modernization

Tech Stack

Tools & technologies

AzureCloudETLInformaticaOraclePythonSQLUnityVault

About the role

Key responsibilities & impact

Design and maintain enterprise conceptual, logical, and physical data models
Develop dimensional, normalized, and hybrid data models for analytics and operational workloads
Translate business requirements into scalable and maintainable data structures
Create subject area models, canonical data models, and data domain structures
Align data models with enterprise architecture and business capabilities
Design dimensional and reporting models optimized for Azure Synapse Analytics
Define partitioning, distribution, and performance optimization strategies
Support data warehouse and lakehouse architectures
Model data structures for Databricks Lakehouse architectures, including Bronze, Silver, and Gold layers
Support Delta Lake implementations and data product development
Collaborate with Data Engineering teams to optimize model performance and scalability
Design and maintain normalized operational data models for Oracle
Support transactional and analytical databases
Define indexing, partitioning, and physical database performance standards
Collaborate with database administrators on physical database implementations
Create and maintain source-to-target mapping documentation
Define transformation rules and business logic for data integration solutions
Support data migration, modernization, and cloud transformation initiatives
Validate data integrity across inbound and outbound interfaces
Support enterprise data governance initiatives and governance reviews
Define and maintain business and technical metadata
Establish and document data standards and naming conventions
Support data stewardship activities and regulatory compliance
Document end-to-end data lineage
Support lineage management tools and processes
Define data quality rules, standards, and validation requirements
Assist in root-cause analysis of data quality issues
Partner with Business Analysts, Data Architects, Data Engineers, Solution Architects, Governance teams, and Data Product Owners
Participate in architecture reviews and solution design workshops
Provide guidance on data modeling best practices and standards
Mentor junior team members and promote data management and governance best practices

Requirements

What you’ll need

Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or a related field
7+ years of experience in data modeling, data architecture, or enterprise data management
Proven experience creating logical and physical data models for large-scale data platforms
Experience supporting data warehouse, database, and lakehouse environments
Experience with enterprise data governance and metadata management initiatives
Conceptual, logical, physical, dimensional, 3NF, Data Vault, and canonical data modeling
Experience with Azure Synapse Analytics, Databricks Lakehouse Platform, and Oracle Database
SQL and PL/SQL proficiency
Experience with data warehousing, lakehouse architectures, enterprise information architecture, reference data management, and master data management concepts
Knowledge of data lineage, metadata management, data catalog solutions, data stewardship, data quality management, and business glossary development
Experience with source-to-target mapping, data transformation design, ETL/ELT processes, and integration architecture
Master's degree preferred
SQL Server, Erwin Data Modeler, ER/Studio, SAP PowerDesigner, Microsoft Purview, Collibra, Informatica Metadata Management, and Python preferred
Experience supporting cloud modernization initiatives
Knowledge of Databricks Unity Catalog and governance capabilities
Understanding of AI, analytics, and machine learning data requirements
Experience within Insurance, Financial Services, or other regulated industries
Familiarity with DataOps and DevOps practices

Benefits

Comp & perks

Modelo de contratação: PJ (Pessoa jurídica)
Forma de atuação híbrida, com 3 dias por semana presenciais no escritório de Pinheiros/SP