MSBI Data Architect

Title: MSBI Data Architect

Location: Bettendorf, IA

• 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