Data Analytics Tech Lead — SQL/dbt & Insight Delivery

Tata Consultancy Services Limited; Pittsburgh (Allegheny County); On-site; USD 110,000 - 120,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Dental & Vision Coverage

Disability Insurance

401K Plan

Performance Bonus

Certification & Training Reimbursement

Vacation and Holidays

Job summary

Tata Consultancy Services Limited in Pittsburgh, PA seeks a Technical Lead to drive analytics engineering initiatives and partner with cross-functional teams.

The role focuses on data transformation using dbt and SQL, building dashboards with Looker or Tableau, and delivering reliable metrics for business decisions. 1-3 years of relevant experience preferred; strong data quality is essential.

Qualifications

• 1-3 years of experience in analytics engineering or data engineering
• Proficiency in SQL; dbt or similar transformation tools a bonus
• Familiarity with data warehousing concepts and analytics best practices
• Strong attention to detail and data quality
• Ability to work collaboratively in a fast-paced, team-oriented environment

Responsibilities

• Contribute to data transformation logic and maintain data models using dbt and SQL
• Write and optimize SQL queries for data transformation and analysis
• Assist in implementing and maintaining data quality checks and testing procedures
• Contribute to documentation of data models, transformations, and business logic
• Develop and maintain reports and dashboards to surface actionable insights
• Support delivery of business and operational metrics in partnership with Analytics and senior team members
• Work with team and stakeholders to translate business requirements into data needs

Skills

Analytics engineering

SQL

Collaboration

Attention to detail

Education

Bachelor of Computer Science

Tools

dbt

Looker

Tableau

AWS

GCP

Databricks

BigQuery

Job description

Tata Consultancy Services Limited in Pittsburgh, PA seeks a Technical Lead to drive analytics engineering initiatives and partner with cross-functional teams.

The role focuses on data transformation using dbt and SQL, building dashboards with Looker or Tableau, and delivering reliable metrics for business decisions. 1-3 years of relevant experience preferred; strong data quality is essential.