Business Intelligence Consultant

SmartRecruiters, Inc.; St. Louis (MO); On-site; USD 68,000 - 97,000; Full time

Job summary

Global Channel Management is seeking a Business Intelligence Consultant in the United States to develop dashboards from scratch, build metrics, and create cubes/datasets using MicroStrategy. The role requires 5+ years of MicroStrategy development and 2 years of customer-facing experience, plus strong SQL and MS Office proficiency.

The candidate will design dashboards with performance in mind, implement advanced joins and dynamic aggregations, and deliver polished information views with clear

Qualifications

• 5+ years of MicroStrategy development experience and 2 years of customer facing experience
• SQL and Database experience with a major RDBMS (Teradata, Aster, Oracle, SQL Server, etc) - Select statements, different types of joins, common database functions, SQL statement debugging, stored procedures
• Capable with the Microsoft suite (Word, Excel, Outlook, SharePoint) and excellent oral and written communication

Responsibilities

• Develop new dashboards from scratch
• Build Metrics (Simple / Compound) – understand basic settings (Smart Total, Inner/Outer join, Dynamic aggregation)
• Build Cubes/Datasets
• Build Dashboard Objects/Panel stacks / panels – use as info views
• Grids / Graphs – formatting options and filtering
• Selectors – targeting (filter vs slice)
• Navigation and Links – drilling to other objects with performance in mind, utilize images in dashboards

Skills

Customer facing experience

MicroStrategy development

Tools

SQL

SQL Server

Teradata

Microsoft Office

Job description

Global Channel Management is a technology company that specializes in various types of recruiting and staff augmentation. Our account managers and recruiters have over a decade of experience in various verticals. GCM understands the challenges companies face when it comes to the skills and experience needed to fill the void of the day to day function. Organizations need to reduce training and labor costs but at same requiring the best "talent " for the job.

Qualifications

Business Intelligence Consultant needs 5+ years of MicroStrategy development experience and 2 years of customer facing experience

Business Intelligence Consultant requires:

• SQL
  and Database experience with a major RDBMS (Teradata, Aster, Oracle,
  SQL Server, etc)- Select statements, different types of joins, common
  database functions, SQL statement debugging, stored procedures
• Capable with the Microsoft suite (Word, Excel, Outlook, SharePoint)Excellent oral and written communication

Business Intelligence Consultant duties are;

• Develop new dashboards from scratch-
• Build Metrics (Simple / Compound) – understand basic settings (Smart Total, Inner/Outer join, Dynamic aggregation)-
• Build Cubes/Datasets –
  
• Build Dashboard Objectso Panel stacks / panels – use as info views
• Grids / Graphs – formatting options and filtering
• Selectors – targeting (filter vs slice)o Text boxes / images – have good eye for placement and alignment
• Navigation
  and Links – best practices for drilling to other objects- Build with
  performance in mind (not a performance tuning assignment though)-
  Utilize JPG images in dashboards

Additional Information

$60/hr

6 months