What are the responsibilities and job description for the BI Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, TrueHire Staffing LLC, is seeking the following. Apply via Dice today!
Note: Only for candidates who can work full time.(etc.)
Title: MSBI Data Architect
Location: Bettendorf, IA (onsite)
Duration: Full Time
Video Interviews
Experience: 10-20 years
Job Description
Must Have Technical/Functional Skill
Note: Only for candidates who can work full time.(etc.)
Title: MSBI Data Architect
Location: Bettendorf, IA (onsite)
Duration: Full Time
Video Interviews
Experience: 10-20 years
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
- 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
- Ability to work effectively both independently and as part of a team
- Coordinate with external technical and Functional team to understand requirements, convert that to
- Understand existing source SQL data architecture
- 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