Software Developer, Business Intelligence Analyst

Tata Consultancy Services Limited

Apex, NC, United States

about 1 month ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Compensation

$90,000.0 - $130,000.0

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Airflow Backup Devices BigQuery Cloud Database Databases Data Governance Data Integration Extract Transform Load (ETL) Database Queries Dimensional Modeling PostgreSQL Microsoft SQL Server

+20 more

SQL Azure MySQL NoSQL Performance Tuning Power BI SQL Stored Procedures SQL Databases SQL Server Integration Services Tableau (Software) Snowflake Database Optimization Amazon Relational Database Service Qlikview Star Schema Non-relational Database Splunk Looker Analytics Data Pipelines Servicenow Amazon 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.