Database Team Lead

Canvendor; Denver (CO); On-site; USD 140,000 - 190,000; Full time

Job summary

Canvendor seeks a Lead Cloud Data Engineer to drive database modernization and enterprise analytics architecture. 8+ years of experience with OLTP platforms and data governance are required.

You'll lead migrations, design scalable ETL/ELT pipelines with Python, Talend, and AWS EMR, and mentor teams while coordinating with business stakeholders.

Qualifications

• 8+ years with relational databases (Aurora PostgreSQL) and performance tuning.
• 4+ years building enterprise analytics with Snowflake.
• Hands-on Python, Talend and AWS EMR for scalable ETL/ELT pipelines.
• Cloud migration, data modeling and API integration experience.
• Understanding of metadata, data cataloging and data lineage.

Responsibilities

• Lead enterprise analytics architecture and modernization efforts.
• Mentor teams, drive technical strategy and stakeholder discussions.
• Collaborate with cross-functional teams on data models and APIs.
• Oversee scalable ETL/ELT pipelines and data quality checks.

Skills

Leadership & mentoring

Data governance

SQL & performance tuning

Cloud data architecture

Tools

AWS Aurora PostgreSQL

Snowflake

Python

Talend

AWS EMR

Jira

Confluence

Job description

Job Location : Denver CO(Onsite from Day 1)

Duration : 12+ Months

Job Description:

We are seeking a Lead Cloud Data Engineer with 8+ years of experience to drive database modernization, manage high-performance OLTP platforms, and lead enterprise analytics architecture.

Core Requirements

• Relational Databases: 8+ years with AWS Aurora PostgreSQL (RDS), database design, performance tuning to millisecond response, high availability, and replication.
• Data Warehousing: 4+ years with Snowflake building enterprise analytics platforms.
• Data Engineering: Hands-on experience with Python, Talend (job design/orchestration), and AWS EMR to build scalable ETL/ELT pipelines.
• Architecture & Migration: Strong background in cloud migration, distributed databases, data modeling, and API integration.
• Data Governance: Understanding of metadata management, data cataloging, and data lineage.
• Development Skills: Strong SQL skills and foundational Java experience.

Operations & Leadership

• Production Support: Experience with incident management, root cause analysis, and monitoring tools (Splunk, Dynatrace, ServiceNow).
• Leadership: Proven ability to mentor teams, drive technical strategy, and lead discussions with business stakeholders.
• Tools: Proficiency with Jira, Confluence, and technical documentation.

Preferred Qualifications

• AWS and Snowflake certifications.
• Experience with DevOps, CI/CD, and cloud-native architectures.