Senior Data Architect

hace 1 semana

Ciudad de México, Ciudad de México Derevo A tiempo completo

About Us:
Derevo is a data analytics company that empowers businesses to unlock their full potential. We achieve this by implementing comprehensive data solutions and platforms, covering the entire data cycle necessary for success.

We believe in human talent that is free and creative. At Derevo, we value collaboration, innovation, and growth.

**Job Overview**

The desired profile should have at least 5 years of experience in designing, establishing, and maintaining data management systems. Skilled in collecting, processing, cleaning, and deploying large datasets, understanding ER data models, and integrating with multiple data sources. Proficient in analyzing, communicating, and proposing different ways of building Data Warehouses, Data Lakes, End-to-End Pipelines, and Big Data solutions to clients, either in batch or streaming strategies.

Required Skills and Qualifications

  • Advanced English language proficiency
  • SQL skills: Data Definition Language, Data Manipulation Language, Intermediate/advanced queries for analytical purposes, Subqueries, CTEs, Data types, Joins with business rules applied, Grouping and Aggregates for business metrics, Indexing and optimizing queries for efficient ETL process, Stored Procedures for transforming and preparing data, SSMS, DBeaver
  • 3+ years of experience with IBM Data Stage: Senior-level DataStage developer with at least 4-5 years of relevant experience in DataStage development who can work independently with limited oversight. Must have experience with IBM Infosphere Information Server v11.7

Responsibilities

  • Work with Client's in-house development team to understand activities required to ensure data is acquired from Origami, proper transformations are applied, and the resulting data is loaded into the existing Oracle Data Warehouse
  • Update existing or create new DataStage jobs required to support the movement of data to the existing Oracle Data Warehouse
  • Provide deployment and system testing support
  • Azure skills (desirable): Intermediate/Advanced knowledge in Azure Storage Account, Provision Azure Blob Storage or Azure Data Lake instances; Build efficient file systems for storing data into folders with static or parametrized names, considering possible security rules and risks; Experience identifying use cases for open-source file formats like parquet, AVRO, ORC; Understanding optimized column-oriented file formats vs optimized row-oriented file formats; Implementing security configurations through Access Keys, SAS, AAD, RBAC, ACLs; Azure Data Factory: Provision Azure Data Factory instances; Use Azure IR, Self-Hosted IR, Azure-SSIS to establish connections to distinct data sources; Use of Copy or Polybase activities for loading data; Build efficient and optimized ADF Pipelines using linked services, datasets, parameters, triggers, data movement activities, data transformation activities, control flow activities and mapping data flows; Build Incremental and Re-Processing Loads

Benefits

  • WELLNESS: We prioritize your overall well-being through personal, professional, and economic balance. Our statutory and additional benefits will assist you in achieving this.
  • LET ́S RELEASE YOUR POWER: You will have the opportunity to specialize comprehensively in different areas and technologies, achieving interdisciplinary development. We encourage you to set new challenges and surpass yourself.
  • WE CREATE NEW THINGS: Thinking outside the box is our forte. You'll have the space, trust, and freedom to create, along with the necessary training to achieve it.
  • WE GROW TOGETHER: Participate in cutting-edge, multinational technological projects with foreign teams.

