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.