Data Administrator

Job not on LinkedIn

November 7

Apply Now

Receive Emails with Similar Jobs

Spassu

WebsiteLinkedInAll Job Openings

Digital Transformation • SaaS • Technology

Spassu is a Brazilian company specializing in end-to-end digital transformation solutions. With over 30 years of experience, Spassu focuses on maximizing value delivery by simplifying processes and improving decision-making throughout its partners' journeys. The company employs experts in user experience, design thinking, and agile methodologies to co-create innovative solutions that meet the needs of diverse industries. By leveraging a multidisciplinary approach and applying best practices like ITIL and LEAN, Spassu facilitates continuous improvement and ensures the effective implementation of IT services across various sectors.

1001 - 5000 employees

Founded 1992

☁️ SaaS

📋 Description

• Keep data models and the logical and physical data structures up to date, ensuring they remain consistent according to business rules. • Ensure the quality of metadata, considering its usefulness for the company’s various departments. • Participate in the evaluation of automation solutions whenever they affect the production and use of information, monitoring the implementation of models and checking the quality of database content to ensure alignment with business objectives. • Define conceptual, logical and physical modeling of the information required to meet business needs; • Create, 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 physical implementation particularities in order to improve database performance; • Gather requirements for data distribution and work together with DBAs on the physical implementation; • Work on architecture modeling and deployment of BI & Big Data systems and on metrics 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, with a results- and delivery-oriented approach to realize benefits, providing consulting, support and mentoring to business areas with recommendations and guidance for continuous improvement and sustaining the established organizational model; • Participate in the preparation and updating of data management and governance methodology; • Support the specification of integration mechanisms such as services, ETL specifications, database links and other integration mechanisms via DBMS; • Develop SQL scripts for data validations, report specifications, etc.

🎯 Requirements

• Bachelor's degree in Information Technology, or completion of any undergraduate 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 database systems: Microsoft SQL Server, PostgreSQL, Oracle, DB2, SAP ASE, SAP IQ, MySQL • Desired experience: 3 years of experience in data modeling and integration of large volumes 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; • Experience with integrations via DBMS, database links and ETL (e.g., Informatica PowerCenter).

🏖️ Benefits

• Health Insurance • Dental Plan • Life Insurance • Meal or Food Allowance • Transportation Allowance • WellHub - Gympass