MSBI Data Architect

• 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

Must Have Technical/Functional Skills

• 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, * 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.