Skip to main content
Tallo logoTallo logo

Find Jobs

Find Jobs Near You – Available Work in Your Location

Skip to job details

Back to Results

Apply for this opportunity

To apply for this job, you'll continue to an external website or email application.

Tata Consultancy Services Limited

MSBI Data Architect

Career Insights for Data Architect

See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.

Scorecard

Based on Iowa data

Review key factors to help you decide if this role fits your goals. How is this calculated?

Were these scores useful?

What they do

A Data Architect develops computer databases for a company or organization. Designs, builds and implements databases and database systems that meet business requirements. Supports database administration, develops database security policies and works to prevent cyber attacks.

$150,554 / year median in Iowa

-2% projected decline

Explore Career

Job Description

Must Have Technical/Functional Skills o Strong foundation in MS SQL server o Create complex SQL queries, view, Stored procedure etc. in SQL server. o Design and implement robust ETL using SSIS. o Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards. o Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI. o Optimize data models for performance, ensuring efficient data retrieval and processing. o Develop advanced DAX formulas and Power Query transformations to create complex calculations and data transformations. o Understanding and support existing reports in SSRS and developing new reports. o Domain knowledge of metal and manufacturing industry is a big plus o Strong analytical and problem-solving skills. o Excellent communication and presentation skills, with the ability to convey technical concepts to non-technical audiences. o Ability to work effectively both independently and as part of a team Roles & Responsibilities o Coordinate with external technical and Functional team to understand requirements, convert that to technical specifications. o Understand existing source SQL data architecture and rearchitect downstream SQL Datawarehouse based on new source system o Modify existing standards as well as customized program based on requirement o Analyze issues and provide resolution o Work with offshore team to provide the requirements and supervise the overall work o Testing of application o Estimate the effort and timelines for enhancements o Create/update technical specifications Generic Managerial Skills, If any o Strong communication skills and client/stakeholder interfacing is mandatory. o Developing reusable code/components for future use. o Optimization of the applications or modules for maximum performance and scalability. o Must follow and ensure the coding standards defined by Oracle and the community in the project. o Strong debugging skills. o Familiar with Agile and waterfall models. o Strong analytical and problem solving skills. o Excellent communication skills with business and technical stakeholders. o Ability to work independently in a high availability manufacturing environment. o Proactive mindset with ownership and accountability. o Experience working in onsite-offshore delivery models.
Salary Range:
$130,000 - $140,000 a year
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 & amp; Training Reimbursement.
Time Off:
Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance:
Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing. #LI-SP1

Benefits

  • Sick Leave
  • 401(k) Plans
  • Bonuses/Stipends
  • Health Insurance