Careers
Join #Ensiteam!
We are a company focused on custom software development and we have been in the market for more than 16 years. At Ensitech we are dedicated to finding highly specialized talent to work with large companies in the United States, Europe and Canada.
Each one of our collaborators works with different teams and colleagues around the world, in the design and commercialization of software. We look forward to having you as part of our team in the role of GCP Data Engineer.
What you will do
- Design, develop, and optimize data pipelines, architectures, and data sets in Google Cloud using tools such as BigQuery and DBT.
- Use SQL and DBT for data transformation and manipulation, developing complex SQL queries and implementing optimization techniques for improved performance.
- Utilize your expertise in Python to automate data pipeline processes, ensuring accuracy and efficiency.
- Collaborate with our team of data analysts and data scientists, providing them with clean, reliable data for their analytical work.
- Ensure data governance and security practices are applied across all data initiatives.
- Conduct regular reviews and tests of our data systems to ensure data integrity and quality.
- Stay up-to-date with industry trends and innovations, continuously improving and expanding your knowledge and skills.
Requirements
- Deep expertise in DBT (Data Build Tool) for defining, testing, and documenting data transformations in BigQuery.
- Proficiency in creating and maintaining DBT models, understanding the use of macros, sources, and snapshots.
- Understanding of advanced DBT concepts like incremental models, custom schemas, and the use of variables.
- Experience with DBT Cloud, including setting up deployments, automated tests, and version control.
- Outstanding proficiency in SQL, with the ability to write complex, efficient queries for data extraction and transformation.
- Extensive experience with SQL optimization techniques, aiming to improve query performance and database scalability.
- Knowledge of advanced SQL concepts like window functions, common table expressions (CTEs), and stored procedures.
- Extensive experience in Google Cloud, including hands-on experience with Google Cloud data services such as BigQuery, Pub/Sub, Dataflow, and Dataproc.
- Proven ability to design and implement Google Cloud-based data architectures, adhering to best practices for security, performance, and reliability.
- Solid understanding of data warehousing concepts and data modeling principles.
- Proficient in Python for data automation tasks.
- Understanding of data governance and security practices.
- Google Cloud Certification – Professional Data Engineer
- Strong communication skills, with the ability to explain complex concepts to non-technical stakeholders.
- Excellent problem-solving skills and attention to detail.
- Google Cloud Certification (Professional Data Engineer)
What do we offer?
- 100% remote opportunity.
- Competitive salary and benefits.
- Custom benefit package aligned to your experience and your needs.
- Working with foreign clients.
Apply for this Job
USA
- 28 W Flagler St Ste 300b Office 2281 Miami, Fl 33130
- Phone: +1 (512) 717.7455
MONTERREY
- Ave. Juárez #1102, Local Nivel 5A Col. Centro Monterrey, Nuevo León, México.
- Phone: +52 (81) 2140.8840
MEXICO CITY
- Paseo de la Reforma 222 Torre 1, Piso 18, Suite 1823 Col. Juárez, Mexico City
- Phone: +52 (55) 8789.4678
HERMOSILLO
- Edificio Sonora - Oficina 24 2do Nivel insurgente Pedro Moreno #24, Hermosillo, Sonora.
- Phone: +52 (66) 2259.2388
MERIDA
- Calle 47 No. 331, Piso 3 Interior 300 Col. Benito Juárez, Mérida, Yucatán.
ABOUT COVID-19 | PRIVACY POLICY | TERMS OF SERVICES | POWERED BY ENSITECH