Where Will You Work? We operate in a remote setting, offering flexibility and structure, providing the necessary equipment and internal communication tools to facilitate our operation and that of our clients.

  • Senior Data Architect

    hace 2 semanas

    Ciudad de México, Ciudad de México Data Privacy A tiempo completo

    Job Title: Data Architect SRJob Summary:We are seeking a highly skilled Data Architect to lead the technical implementation of projects and ensure that technology solutions for data are aligned with business needs and comply with established guidelines and security regulations.About the Role:As a Data Architect, you will be responsible for directing the...

  • Senior Data Systems Architect

    hace 4 semanas

    Ciudad de México, Ciudad de México LAAgencia A tiempo completo

    Job Title: Senior Data Systems ArchitectAt LAAgencia, we are seeking a highly skilled Senior Data Systems Architect to join our team. As a key member of our data services team, you will be responsible for designing and implementing data and analytics information systems that meet the company's needs.Responsibilities:* Design and integrate data and analytics...

  • Senior Database Architect

    hace 6 días

    Ciudad de México, Ciudad de México Ntt Data A tiempo completo

    Job Summary:We are seeking a highly skilled Senior Database Architect to join our team in Mexico.About the Role:This is a fantastic opportunity for an experienced Database Administrator to take their career to the next level as a Senior Database Architect. You will be responsible for designing, implementing, and maintaining large-scale database systems that...

  • Senior Solutions Architect

    hace 3 semanas

    Ciudad de México, Ciudad de México Oracle A tiempo completo

    Senior Solutions Architect - Oracle Data PlatformWe are seeking an experienced Senior Solutions Architect to lead a team of engineers in developing business opportunities over the full breadth of Oracle Data Platform solutions, including Oracle Database, MySQL Heatwave, and data integration solutions.This role involves interacting with customers, senior...

  • Data Architect Lead

    hace 4 semanas

    Ciudad de México, Ciudad de México Data Privacy A tiempo completo

    At Data Privacy, we're seeking a highly skilled Data Architect to lead the technical implementation of projects and propose transitional architectures for incremental value delivery. The role involves directing the technical implementation of projects, overseeing workload distribution, resolving conflicts, and managing a team focused on solution...

  • Senior Data Architect

    hace 1 semana

    Ciudad de México, Ciudad de México AgileEngine A tiempo completo

    About the RoleWe are seeking a highly skilled Senior Data Architect to join our team at AgileEngine.The ideal candidate will have a strong background in data engineering, cloud computing, and data orchestration, with a proven track record of designing and implementing scalable data architectures.ResponsibilitiesDesign and implement data models that outline...

  • Data Architect

    hace 4 semanas

    Ciudad de México, Ciudad de México Method360, Inc. A tiempo completo

    Job Title: Data ArchitectJob Summary:We are seeking a highly skilled Data Architect to join our team at Method360, Inc. As a Data Architect, you will be responsible for designing and implementing scalable data architectures to support our business needs.Key Responsibilities:Develop a deep understanding of our business domain and enterprise technology...

  • Senior Data Engineer/Data Architect

    hace 4 semanas

    Ciudad de México, Ciudad de México LAAgencia A tiempo completo

    Job Title: Senior Data Engineer/Data ArchitectAbout the Role:We are seeking a highly skilled Senior Data Engineer/Data Architect to join our team at LAAgencia. As a key member of our data engineering team, you will be responsible for designing, building, and managing large-scale data systems on Azure. Your expertise in data modeling, data integration, and...

  • Senior Enterprise Architect for Automation Solutions

    hace 4 semanas

    Ciudad de México, Ciudad de México NTT DATA Services A tiempo completo

    Job Title: Senior Enterprise Architect for Automation SolutionsJob Summary:We are seeking a highly skilled Senior Enterprise Architect for Automation Solutions to join our team at NTT DATA Services. As a key member of our organization, you will be responsible for designing and implementing automation solutions that drive business value and improve...

  • Data Platform Architect

    hace 5 días

    Ciudad de México, Ciudad de México NTT DATA Services A tiempo completo

    About the Role:NTT DATA Services is seeking a highly skilled Data Platform Architect to join our team in Guadalajara, Mexico. As a key member of our organization, you will be responsible for designing, developing, and implementing our company's platform architecture.The Ideal Candidate:Must have a strong understanding of application architecture principles...

  • Data Architect

    hace 4 semanas

    Ciudad de México, Ciudad de México EVO Payments Mexico, S. de R.L. de C.V. A tiempo completo

    At EVO Payments Mexico, S. de R.L. de C.V., we are seeking a highly skilled Data Architect to join our team. As a senior visionary, you will be responsible for translating business requirements into technology requirements and defining data standards and principles.Key Responsibilities:Design and implement data architecture frameworks, standards, and...

  • Data Architect

    hace 4 semanas

    Ciudad de México, Ciudad de México Chubb A tiempo completo

    **Transform Your Career with Chubb**We are seeking a talented Data Architect to join our team in Mexico. As a key member of our Technology Hub, you will be responsible for designing and implementing data architecture for multiple large-scale projects. Your expertise in data infrastructure, metrics, and coding will drive business growth and innovation.**Key...

  • Data Architect

    hace 1 mes

    Ciudad de México, Ciudad de México EVO Payments Mexico, S. de R.L. de C.V. A tiempo completo

    Enterprise Data ArchitectEVO Payments Mexico, S. de R.L. de C.V. is seeking a highly skilled Enterprise Data Architect to join our team. As a key member of our organization, you will be responsible for designing and implementing a comprehensive data management framework that supports our business strategy.Key Responsibilities:Translate business requirements...

  • Data Architect

    hace 4 semanas

    Ciudad de México, Ciudad de México EVO Payments Mexico, S. de R.L. de C.V. A tiempo completo

    At EVO Payments Mexico, S. de R.L. de C.V., we're seeking a highly skilled Data Architect to join our team. As a Data Architect, you will be responsible for designing and implementing data management frameworks that support our business objectives.Key Responsibilities:Translate business requirements into technical specifications, including data security and...

  • Senior Cloud Architect

    hace 3 semanas

    Ciudad de México, Ciudad de México Ntt Data A tiempo completo

    Role SummaryWe are seeking a Senior Cloud Architect to lead the design, build, and migration of projects using Azure cloud solutions. The successful candidate will be responsible for architecting and designing solutions to meet functional and non-functional requirements in Azure. Key responsibilities include creating and reviewing architecture and solution...

  • Data Architect

    hace 4 semanas

    Ciudad de México, Ciudad de México Element Fleet Management A tiempo completo

    Unlock Your Potential at Element Fleet ManagementElement Fleet Management is a leader in the fleet management industry, and we're looking for a talented Data Architect to join our team. As a Data Architect, you will play a key role in developing and implementing our data strategy, ensuring that our data systems are aligned with our business goals.Key...

  • Senior Data Solutions Architect

    hace 1 día

    Ciudad de México, Ciudad de México Rivka Development A tiempo completo

    Rivka Development is seeking a highly skilled Senior Data Solutions Architect to lead the development of innovative digital memory initiatives.**Estimated Salary:** $140,000 - $170,000 per year Job Description:We are looking for an experienced Data Engineer to join our team and contribute to the design, implementation, and optimization of data processing...

  • Senior Architect

    hace 4 semanas

    Ciudad de México, Ciudad de México Publicis Groupe A tiempo completo

    Job Title: Senior Salesforce ArchitectJob Summary:We are seeking a highly skilled Senior Salesforce Architect to join our team at Publicis Groupe. As a Senior Salesforce Architect, you will play a pivotal role in delivering innovative solutions that solve our clients' most critical business challenges.Key Responsibilities:Lead the architecture, design, and...

  • Data Architect Position

    hace 4 semanas

    Ciudad de México, Ciudad de México Aleph Integrated A tiempo completo

    **Job Summary**:Aleph Integrated seeks a highly skilled Data Architect to design, implement, and maintain its data storage systems. The ideal candidate will have a strong background in database management systems and experience with data modeling and database design.**Key Responsibilities**: Design and implement data storage systems to meet business...

  • Data Architect Position

    hace 1 semana

    Ciudad de México, Ciudad de México Palo IT A tiempo completo

    Data Architect Job DescriptionPALO IT is a global innovation consultancy and Agile software development company. Our team is dedicated to helping organizations embrace tech as a force for good. As a Data Architect, you will play a fundamental role in designing, building, and optimizing our data infrastructure.Responsibilities:Design and maintain data...