POSITION SUMMARY

Lifewave is looking to grow its engineering team in Guadalajara! This Cloud Database Engineer who will be the first dedicated database expert on our team. This role goes beyond typical database administration, requiring a hands-on engineer with the ability to design database schemas, architect data solutions, and write complex queries. You’ll define our data strategy and ensure our systems support AI initiatives, business intelligence, and data pipelines.

**This is a Direct Hire position for Lifewave Corporate located in Guadalajara, Mexico. Not a Tech9 position. 

Project Overview

The company is transitioning from a slow, traditional database to a high-speed, scalable data warehouse that can handle large data processing needs. The current infrastructure has limitations, such as long processing times (30+ minutes for critical queries) and a lack of integration with AI and BI tools.

The new data architecture will:

• Redesign the database to improve speed, scalability, and efficiency.
• Migrate to a modern, elastic data warehouse that can handle dynamic workloads.
• Enable seamless data integration for AI and BI teams using Databricks.
• Improve data cleansing and transformation to ensure accurate and accessible data.
• Support business intelligence tools such as Tableau and Power BI

• Redesign and optimize database architecture to support scalable data processing.
• Build and manage ETL pipelines to clean, transform, and integrate data from multiple sources.
• Develop and maintain data models for AI and BI teams.
• Work with Azure technologies including Databricks, SQL Server, CosmosDB, and Spark.
• Improve data processing speeds by optimizing queries and database structures.
• Ensure data governance, security, and best practices for storage and processing.
• Collaborate with stakeholders to understand data needs and translate them into solutions.
• Work closely with the lead architect to execute the company’s data vision
• Execute DBA tasks as needed

About You:
This is an opportunity for someone who thrives in solving complex data challenges, takes ownership of projects, and is eager to learn and implement cutting-edge technologies like Databricks, Spark, and CosmosDB.

Must-Have Qualifications:

• 7+ years of professional experience in data engineering, database development, or data warehousing.
• Strong experience with SQL development and database administration.
• Demonstrated, hands-on experience with ETL pipelines, data cleansing, and transformation.
• Proficiency in Python for data processing and automation, data cleansing.
• Demonstrated experience with Azure technologies (Databricks, MS SQL Server).
• Experience in data warehouse architecture and scalable data solutions.
• Familiarity with BI tools like Tableau and Power BI.
• Willingness to execute DBA tasks as needed
• C1+ English Proficiency

Nice-to-Have Qualifications:

• Databricks Certification (e.g., Databricks Data Engineer Associate/Professional).
• Experience in data warehouse architecture and scalable data solutions.
• Knowledge of big data processing frameworks.
• Strong analytical and critical-thinking skills for complex problem-solving
• Willing to commute to the client office in Guadalajara, Mexico every few months

Operating Rhythm:
This is a hybrid position that requires the individual to work at least one-day per week in Guadalajara, Mexico

Interview Process Overview:

Below you'll find an outline of the interview plan for this Sr. Data Engineer position. Please note that this is what we expect the process to look like; we may ask you for supplemental information or require an additional step before making a final decision.

1. Screening interview on-demand HireVue (15-30 min - Online Assessment)
2. 10-minute Q&A with Recruiter
3. Initial interview with Director of Global IT (30 minutes - Zoom)
4. Client round technical interview with Data Architect and Director of Global IT (1 hour - Zoom)

To ensure you've received our notifications, please whitelist the domains jazz.co, jazz.com, and applytojob.com