Software Developer, Business Intelligence Analyst

Tata Consultancy Services Limited
Apex, United States of America
10 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 130K

Job location

Apex, United States of America

Tech stack

Airflow
Backup Devices
Google BigQuery
Cloud Database
Databases
Data Governance
Data Integration
ETL
Database Queries
Dimensional Modeling
PostgreSQL
Microsoft SQL Server
SQL Azure
MySQL
NoSQL
Performance Tuning
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Tableau
Snowflake
Database Optimization
Amazon Web Services (AWS)
QlikView
Star Schema
Non-relational Database
Splunk
Looker Analytics
Data Pipelines
ServiceNow
Redshift

Job description

Roles & Responsibilities Database Management

  • Administer, maintain, and optimize relational and non-relational databases (e.g., SQL Server, MySQL,

  • PostgreSQL, NoSQL platforms).

  • Develop and manage data models, schemas, indexing strategies, and stored procedures.

  • Ensure database availability, reliability, and performance through routine health checks and monitoring.

  • Implement data governance, quality standards, and integrity validation processes.

  • Manage database backups, replication, DR/BCP, and recovery plans.

  • Support database integrations across applications, platforms, and ETL/ELT pipelines.

  • Troubleshoot database issues and execute remediation actions within agreed SLAs.

Business Intelligence & Analytics

  • Design, build, and maintain BI dashboards, scorecards, KPIs, and analytics reports

  • (e.g., Power BI, Tableau, Looker, Qlik, Splunk, ServiceNow, etc.).

  • Translate business requirements into visual dashboards aligned to operational and executive reporting needs.

  • Develop automated metrics pipelines, scheduled refresh cycles, and high-quality visualizations.

  • Validate data accuracy, reconcile data discrepancies, and ensure metric alignment with business definitions.

  • Work with stakeholders to define KPIs, operational metrics, and measurement frameworks.

  • Perform ad-hoc data analysis and deliver insights to support decision-making.

  • Standardize reporting templates, BI governance models, and documentation.

Requirements

Must Have Technical/Functional Skills

  • Strong proficiency in SQL (including complex queries, tuning, stored procedures).

  • Database administration experience in SQL Server, MySQL, PostgreSQL, or similar.

  • Experience with BI tools such as Splunk, Power BI, Tableau, Looker, ServiceNow, or Qlik.

  • Proficiency with ETL/ELT tools (e.g., SSIS, Informatica, dbt, Airflow).

  • Understanding of data modeling (star schema, snowflake, dimensional modeling).

  • Knowledge of cloud data architectures (AWS RDS/Redshift, Azure SQL, GCP BigQuery preferred).

  • Proficiency in leveraging Artificial Intelligence (AI) to drive innovation and efficiency within technical domains.

Apply for this position