MSBI Data Architect

Job Description

Must Have Technical/Functional Skill

• Strong foundation in MS SQL server
• Create complex SQL queries, view, Stored procedure etc. in SQL server.
• Design and implement robust ETL using SSIS.
• Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.
• Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI.
• Optimize data models for performance, ensuring efficient data retrieval and processing.
• Develop advanced DAX formulas and Power Query transformations to create complex calculations and data

transformations.

• Understanding and support existing reports in SSRS and developing new reports.
• Domain knowledge of metal and manufacturing industry is a big plus
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to convey technical concepts to

non-technical audiences.

• Ability to work effectively both independently and as part of a team

Roles & Responsibilities

• Coordinate with external technical and Functional team to understand requirements, convert that to

technical specifications.

• Understand existing source SQL data architecture

and rearchitect downstream SQL Datawarehouse based on new source system

• Modify existing standards as well as customized program based on requirement
• Analyze issues and provide resolution
• Work with offshore team to provide the requirements and supervise the overall work
• Testing of application
• Estimate the effort and timelines for enhancements
• Create/update technical specifications

Salary Range $120,000-$140,000 Per 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.

Qualifications: BACHELOR OF COMPUTER SCIENCE