Role description

Essential Responsibilities

·      Standardize (OLTP databases, (Dimensional) Datawarehouse, and Datamart. Create and maintain logical and physical models in joined with the DW specialist.

·      Assurance that models are created adequately to scale organization growth.

·      Assure data asset consistency and integrity.

·      Maintain a central repository for every data model.

·      Assure reusability and compatibility between data models through the organizational portfolio.

·      Analyze business requirements and design new physical and logical models to support new applications and datamarts in addition to helping define a common information language to the integration shell for the support of integrated business applications and external business transactions (eBusiness and Business to Business).

· Analyze entrepreneurial data and provide recommendations, policy creation, operational processes, and work by the best insurance practices.

·      Assist the operational DBA during production and support migrations.

·      Create and Manage metadata models (frameworks).

·      Recommend OLTP architecture, Data warehousing, metadata managing, and data quality.

·      Support the department with new initiatives.

·      Assist professional development forums and self-development sessions.

·      Assurance of strict standards of professionalism and confidentiality on matters that require discretion.


BA in Computer Science or related area and (3-5) years minimum experience in a related IT role of operational data system modeling (OLTP and data warehousing) or any equivalent education and experience combined.



·      Four-year minimum experience and knowledge in Oracle and Microsoft SQL.

·      Skills in converting business needs into physical and logical models.

·      SOA understanding and other architectural applications-based services.

·      Source and target data knowledge, schematics development, MDM, and metadata management.

·      Basic knowledge of productivity tools such as Excel and Analysis Services.

Latest jobs

The Cervantes Group

Cloud IAM/PAM Specialist, AWS

July 15th, 2024
Mexico City

The IAM/PAM Specialist will own enterprise identity lifecycle management activities (provisioning, recertification, Privileged Access Management etc.) across all 5 entities within the USA regarding the AWS cloud environments. Create IAM Cloud Solutions following DevOps pipeline processes and drive new integrations of applications and data configurations. The ideal person will be able to provide system administration and manage IAM environments, such as apply patches, data migrations, etc.

The Cervantes Group

Datacenter Migration Engineer

July 15th, 2024

The Datacenter Migration Engineer will be dedicated to executing a Migration/Relocation/Consolidation of critical datacenters within the customer. This person will be deeply involved, alongside Application Owners, Application Architects, and Infrastructure Engineers, in the planning and execution of the data center migration and consolidation program. The ideal person can help assess, discover, and document Infrastructure to Application Dependency and create detailed documentation regarding asset inventory and technical migration plan within VMware/Server/Storage environments, including configuration and management. Manage technical aspects involved with infrastructure consolidation/moves.

The Cervantes Group

Network Engineer, Datacenters

July 15th, 2024

The Network Engineer will be responsible for building, operating, and maintaining network devices installed in Washington DC while supporting related activities with a datacenter migration project. The ideal person will be able to configure routing protocols, provide network information, configuring ports, VLAN, extensions, etc., to support a datacenter migration.

The Cervantes Group

IT SME Middleware

July 12th, 2024

We are seeking an experienced IT Subject Matter Expert (SME) with Level 1 (L1) abilities to provide infrastructure application support for a critical middleware platform used for document processing and management. This platform consists of multiple instances that handle various functions such as ATM/Mobile transactions, branch operations, and common services.