Data Engineer Team Lead

Robotics Technologies LLC; Missouri; On-site; USD 80,000 - 100,000; Full time

Job summary

Robotics Technologies LLC is seeking candidates with expertise in Advanced Data Analysis and strong skills in Python and SQL. This role involves performing deep-dive analysis, designing automated ETL pipelines on GCP, and developing real-time dashboards to support data-driven decision making.

The ideal candidate has 5-8 years of experience and a proven track record of optimizing data workflows. Strong communication skills to collaborate with stakeholders and deliver insights effectively are also essential. The company is dedicated to inclusivity and equal opportunity.

Qualifications

• 5-8 years of overall experience with 1-3 years in Python and SQL.
• Hands-on experience with GCP services including BigQuery, Dataflow, and Cloud Functions.
• Experience building automated ETL pipelines.

Responsibilities

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

Skills

Proficiency in SQL

Intermediate experience with Python

Experience with R

Strong problem-solving skills

Excellent communication skills

Tools

GCP services

Looker

Tableau

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.

ROBOTICS 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. ROBOTICS 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 ROBOTICS 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.