




Description: * Define conceptual, logical, and physical data modeling required to support business needs. * Develop, propose, maintain, and update data models. * Ensure data normalization and eliminate or minimize redundant data. * Guarantee data consistency at the model level for database implementation. * Experience in relational and multidimensional modeling. * Define data access security procedures. * Redefine data models according to physical implementation specifics to improve database performance. * Knowledge of table partitioning techniques. * Identify data distribution requirements and collaborate with DBAs on physical implementation. * Participate in BI & Big Data system architecture modeling and deployment. * Model KPIs and dashboards to support executive decision-making. * Design and develop data service architecture across the entire technology and platform ecosystem (Relational, Analytical, NoSQL), aiming to support data consumption by BI applications. * Promote and develop BI best practices, results-oriented and delivery-focused, providing consultation, support, and mentoring to various business areas, with recommendations and guidance for continuous improvement and sustaining the established organizational model. * Participate in developing and updating data management and governance methodologies. * Support specification of integration mechanisms such as services, ETL specifications, database links, and other SGDB-based integration mechanisms. * Develop SQL scripts for information validation, report specifications, etc. * Administer structured, semi-structured, and unstructured data. * Experience with DDL, DML, and DCL for Relational, Analytical, and NoSQL databases. * Knowledge and experience handling diverse data sources (VSAM, CSV, TXT, relational and NoSQL databases). * Experience with VLDBs. * Experience in environment integration activities; V20v20 31 * Experience in performance analysis activities. * Experience with data modeling tools, propagation, DBMS administration, monitoring, and performance tuning across multiple databases. * Informatica PowerCenter * Informatica PowerExchange * Informatica DataQuality * Informatica Metadata Management * SAP PowerDesigner data modeling tool * Data Analysis, Requirements Analysis, Development of Conceptual, Logical, and Physical (Relational and Dimensional) Data Models. * CA-Gen * Oracle * DB2 * SYBASE * SYBASE IQ * PostgreSQL * iSQL/Transaction SQL * SQL Plus * SQL Server * MongoDB * Apache Hawq * Apache Impala * InfluxDB * Knowledge of agile software development principles and practices, including the Agile Manifesto, Scrum, Extreme Programming (XP), and Kanban. * Knowledge of SQL database language. * Knowledge and experience handling diverse data sources (JSON, XML, CSV, TXT, relational and NoSQL databases). * Knowledge of Data and Analytics platforms such as SAS, Tableau, Google Data Studio, Power BI, and similar; knowledge of programming languages, preferably R, Python, Java, and Scala. * Basic understanding of statistics, predictive models, and probabilistic analyses. * Keep data models, logical and physical data structures up to date, ensuring consistency with business rules. Guarantee metadata quality considering their usefulness across company departments. Participate in evaluating automation solutions whenever they impact information production and usage, monitor model implementation, verify database content quality, thereby ensuring alignment with business objectives. * Bachelor’s degree in Information Technology or any undergraduate degree complemented by a postgraduate certificate (specialization, master’s, or doctoral degree) in Information Technology with a minimum duration of 360 hours. * Minimum 3 years of proven experience as a Data Administrator. 2512080202191792894


