Data Analyst

Data Analyst Tata Consultancy Services•3.9 Lewisville, TX Job Details $100,000•$120,000 a year 1 day ago Qualifications Performance dashboard reports Data model design Dashboard development Performance tuning Power BI Data visualization software proficiency Computer Science Automation Data modeling projects Data reporting SQL Pattern recognition Outlier detection Bachelor's degree Improving database performance Data analytics tools Senior level Bachelor's degree in computer science Technical Proficiency Python Data extraction Full Job Description Must Have Technical/Functional Skills Design, write, and optimize complex SQL queries to extract, transform, and analyze data from multiple sources Develop and maintain Power BI dashboards and reports, ensuring data accuracy, performance, and business relevance Use Python for data cleaning, transformation, automation, and advanced analytics Strong hands on experience with SQL (joins, CTEs, subqueries, performance optimization) Strong hands on experience with Advanced SQL, including: Window functions (ROW_NUMBER, RANK, LAG/LEAD) CTEs and recursive queries Query performance tuning and optimization Advanced aggregations and conditional logic Roles & Responsibilities Design, write, and optimize advanced SQL queries involving: Complex joins Common Table Expressions (CTEs) Window/analytic functions Subqueries and correlated subqueries Perform data analysis on large, complex datasets to identify trends, patterns, and anomalies Optimize query performance using indexes, execution plans, and query refactoring Develop and maintain SQL based data models, views, and stored procedures Support data extraction and transformation for reporting and analytics use cases

Salary Range:

$100,000 to $120,000 per year Location Lewisville, TX Job Function

TECHNOLOGY

Role Analyst Job Id 407489 Desired Skills Python Salary Range $100,000•120,000 a year

Desired Candidate Profile Qualifications :

BACHELOR OF COMPUTER

SCIENCE