BI Solutions Architect in Kansas City, MO at APEX Systems

Date Posted: 1/12/2018

Job Snapshot

  • Employee Type:
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

Job #:  813399

Business Intelligence Solutions Architect 

Direct Hire 

Job Description Summary

Gather and analyze data to solve complex problems and evaluate scenarios to make predictions on future outcomes and support decision making. Acting independently, serves as a technical expert in Business Intelligence and data analysis. The Business Intelligence Solution Architect will be responsible for developing, implementing, and supporting enterprise Business Intelligence capabilities in a timely and accurate manner. They will lead all aspects of the delivery of Business Intelligence (BI) solutions and will synthesize overall strategy by analyzing a wide variety of solutions, selecting the most relevant tools/techniques to meet specific client requirements such as business case, pricing, or complex analysis, and interpreting and reporting on outputs. Contribute to enterprise architecture as steward for Enterprise Analytics division. Applicant must possess an excellent understanding of the data warehouse lifecycle, and advanced Business Intelligence skills.

Job Description


  • Design, develop, and implement robust BI solutions to serve the needs of our business
  • Architect and develop reporting semantic layer
  • Analyze existing databases, reports, and processes for opportunities to further automate or simplify utilizing BI tools
  • Provide design recommendations based on long-term IT organization strategy
  • Elicit business requirements, including retention, granularity, and related factors by consulting with business partners and enterprise leadership


Minimum Qualifications

  • 5+ years of experience delivering business intelligence solutions
  • 3+ years of experience with OLTP and OLAP database models
  • 3+ years of experience with SAP BusinessObjects or comparable tools
  • 1+ years of experience with PowerBI or other In-memory BI Applications
  • Extensive knowledge of Data Warehousing concepts and principles
  • Base understanding of Python, S+, SPSS, and R
  • Experience designing multi-dimensional data models using Star and/or Snowflake schemas for analytical use
  • Must be knowledgeable in agile software development lifecycles/methodologies
  • Experience with JavaScript, RESTful and SOAP-based web services, and NoSQL
  • Strong SQL Skills including writing complex queries, query optimization, error and event handling, and stored procedures


Preferred Requirements

  • 3+ Years Health Care Industry experience
  • Knowledge of Microsoft Dynamics AX, NAV or CRM preferred
  • Experience with ETL tools and Data flow (DataStage, SSIS, Informatica)
  • Experience with DB2 and Microsoft SQL Server
  • Experience using data and text mining/analytical methods

Need to be able to work on W2, client is not willing to sponsor.

Please send resumes to