Data Engineer Team Lead

Cloud Analytics Technologies, LLC; Missouri; On-site; USD 80,000 - 110,000; Full time

Job summary

Cloud Analytics Technologies, LLC is seeking a candidate for a data analysis role requiring expertise in advanced data analysis, SQL, and Python. The position involves developing automated ETL pipelines on GCP, performing in-depth data analysis, and creating visual dashboards to support business needs.

The ideal candidate should have 5-8 years of experience in the field, with excellent problem-solving and communication skills.

Qualifications

• 5-8 years of experience, with 1-3 years in Python and SQL.
• Proficiency in SQL for complex data querying and transformation.
• Intermediate experience with Python and R for data manipulation.

Responsibilities

• Perform deep-dive data analysis using SQL, Python, and R.
• Design, build, and maintain automated ETL pipelines on GCP.
• Develop and deploy real-time dashboards using BI tools.

Skills

SQL

Python

R

GCP services

Looker

Tableau

Data visualization

Problem-solving

Communication

Tools

BigQuery

Cloud Composer

Dataflow

Job description

We are looking at candidates with overall experience of 5-8 years with 1-3 years of strong experience in Python and SQL.

Key Responsibilities

Advanced Data Analysis

Perform deep-dive data analysis using SQL, Python, and R to uncover trends, patterns, and actionable insights.

Collaborate with stakeholders to translate business questions into analytical solutions.

Data Engineering & Visualization

Design, build, and maintain automated ETL pipelines on GCP using Dataflow, BigQuery, and Cloud Composer.

Develop and deploy real-time dashboards using Looker, Data Studio, or other BI tools to support data-driven decision-making.

Workflow Optimization

Identify and implement opportunities to streamline data workflows across cross-functional teams.

Drive process improvements and automation to enhance data accessibility and reliability.

High-Impact Delivery

Thrive in a fast-paced, high-impact environment, managing multiple priorities and delivering results under tight deadlines.

Communicate findings and recommendations clearly to both technical and non-technical audiences.

Required Skills & Qualifications

• Proficiency in SQL for complex data querying and transformation.
• Intermediate experience with Python and R for data manipulation and statistical analysis.
• Hands‑on experience with GCP services such as BigQuery, Cloud Storage, Dataflow, Pub/Sub, and Cloud Functions.
• Experience building automated ETL pipelines and working with streaming data.
• Familiarity with dashboarding tools like Looker, Tableau, or Google Data Studio.
• Strong problem‑solving skills and ability to work independently and collaboratively.
• Excellent communication and stakeholder management skills.

Preferred Qualifications

• GCP certification (e.g., Professional Data Engineer).
• Experience with CI/CD pipelines and infrastructure as code (e.g., Terraform).
• Background in data science or machine learning is a plus.

CLOUD ANALYTICS TECHNOLOGIES is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. CLOUD ANALYTICS TECHNOLOGIES will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will CLOUD ANALYTICS TECHNOLOGIES require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.