MS BI Data Architect

MS BI Data Architect
Remote
Full Time

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