MSBI Data Architect

Must Have Technical/Functional Skill 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 Salary Range $120,000-$130,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. #LI-SP1