Specialist -Reporting and Analytics

Tata Consultancy Services; Philadelphia (Philadelphia County); On-site; USD 90,000 - 100,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Family Support: Leaves

Insurance Options: Auto & Home

Job summary

Tata Consultancy Services in the United States seeks a hands-on Reporting & Analytics Specialist to design, build, and automate Tableau/SQL reporting solutions. You will connect data from multiple sources, normalize via scripted pipelines, and deliver polished dashboards for technical and executive audiences.

Responsibilities include optimizing SQL queries, integrating databases and APIs, and applying best-practice data visualization to drive data-driven decisions.

Qualifications

• Strong SQL skills with complex joins, aggregations, and window functions.
• Hands-on experience building dashboards in Tableau and Power BI.
• Experience connecting multiple data sources into consolidated datasets.
• Script-based data normalization and transformation (Python or similar).
• Understanding of data visualization principles and dashboard design best practices.
• Ability to translate business questions into reporting requirements.
• Familiarity with CMDB concepts (ServiceNow CMDB, CI classes, assets).
• Exposure to Databricks, Tableau APIs, or similar reporting automation tools.
• Knowledge of IT infrastructure concepts (servers, networks, discovery tools).
• Experience in enterprise IT, telecom, or cybersecurity-adjacent environments.
• Experience with ServiceNow reporting or Performance Analytics.

Responsibilities

• Design, develop, and maintain Tableau/Power BI reports for operations and execs.
• Write and optimize complex SQL queries for large datasets and performance tuning.
• Integrate data from databases, APIs, and flat files into unified datasets.
• Build scripted data normalization and transformation pipelines (Python).
• Aggregate data across domains to produce reliable KPIs.
• Apply visualization best practices for clear storytelling and drill-downs.
• Collaborate with stakeholders to gather requirements and deliver scalable products.
• Automate recurring reports to improve speed and consistency.
• Validate data quality and document data lineage and logic.

Skills

SQL

Tableau

Power BI

Data integration

Python

Data visualization

Stakeholder communication

CMDB

Databricks

ServiceNow reporting

Data quality

Education

Bachelor's degree in computer science, engineering, information systems

Master's degree preferred

Tools

Tableau

Power BI

Python

ServiceNow

Job description

Job Description

Reporting & Analytics Specialist (Tableau/SQL)

Must Have Technical/Functional Skills

• Strong SQL skills — complex joins, aggregations, window functions, query optimization.
• Proven hands-on experience building dashboards in Tableau and Power BI.
• Experience aggregating data and connecting multiple data sources into consolidated reporting datasets.
• Experience with script-based data normalization and transformation (Python or similar).
• Solid understanding of data visualization principles and dashboard design best practices.
• Ability to work with stakeholders to translate business questions into reporting requirements.
• Strong attention to detail and commitment to data accuracy.
• CMDB knowledge — familiarity with configuration management databases (e.g., ServiceNow CMDB), CI classes, relationships, and asset/configuration data structures.
• Exposure to Databricks, Tableau APIs, or other reporting automation frameworks.
• Familiarity with IT infrastructure concepts (servers, network devices, discovery tools).
• Experience in enterprise IT, telecom, or cybersecurity-adjacent environments.
• Experience with ServiceNow reporting, Performance Analytics, or asset management data.

Roles & Responsibilities

About The Role We are looking for a hands‑on Reporting & Analytics Specialist to design, build, and automate reporting solutions that give the organization trusted, actionable visibility into its data. You will connect and integrate data from multiple sources, normalize and transform it through scripted pipelines, and deliver polished dashboards and reports that drive decision‑making for technical and executive stakeholders alike.

Key Responsibilities

• Design, develop, and maintain reports and dashboards in Tableau and Power BI for operational and executive audiences.
• Write and optimize complex SQL queries for data extraction, aggregation, joins across large datasets, and performance tuning.
• Connect and integrate multiple data sources (databases, APIs, flat files, enterprise platforms) into unified reporting datasets.
• Build and maintain scripted data normalization and transformation pipelines (e.g., Python) to standardize, cleanse, and reconcile data from disparate systems.
• Aggregate data across domains to produce consistent, reliable metrics and KPIs.
• Apply data visualization best practices to make complex data intuitive — right chart for the right story, clean layouts, drill-down paths.
• Partner with business and technology stakeholders to gather reporting requirements and translate them into scalable reporting products.
• Automate recurring manual reporting processes to improve speed, consistency, and scalability.
• Validate data quality and investigate discrepancies across source systems; document data lineage and reporting logic.

Education

Bachelor’s degree in computer science, engineering, information systems, or a related technical field; master’s degree preferred

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: $90000 - 100000 a year

Qualifications

BACHELOR OF COMPUTER SCIENCE