MSBI Data Architect

Domain : Metal and manufacturing industry
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.

Work arrangement
No