Microsoft Business Intelligence Solution Architect

8 - 10 years experience  •  IT Consulting/Services

Salary depends on experience
Posted on 10/14/17
8 - 10 years experience
IT Consulting/Services
Salary depends on experience
Posted on 10/14/17

s an Information Management & Analytics (IM&A) Solution Architect for Slalom Consulting, you will beresponsible for delivering quality solutions using the Microsoft’s SQL Server Business Intelligence suite of tools; as well as providing technicalarchitecture and leadership toother team members. The primary areas of focus for a candidate are Data Management, Business Intelligence, andReportingtechnologiesas well as a proven history of successfully architecting and delivering solutions.


Your 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. As a Slalom Consultant, you will work in a collaborative fashion with team members including project managers, scrummasters, solution architects, 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.


Slalom’s consultants wear many hats and are introduced to many different situations. 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.

  • ResponsibilitiesTechnical delivery in both Agile and Waterfall methodologies
  • 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 solutions
  • 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
  • Assist business development team with pre-sales activities and RFPs
  • Provide meaningful feedback and coaching of other team members to successfully overcome technological challenges
  • Leading and demonstrated emerging technologies and concepts to teams
  • QualificationsExpert knowledge of Data Management, Business Intelligence and Analytics concepts including:
    • Extract, Transform, Load (ETL)
    • Data Warehousing, Data Lakes, Data Marts, Data Stores, and Cubes
    • Data Quality and Profiling,
    • Data Governance, Master Data Management, and Metadata Management
    • Data Visualization, Dashboard, Reporting, Self Service Business Intelligence (BI), Key Performance Indicators (KPI), and Scorecards
    • Predictive, Prescription, and Descriptive Analytics
  • 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)
    • SQL Server Integration Services (SSIS)
    • SQL Server Analysis Services (SSAS)
    • Master Data Services (MDS)
    • Data Quality Services (DQS)
    • SQL Server Reporting Services (SSRS)
    • Power BI
    • Azure Data Factory
    • Azure SQL Data Warehouse
    • Azure Data Lake 
    • Excel
  • Minimum of 7-10 years of experience
  • 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
  • Ability to communicate effectively in both a technical and non-technical manner
  • Ability to work in a fast-paced environment
  • Proven experience with data warehousing and data modeling, specifically building/understanding OLTP & OLAP models
  • Experience working with various industry verticals (e.g., insurance, utilities, manufacturing, financial services, technology)
  • Microsoft SQL Server Business Intelligence Certification(s) a plus

Job Number: JO-1710-1911

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.