Data & Analytics Engineer - AWS, Snowflake & BI

About Enroute:

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and try to improve it daily. We make things happen. You can trust us. Our Enrouters are always up for a challenge. We ask questions, and we love to learn.

We pride ourselves on having great benefits and compensations, a fantastic work environment, flexible schedules, and policies that positively impact the balance of work and life outside of it. We care about who you are in the office and as an individual. We get involved, we like to know our people, we want every Enrouter to become part of a great community of highly driven, responsible, respectful, and above all, happy people. We want you to enjoy working with us.

We are seeking a talented and driven Data Engineer to join our growing data team. You will play a crucial role in designing, building, and maintaining robust data pipelines and storage solutions that empower data-driven decision-making across the organization. The ideal candidate has a strong foundation in data engineering principles, proficiency in a variety of data technologies, and a passion for ensuring data quality and security.

Requirements

Programming Languages: Proficient in Python.

Data Manipulation Analysis: Strong experience with Pandas.

CI/CD: Experience with Jenkins for continuous integration and continuous delivery pipelines.

Databases: Solid understanding and hands-on experience with Snowflake and PostgreSQL.

Version Control: Proficient with Git for code management and collaboration.

Reverse ETL: Experience with Hightouch or similar Reverse ETL tools.

Cloud Platforms: Familiarity with Amazon Web Services (AWS) and its data-related services.

Data Visualization Exploration: Experience with Sigma Computing or other BI and analytics platforms.

Data Querying: Strong SQL skills for data extraction, manipulation, and analysis.

Key Responsabilities:

- Data Pipeline Development: Design, build, and maintain scalable and efficient data pipelines to ingest, transform, and load data from various sources into our data warehouse (Snowflake) and other data stores (PostgreSQL).
- Data Storage Optimization: Maintain and optimize our data storage systems (Snowflake and PostgreSQL) for performance, reliability, and cost-effectiveness.

- Data Quality Assurance: Implement and monitor data quality checks and processes to guarantee the accuracy, completeness, and availability of data for reporting and analysis.
Security and Privacy: Implement and adhere to security measures and data privacy policies to protect sensitive information.

- CI/CD Implementation: Utilize Jenkins to build and maintain automated CI/CD pipelines for data engineering workflows.
Reverse ETL Integration: Design and implement Reverse ETL processes using Hightouch to push data from the data warehouse back to operational systems.

- Collaboration: Work closely with data engineers, analysts, and other stakeholders to understand their data needs and provide1 effective data solutions.

-Documentation: Create and maintain clear and comprehensive documentation for data pipelines, storage systems, and processes.
Troubleshooting and Support: Identify and resolve data-related issues and provide support to data consumers.

Benefits

• Monetary compensation
• Year-end Bonus
• IMSS, AFORE, INFONAVIT
• Major Medical Expenses Insurance
• Minor Medical Expenses Insurance
• Life Insurance
• Funeral Expenses Insurance
• Preferential rates for car insurance
• TDU Membership
• Holidays and Vacations
• Sick days
• Bereavement days
• Civil Marriage days
• Maternity Paternity leave
• English and Spanish classes
• Performance Management Framework
• Certifications
• TALISIS Agreement: Discounts at ADVENIO, Harmon Hall, U-ERRE, UNID
• Taquitos Rewards
• Amazon Gift Card on your Birthday
• Work-from-home Bonus
• Laptop Policy

Equal employment

Enroute is committed to providing equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.