Key skills
ETLInformaticaMongoDBMS SQL ServerMySQLNoSQLOraclePostgresSQLBIPostgreSQLSQL ServerSAP
About this role
Role Overview
- Keep data models and the logical and physical data structures up to date, ensuring they remain consistent with business rules.
- Ensure the quality of metadata, taking into account its usefulness for the company's various business units.
- Participate in evaluating automation solutions whenever they impact the production and use of information, monitor the implementation of models, and verify 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;
- Develop, propose, maintain, and update data models, ensuring data normalization, eliminating or minimizing redundant data, and promoting consistency at the model level for database implementation;
- 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 implementation of BI & Big Data systems, as well as 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, providing consulting, support, and mentorship to business areas, offering recommendations and guidance for continuous improvement and sustaining the established organizational model;
- Participate in the development and update of data management and governance methodologies;
- Support specification of integration mechanisms such as services, ETL specifications, database links, and other integration mechanisms via DBMS;
- Develop SQL scripts for data validation, report specifications, etc.
Requirements
- 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.
- PREFERRED CERTIFICATION: Hold at least one certification in 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).
Tech Stack
- ETL
- Informatica
- MongoDB
- MS SQL Server
- MySQL
- NoSQL
- Oracle
- Postgres
- SQL
Benefits
- Health Insurance
- Dental Plan
- Life Insurance
- Meal or Food Allowance
- Transportation Allowance
- WellHub
- Gympass