Job Search
Home > Job Search

Solution Architect - Microsoft Business Intelligence

Closing on:


Brief description :

Solution Architect - Microsoft Business Intelligence 

A key part of Navigant's work with clients involves leveraging Navigant’s proprietary analytic models, tools and products to perform analytics on data to generate insights for our clients. The solution architect will be responsible for delivering quality solutions using the Microsoft’s SQL Server Business Intelligence suite of tools; as well as providing technical architecture and leadership to other team members.  The primary areas of focus for candidate are Data Modeling and Management, Business Intelligence, and Reporting technologies as well as a proven history of successfully architecting and delivering scalable solutions.

Solution architect duties will include working with a broad base of business and technical team members to assist with requirement definitions, solution design and technical architecture and delivery.  Solution architect will work in a collaborative fashion with team members including project managers, scrum masters, technical leads and business analysts.  In addition, you will ensure the development and delivery efforts and provide technical guidance, as needed, to other team members for quality assurance, mentoring and growth opportunities. The ideal candidate will look forward to being challenged and continuing to successfully grow, not only their technical skills but their business and consultative skills as well.



  • Implement solutions using the Microsoft SQL Server Business Intelligence tool suite
  • Develop and maintain advanced database systems including data warehouses, data marts, and models needed for business, financial and operational analysis and/or reporting
  • Develop highly performant, reliable and scalable automated solutions to support large volumes of data coming from disparate systems/sources of multiple clients
  • Ability to clearly communicate technical details to business and management personnel
  • Perform data analysis that will support and enhance Information Management systems
  • Author, oversee and gain approval of design documents for projects assigned
  • Develop reports, dashboards & scorecards, data exploration and visual analytics using existing and emerging tools and technologies.
  • Follow best practice methodologies for database development and design
  • Analysis, architecture, design, and development of ETL, data warehouse and business intelligence systems
  • Work independently or as part of a team to design and develop solutions.
  • Provide meaningful feedback and coaching of other team members to successfully overcome technological challenges
  • Leading and demonstrated emerging technologies and concepts to teams

Preferred skills


  • Expert knowledge of Data Management, Business Intelligence and Analytics concepts including:
    • Extract, Transform, Load (ETL), Data Quality and Profiling
    • Data Warehousing, Data Lakes, Data Marts, Data Stores, and Cubes
    • Data Governance, Master Data Management, and Metadata Management
    • Data Visualization, Dashboard, Reporting, Self Service Business Intelligence (BI), Key Performance Indicators (KPI), and Scorecards
    • Descriptive, Predictive and Prescriptive Analytics
    • Pattern matching and Machine Learning
  • Expert knowledge of Microsoft Business Intelligence stack including:
    • SQL Server, Transact SQL (tSQL)
    • Visual Studio (VS), Team Foundation Server (TFS)
    • SQL Server Management Studio (SSMS), Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS)
    • Master Data Services (MDS) and Data Quality Services (DQS)
    • Power BI and Excel
  • Minimum of 7-10 years of experience
  • Proven experience with data warehousing and data modeling, specifically building/understanding OLTP & OLAP models
  • Microsoft SQL Server Business Intelligence Certifications is highly preferred
  • Passionate about learning new technologies
  • Ability to learn new concepts and software quickly
  • Analytical approach to problem-solving; ability to use technology to solve business problems
  • Familiarity with database-centric applications, BI tools like Tableau and Spotfire
  • Ability to communicate effectively in both a technical and non-technical manner
  • Ability to work in a fast-paced environment
  • Experience working with various industry verticals (e.g., insurance, financial services, technology)
  • Excellent time management, verbal and written communication skills