MSBI Data Architect
Job Location:
Bettendorf, IA - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Title: MSBI Data Architect
Location: Bettendorf IA
- Strong foundation in MS SQL server
- Create complex SQL queries view Stored procedure 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
Required Skills:
MSBIData Architects