BI / Solution Architect

About this role

Responsibilities

• Design and enhance enterprise BI and data warehouse solutions.
• Lead data modeling, database design, and ETL development activities.
• Provide architectural guidance and technical mentorship to BI development teams.
• Participate in planning, prioritization, and release management activities.
• Collaborate with architects and stakeholders across multiple organizations and business areas.
• Support continuous improvement of development standards, frameworks, and best practices.
• Contribute to decision-making related to BI platforms, reporting solutions, and front-end architecture.
• Act as a subject matter expert for BI managers and project teams.
• Required Experience
• To be successful in this role, you should have:
• At least 10 years of hands-on experience working with Microsoft SQL Server.
• Extensive experience in data modeling and enterprise-scale BI environments.
• Strong background in Data Warehouse development and ETL processes using SSIS.
• Proven experience administering and maintaining on-premises SQL Server environments.
• Demonstrated expertise in designing and implementing modern data platforms with overall technical responsibility.
• Experience delivering BI solutions within public sector organiza