Software Developer, Business Intelligence Analyst

Tata Consultancy Services Ltd

Apex, NC

JOB DETAILS
SALARY
$90,000–$130,000 Per Year
SKILLS
Amazon Relational Database Service (RDS), Analysis Skills, Application Integration, Artificial Intelligence (AI), Business Intelligence, Business Intelligence Software, Cloud Architecture, Data Analysis, Data Management, Data Modeling, Data Quality, Database Administration, Database Backup, Database Extract Transform and Load (ETL), Database Replication, Decision Support, Dimensional Modeling, GCP (Good Clinical Practices), Identify Issues, Informatica, Looker, Metrics, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Windows Azure, Multiplatform/Cross-Platform, MySQL, NoSQL, Operational Measurement, Performance Metrics, PostgreSQL, Power BI, Qlik, Quality Metrics, Reconciliation, Relational Databases (RDBMS), Reporting Dashboards, Requirements Management, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scorecarding, Service Level Agreement (SLA), ServiceNow, Snowflake Schema, Software Development, Splunk, Star Schema, Stored Procedures, Systems Administration/Management, Tableau
LOCATION
Apex, NC
POSTED
3 days ago

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.

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.

Salary Range: $90,000 - $130000 a year

#LI-CM2

About the Company

T

Tata Consultancy Services Ltd