Only available for #residents of #Latinamerica Our client builds smart technology solutions through the combination of artificial intelligence, mobile, and web development for companies in the United States, Canada & Latam. It´s a technology company headquartered in Costa Rica. With operations throughout LATAM. Their core focus is building intelligent tech solutions to help our customers be more efficient in optimizing internal digital processes. About the job Senior Data Engineer How will you make an impact? Build and maintain multiple data pipelines to ingest new data sources (API and file-based) and support products used by both external users and internal teams. Optimize by building tools to evaluate and automatically monitor data quality, develop automated scheduling, testing, and distribution of feeds. Work with our data science and product management teams to design, rapid prototype, and productize new data product ideas and capabilities. Work with the data engineering team to design new data pipelines and optimize the existing data pipelines. Conquer complex problems by finding new ways to solve with simple, efficient approaches with a focus on reliability, scalability, quality, and cost of our platforms. Build processes supporting data transformation, data structures metadata, and workload management. Collaborate with the team to perform root cause analysis and audit internal and external data and processes to help answer specific business questions. What will you bring to us? 5+ years of professional Dimensional Data Warehousing/Data Modeling and Big Data Experience Strong skills to write complex, highly-optimized SQL queries across large volumes of data Experience working directly with data analytics to bridge business requirements with data engineering. Experience with AWS infrastructure Proven experience working with Snowflake and Airflow in a production environment Strong SQL skills with experience in query optimization and performance tuning Proficiency in Python programming language for data processing and automation tasks. Experience with DBT (Data Build Tool) for data transformation and modeling Excellent troubleshooting and problem-solving skills Ability to operate in an agile, entrepreneurial start-up environment, and prioritize Excellent communication and teamwork, and a passion for learning Curiosity and passion for data, visualization, and solving problems Willingness to question the validity, accuracy of data and assumptions Preferred Qualifications: Experience with Redshift, Snowflake, or other MPP databases is a plus. Knowledge for ETL/ELT tools like Informatica, IBM DataStage, or SaaS ETL tools is a plus. Experience with Tableau or other reporting tools is a plus.
