**RH**:Raul García
**Position**:Fullstack Azure Data Engineer
**Location**:Aguascalientes, Mexico
**Industry - Sector**:MALS
**What you'll do?**
- Build, optimize, and maintain scalable data pipelines to process large datasets from various sources using Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.
- Implement ETL (Extract, Transform, Load) processes to integrate and transform data for analytical and operational purposes.
- Design and implement cloud-based data architectures using Azure SQL Database, Azure Data Lake Storage, Azure Blob Storage, and Azure Synapse Analytics.
- Build and manage data lakes, data warehouses, and data marts to enable seamless data flow and storage.
- Develop and maintain backend systems that handle data processing, storage, and retrieval with technologies such as Python, Spark, SQL, and Azure Data Factory.
- Ensure data consistency, quality, and reliability across multiple systems and services.
- Create user-friendly data interfaces and reports for business users, ensuring that data insights are accessible and actionable.
- Work with both relational and non-relational databases on Azure, including Azure SQL Database, Cosmos DB, and Azure Data Warehouse.
- Optimize and tune databases for performance, including query optimization, indexing, and partitioning.
- Automate data workflows and deployment pipelines using Azure DevOps, Terraform, or similar infrastructure-as-code tools.
- Implement CI/CD (Continuous Integration/Continuous Deployment) processes for data systems and analytics solutions.
- Implement best practices for data security, including encryption, role-based access control (RBAC), and data masking.
- Ensure compliance with data governance policies and standards, ensuring the data is clean, accurate, and available.
- Work closely with data scientists, analysts, and business stakeholders to understand data needs and provide solutions.
- Provide technical leadership and mentorship to junior team members, helping them grow their skills in cloud data engineering.
- Monitor and optimize the performance of data systems, ensuring high availability and scalability.
- Troubleshoot and resolve issues related to data integration, transformation, and reporting.
**What you'll bring**:
- In-depth experience with Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure SQL Database, Azure Blob Storage, Azure Data Lake, and Azure Data Warehouse.
- Proficiency in Python or Scala for data engineering and automation tasks.
- Strong SQL skills for data querying, data transformation, and performance tuning.
- Experience building ETL pipelines using Azure Data Factory, Azure Databricks, or SQL Server Integration Services (SSIS).
- Knowledge of batch and streaming data processing techniques using tools like Apache Spark, Azure Stream Analytics, or Apache Kafka.
- Strong understanding of data warehousing and data lake architectures, and experience implementing these solutions on Azure Synapse or Azure Data Lake.
- Experience with data storage solutions such as Azure Blob Storage, Cosmos DB, and SQL Server.
- Experience with Power BI, Tableau, or other visualization tools to create dashboards and interactive reports.
- Proficiency in Azure DevOps, Terraform, or similar tools for automating deployment, data pipeline orchestration, and infrastructure provisioning.
- Knowledge of data security best practices, including access management, encryption, and data masking techniques.
- Experience with Azure Active Directory (AD) and role-based access control (RBAC).
- Familiarity with Git and version control best practices for collaborative development and project management.
**Soft skills**:
Work Underpressure, Quality at work, Results Oriented
**What can YOU expect in a career with Capgemini?**
- Working in a team environment, Consultants will focus on the analysis, design and development of technology-based solutions for Capgemini's clients.
- You will work alongside technical, functional and industry specialists to assist with the development, implementation and integration of innovative system solutions including methods, techniques and tools.
- You will contribute to client satisfaction by providing timely and responsive value-added services and work products.
- Capgemini offers a competitive compensation and benefits package.
- Headquartered in Paris, France, Capgemini has a presence of more than 340 thousand professionals in Mexico distributed among 3 sites located in Mexico City, Monterrey and Aguascalientes. A deeply multicultural organization.
- Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore, its worldwide delivery model.
**You will love this job because**
- Capgemini focuses on giving each new hire a YOU-nique experience through our recruitment process and on-boarding program, as well as by helping you to build your own career and professional skills foundation.
- Capgemini provides a