Technical Lead

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

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Family Support: Leaves

Insurance Options: Auto & Home

Certification & Training Reimbursement

Vacation, Time Off, Holidays

401K Plan, Bonus

Salary Range: $110,000 – 120,000 a/yr

Job summary

Tata Consultancy Services in Pittsburgh is seeking an Analytics Engineer to contribute to data transformation, modeling, and reporting efforts. You will work with dbt and SQL to build reliable data pipelines and ensure data quality.

Collaborating with Analytics and engineering teams, you will gain exposure to cloud data platforms and BI tools while contributing to enterprise intelligence initiatives and AI-inspired analytics applications.

Qualifications

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

Responsibilities

• Contribute to the development of data transformation logic and maintain existing 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 using visualization tools to surface actionable insights.
• Support the delivery of business and operational metrics in partnership with Analytics and senior team members.
• Work jointly with team members and stakeholders to accomplish shared outcomes.
• Participate in cross-functional meetings to understand business requirements and translate them into data needs.

Skills

Analytics engineering

SQL

dbt

Data warehousing

Data quality

Collaboration

Education

Bachelor of Computer Science

Tools

dbt

Looker

Tableau

BigQuery

Job description

Required

• 1–3 years of experience in analytics engineering, data engineering, or a related field

Job Description

Must Have Technical/Functional Skills

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

Preferred

• Exposure to cloud data platforms (GCP, AWS, Databricks, BigQuery)
• Experience with BI/visualization tools (Looker, Tableau, or similar)
• Interest in AI, machine learning, and enterprise intelligence applications

Data Transformation & Modeling

• Contribute to the development of data transformation logic and maintain existing 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

Analytics & Reporting

• Develop and maintain reports and dashboards using visualization tools to surface actionable insights
• Support the delivery of business and operational metrics in partnership with Analytics and senior team members

Collaboration & Growth

• Work jointly with team members and stakeholders to accomplish shared outcomes
• Participate in cross-functional meetings to understand business requirements and translate them into data needs
• Build collaborative relationships across engineering and analytics teams

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
• Salary Range: $110,000 – 120,000 a year

Qualifications

BACHELOR OF COMPUTER SCIENCE