Data Engineer Team Lead

Cloud Analytics Technologies, LLC; Saint Paul (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

CLOUD ANALYTICS TECHNOLOGIES is seeking a data analytics professional with 5–8 years of experience and 1–3 years of strong Python and SQL skills to turn data into actionable insights.

The role emphasizes deep-dive analysis, building automated ETL pipelines on GCP, and delivering real-time dashboards with Looker, Data Studio, or similar tools. Collaboration with stakeholders and clear communication are essential in a fast-paced environment.

Qualifications

• 5–8 years of total experience in data analytics.
• 1–3 years of strong Python and SQL experience.
• GCP services experience (BigQuery, Dataflow, Pub/Sub, Cloud Functions).
• Experience building automated ETL pipelines and streaming data.

Responsibilities

• 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.
• 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.
• Identify and implement opportunities to streamline data workflows across cross-functional teams.
• Thrive in a fast-paced, high-impact environment, delivering results under tight deadlines and communicating findings clearly to technical and non-technical audiences.

Skills

SQL proficiency

Python & R for data analysis

Stakeholder communication

Data analysis & insights

Tools

BigQuery

Cloud Storage

Dataflow

Pub/Sub

Cloud Functions

Looker

Tableau

Google Data Studio

Terraform

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.

Design, build, and maintain automated ETL pipelines on GCP using tools like 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

Equal Opportunity Employer

CLOUD ANALYTICS TECHNOLOGIES LLC 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 LLC 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 LLC 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