We are seeking an experienced MSBI Data Architect with strong expertise in SQL Server, data warehousing, and BI reporting solutions. The role involves designing scalable data models, building ETL pipelines, and delivering enterprise-grade reporting solutions using MSBI and Power BI stack.
Required Skills
- Strong expertise in MS SQL Server (complex queries, views, stored procedures)
- Experience in designing and developing ETL pipelines using SSIS
- Strong hands-on experience in Power BI development, including scalable and reusable solutions
- Experience integrating data from multiple sources (on-prem, cloud, APIs) into Power BI
- Strong understanding of data modeling and performance optimization
- Advanced knowledge of DAX and Power Query transformations
- Experience in SSRS report development and support
- Strong analytical and problem-solving skills
- Excellent communication skills with ability to explain technical concepts to non-technical users
- Ability to work independently and in a team environment
- Domain knowledge of manufacturing or metals industry (preferred)
Responsibilities
- Collaborate with business and technical teams to gather requirements and translate them into technical specifications
- Design and re-architect SQL-based data warehouse solutions based on evolving source systems
- Develop and maintain scalable ETL processes using SSIS
- Build and optimize Power BI dashboards and semantic data models
- Modify existing standards and custom solutions based on business requirements
- Analyze production issues and provide timely resolutions
- Work closely with offshore teams, provide requirements, and oversee delivery quality
- Perform testing and validation of BI applications and data pipelines
- Estimate effort, timelines, and support project planning for enhancements
- Develop and maintain technical documentation and design specifications