Data Engineer Team Lead

Artifintech; Saint Paul (MO); On-site; USD 110,000 - 170,000; Full time

Job summary

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC in Saint Paul, MN, seeks an experienced data professional to translate business questions into analytical solutions using SQL, Python, and R. The role emphasizes building automated ETL pipelines on GCP and delivering real-time dashboards.

The ideal candidate has 5–8 years total experience with 1–3 years strong Python/SQL, and can collaborate with stakeholders, manage multiple priorities, and communicate insights to non-technical audiences.

Qualifications

• 5–8 years total experience with 1–3 years strong Python and SQL.
• Proficiency in SQL for complex queries and transformations.
• Hands-on experience with GCP services: BigQuery, Dataflow, Cloud Storage, Pub/Sub, Cloud Functions.

Responsibilities

• Perform deep-dive data analysis using SQL, Python, and R to uncover trends and insights.
• Design, build, and maintain automated ETL pipelines on GCP (Dataflow, BigQuery, Cloud Composer).
• Develop and deploy real-time dashboards using Looker, Data Studio, or Tableau to support data-driven decisions.
• Identify opportunities to streamline data workflows and improve data accessibility and reliability.

Skills

SQL

Python

R

Data analysis

Tools

BigQuery

Dataflow

Cloud Composer

Looker

Tableau

Google Data Studio

Pub/Sub

Cloud Functions

Cloud Storage

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.

ARTIFICIAL INTELLIGENCE 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. ARTIFICIAL INTELLIGENCE 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 ARTIFICIAL INTELLIGENCE 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