RSM has an opening for a functional Consulting Manager focused on Business Intelligence in our Technology Consulting Practice. This is a client-facing role focusing on the sale, implementation, and support of Business Intelligence products and services. You will work closely with Project Managers and fellow Consultants in conducting multiple client projects ranging from consulting services, customization design, and technical support, to full implementation. The successful candidate must be knowledgeable in all aspects of design and construction of Business Intelligence solutions. They will be a problem solver, creative thinker, fast learner, be detail-oriented, and interested in learning their clients' business.

Responsibilities:

• Guide clients and prospects in their evaluation of Business Intelligence solutions providing information and demonstrations to help them assess fit for their business

• Design, architect, implement and support simple to complex enterprise data warehouses using Microsoft SQL on-premises or Azure cloud technologies

• Scope the implementation services required to help clients achieve their objectives

• Ensure completion of tasks, milestones, and components including but not limited to functional specifications, design specifications, configurations, quality assurance, implementations, and project reviews

• Spearheads development of logical and physical data models, and ETL development, as needed

• Building reports, dashboards and scorecards using a variety of tool

• Trained users and system administrators

• Provide clients with ongoing technical support and troubleshooting

• Lead additional optimization projects as clients businesses change and grow

• Work on multiple projects at the same times

• Interact effectively with internal and external resources at all organizational levels

Basic Qualifications:

• Bachelor's degree or graduate degree and 6-8 years of related work experience

• Experience with data modeling (normalized and de-normalized data models),understanding of the appropriate purpose for each

• Strong focus and ability to design, manage and construct a Dimensional Data Warehouse

• Proficiency with Microsoft SQL Server Database Engine (database administration/maintenance), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Experience using T-SQL scripts (stored procedures, views, functions etc.) to manipulate data and simplify access to data

• Experience with Microsoft Azure technologies (Azure Data Factory, Data bricks, Azures DB, Azure SQL DW, Azure Data Lake, Analysis Services)

• Excellent project management, organization, and follow-up skills

• Excellent client skills and customer relationship management skills

• Ability to meet deadlines and work on multiple projects simultaneously

• Must be a team player; able to work in virtual teams and independently

• Willingness and ability to travel

• Strong financial and business acumen, and ability to speak about technology in the language of business

• Extensive Experience managing team