Technical Architect BI

Tata Consultancy Services Ltd

Foster City, CA

JOB DETAILS
SALARY
$130,000–$180,000 Per Year
SKILLS
Application Programming Interface (API), Authentication, Automation, Best Practices, Business Intelligence, Cloning, Data Cleaning, Data Modeling, Data Sets, DevOps, Documentation, Embedded Systems, Incident Response, JavaScript, Legal, Loan Funding, Microsoft Windows Azure, Performance Modeling, Performance Tuning/Optimization, Power BI, REST (Representational State Transfer), Reporting Dashboards, Scripting (Scripting Languages), Student Loans, Telemetry, Training/Teaching, Usage Analysis, Windows PowerShell
LOCATION
Foster City, CA
POSTED
30+ days ago

Role - Technical Architect BI

Experience Required - 8+ Years

Must Have Technical/Functional Skills

  • 6-10 years of experience in Power BI development and administration.
  • Proficiency in Power BI REST APIs, JavaScript SDK, and Power BI Embedded.
  • Deep understanding of RLS/OLS, workspace management, and dataset security.
  • Hands-on with Azure AD, service principals, and token authentication flows.
  • Knowledge of DAX, data modeling, and performance tuning best practices.
  • Familiarity with DevOps tools, PowerShell automation, and monitoring frameworks.

Roles & Responsibilities

Integration & Automation

  • Configure Power BI environments (workspaces, datasets, reports, and gateways).
  • Develop REST API-based automation for report publishing, dataset refresh, and workspace synchronization.
  • Manage embed tokens, service principals, and app registrations for secure embedding.
  • Implement SDK-based integration for embedding, parameter passing, and event tracking.

Security & Access Control

  • Define and apply RLS/OLS rules based on user roles and data sensitivity.
  • Synchronize user roles and access with external IAM systems.
  • Enable secure dataset sharing, report cloning, and versioning.
  • Establish telemetry and audit logging frameworks for usage analytics.

Operations & Monitoring

  • Automate monitoring of dataset refreshes and workspace capacities.
  • Build usage dashboards leveraging Power BI Admin APIs.
  • Manage incident response, workspace governance, and performance tuning.

Collaboration & Enablement

  • Work with backend developers to implement token and API-based report access.
  • Partner with data engineers to ensure clean, optimized data models.
  • Provide training and documentation for embedded report management.

DevOps & Continuous Improvement

  • Automate deployment workflows for Power BI assets using PowerShell or Azure DevOps.
  • Maintain scripts for environment migration and dataset lineage validation.
  • Evaluate and implement new API features or SDK improvements for continuous enhancement.

Base Salary Range : $130,000 to $180,000 Per Annum

TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensiv e 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.

About the Company

T

Tata Consultancy Services Ltd