Job details

Data & Analytics Engineer - AWS, Snowflake & BI

Get a free resume review

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.

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.

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.

What You Should Know About Data & Analytics Engineer - AWS, Snowflake & BI, Enroute

At Enroute, we’re all about innovation and technology, and we work hard to ensure our team is engaged and fulfilled. As a Data & Analytics Engineer specializing in AWS, Snowflake, and BI tools, you'll take center stage in our mission to leverage data for smart decision-making. You won't just be building data pipelines; you'll be crafting scalable and efficient systems that pull together information from multiple sources, transforming it into insights that will drive our future. Your expertise in Python and solid understanding of Snowflake and PostgreSQL will help you design robust data storage solutions that are both reliable and cost-effective. We're looking for someone who values data quality and security as much as we do; after all, ensuring accurate and accessible data is key for our analytics team. You'll collaborate closely with various departments, understanding their data needs to create effective solutions while maintaining clear documentation. At Enroute, we encourage questions and continuous learning, so you’ll fit right in if you’re excited to embrace challenges. We’re committed to creating a supportive work environment that balances work with life, offering flexible schedules and fantastic benefits. Together, let’s make data work for everyone at Enroute.

Frequently Asked Questions (FAQs) for Data & Analytics Engineer - AWS, Snowflake & BI Role at Enroute

What are the primary responsibilities of a Data & Analytics Engineer at Enroute?

As a Data & Analytics Engineer at Enroute, your primary responsibilities include designing and maintaining scalable data pipelines, optimizing data storage systems like Snowflake and PostgreSQL, implementing data quality checks, and ensuring data security and compliance. You'll also integrate reverse ETL processes and collaborate with other teams to understand and fulfill their data needs.