MSBI Data Architect

Job Title: MSBI Data Architect

Location: Davenport, IA- Remote

Full-Time




Job Description

Must Have Technical/Functional Skills

o Strong foundation in MS SQL server

o Create complex SQL queries, view, Stored procedure etc. in SQL server.

o Design and implement robust ETL using SSIS.

o Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.

o Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI.

o Optimize data models for performance, ensuring efficient data retrieval and processing.

o Develop advanced DAX formulas and Power Query transformations to create complex calculations and data

transformations.

o Understanding and support existing reports in SSRS and developing new reports.

o Domain knowledge of metal and manufacturing industry is a big plus

o Strong analytical and problem-solving skills.

o Excellent communication and presentation skills, with the ability to convey technical concepts to

non-technical audiences.

o Ability to work effectively both independently and as part of a team

Roles & Responsibilities

o Coordinate with external technical and Functional team to understand requirements, convert that to

technical specifications.

o Understand existing source SQL data architecture

and rearchitect downstream SQL Datawarehouse based on new source system

o Modify existing standards as well as customized program based on requirement

o Analyze issues and provide resolution

o Work with offshore team to provide the requirements and supervise the overall work

o Testing of application

o Estimate the effort and timelines for enhancements

o Create/update technical specifications

Generic Managerial Skills, If any

o Strong communication skills and client/stakeholder interfacing is mandatory.

o Developing reusable code/components for future use.

o Optimization of the applications or modules for maximum performance and scalability.

o Must follow and ensure the coding standards defined by Oracle and the community in the project.

o Strong debugging skills.

o Familiar with Agile and waterfall models.

o Strong analytical and problem solving skills.

o Excellent communication skills with business and technical stakeholders.

o Ability to work independently in a high availability manufacturing environment.

o Proactive mindset with ownership and accountability.

o Experience working in onsite offshore delivery models.