**Position Summary**:Our team is looking for a **Sr. Data Engineer** with a diverse background in data integration to join the Data Services team.Some data are small, some data are very large (1 trillion+ rows), some data is structured, some data is not.Our data comes in all kinds of sizes, shapes and formats.Traditional RDBMS like PostgreSQL, Oracle, SQL Server, MPPs like StarRocks, Vertica, Snowflake, Google BigQuery, and unstructured, key-value like MongoDB, Elasticsearch, to name a few.We are looking for individuals who can design and solve any data problems using different types of databases and technologies supported within our team.We use MPP databases to analyze billions of rows in seconds.We use Spark and Iceberg, batch or streaming to process whatever the data needs are.We also use Trino to connect all different types of data without moving them around.Besides a competitive compensation package, you'll be working with a great group of technologists interested in finding the right database to use, the right technology for the job in a culture that encourages innovation.If you're ready to step up and take on some new technical challenges at a well-respected company, this is a unique opportunity for you.**Responsibilities**:- Implement ETL/ELT processes using various tools and programming languages (Scala, Python) against our MPP databases StarRocks, Vertica and Snowflake- As Data Engineers, not only are we developers, but we also maintain and administrate our MPP ecosystem. We will tune and maximize our hardware potential from OS, network and storage levels- Work with the Hadoop team and optimize Hive and Iceberg tables- Running POC between different table formats- Contribute to the existing Data Lake and Data Warehouse imitative using Hive, Spark, Iceberg, Presto/Trino- Analyze business requirements, design and implement required data models**Qualifications: (must have)**- BA/BS in Computer Science or in related field- 2+ years of experience with MPP databases such as StarRocks, Vertica, Snowflake- 5+ years of experience with RDBMS databases such as Oracle, MSSQL or PostgreSQL- 2+ years of experience managing or developing in the Hadoop ecosystem- Programming background with Scala, Python, Java or C/C++- Experience with Elasticsearch or ELK stack- Working knowledge of streaming technologies such as Kafka- Strong in any of the Linux distributions, RHEL,CentOS or Fedora- Deep knowledge shell scripting, scheduling, and monitoring processes on Linux- Experience working in both OLAP and OLTP environments- Experience working on-prem, not just cloud environments**Desired: (nice to have)**- Working knowledge of data unification and setup using Presto/Trino- Working knowledge of orchestration tools such Oozie and Airflow- Experience with Spark. PySpark, SparkSQL, Spark Streaming, etc- Experience using ETL tools such as Informatica, Talend and/or Pentaho- Understanding of Healthcare data- Data Analyst or Business Intelligence would be a plusTipo de puesto: Tiempo completo, Por tiempo indeterminadoSalario: $55,000.00 - $60,000.00 al mesHorario:- Lunes a viernesExperiência:- Oracle: 5 años (Obligatorio)- MSSQL: 5 años (Obligatorio)- PostgreSQL: 5 años (Obligatorio)- Fedora: 5 años (Obligatorio)- Python: 5 años (Obligatorio)- CentOS: 5 años (Obligatorio)Idioma:- Inglés (Obligatorio)Lugar de trabajo: remoto híbrido en 45050, Zapopan, Jal.
