MSBI Data Architect

Role - MSBI Data Architect

Location -Davenport, IA (Remote)

Job type- Full Time Employment

Job description Below

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.