MSBI Data Architect

Bettendorf, IA, US • Posted 4 hours ago • Updated 4 hours ago
Full Time
No Travel Required
On-site
$130,000 - $140,000/yr
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • SQL
  • Microsoft SSIS
  • Microsoft SQL Server
  • Microsoft Power BI
  • Microsoft SSRS
  • Data Architecture
  • Database
  • Data Warehouse
  • Cloud Computing

Summary

Must Have Technical/Functional Skills 

  • 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 

Generic Managerial Skills, If any 

  • Strong communication skills and client/stakeholder interfacing is mandatory. 

  • Developing reusable code/components for future use. 

  • Optimization of the applications or modules for maximum performance and scalability. 

  • Must follow and ensure the coding standards defined by Oracle and the community in the project. 

  • Strong debugging skills. 

  • Familiar with Agile and waterfall models. 

  • Strong analytical and problem solving skills. 

  • Excellent communication skills with business and technical stakeholders. 

  • Ability to work independently in a high availability manufacturing environment. 

  • Proactive mindset with ownership and accountability. 

  • Experience working in onsite–offshore delivery models. 

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91172467
  • Position Id: 9089426
  • Posted 4 hours ago

Company Info

About TATA Consultancy Services Limited

Tata Consultancy Services (TCS) is the technology partner of choice for industry leading organizations worldwide. Since its inception in 1968, TCS has upheld the highest standards of innovation, engineering excellence, and customer service.

It has set an aspiration to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence. Rooted in the heritage of the Tata Group, TCS is focused on creating long term value for its clients, its investors, its employees, and the community at large.

With a highly skilled workforce spread across 55 countries and 202 service delivery centers across the world, the company has been recognized as a top employer in six continents. With the ability to rapidly apply and scale new technologies, the company has built long term partnerships with its clients – helping them emerge as perpetually adaptive enterprises.

Many of these relationships have endured into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today.

TCS sponsors 14 of the world’s most prestigious marathons and endurance events, including the TCS New York City Marathon, TCS London Marathon and TCS Sydney Marathon with a focus on promoting health, sustainability, and community empowerment.

About_Company_OneAbout_Company_Two
Contact the job poster
DK

Dinesh Kumar

Recruiter @ TATA Consultancy Services Limited
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

St. Louis, Missouri

7d ago

Easy Apply

Full-time

100,000 - 130,000

Grand Rapids, Michigan

2d ago

Easy Apply

Full-time

100,000 - 130,000

Grand Rapids, Michigan

3d ago

Easy Apply

Full-time

100,000 - 130,000

Grand Rapids, Michigan

4d ago

Easy Apply

Full-time

100,000 - 120,000

Search all similar jobs