BI Architect in Chicago, IL at Signature Consultants

Date Posted: 5/8/2020

Job Snapshot

  • Location:
    Chicago, IL
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    5/8/2020
  • Job ID:
    307922

Job Description

Senior BI Architect Summary:

Signature Consultants has an opportunity for a Senior BI Architect. Our client is seeking a candidate with experience designing end-to-end business intelligence solutions. The candidate must be an expert in designing data marts for business intelligence reporting and also be an expert with Cognos, Power BI and other related BI tools.

Qualifications:

  • Experience in building complex dashboards with rich visualizations and complex data sets.
  • Must be able to design and build a semantic model with a scalable physical, logical and Presentation layers.
  • Must understand complex data models and mappings, prevention of unions, stitches, unions, nested datasets
  • Must be able to quickly "visualize" the SQL getting passed to the database, understanding the WHERE, SELECT, GROUP BY, RANK/ORDER and aggregation functions and on what tables - based solely on the input prompts and the output layout
  • Must be able to talk to report authors, developers and data modelers in their own lingo
  • Must have client and stakeholder interaction abilities and working with cross functional teams
  • Work closely with business stakeholders, business analysts, internal customers, developers and architects to implement Bi systems
  • Experience with building analytics in Azure a strong plus
  • Performance tuning and query optimization experience is required
  • Must have very good exposure to Agile project execution.
  • Must understand basic governor settings, server versus database side processing; DMR versus relational, pitfalls of DQM; Use of a DQ Analyzer to isolate issues
  • Desired experience with latest Business Intelligence and analytical technologies (Ex: Analytics, Big Data, Statistics, Algorithms, and Cloud computing etc.)
  • Prior experience working with financial systems and data marts is a plus.
  • Understanding application of Machine Learning to BI is a plus.

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.

Job Requirements

Senior BI Architect • Must have experience designing end to end business intelligence solutions • Must be an expert in designing data marts for business intelligence reporting • Must be an expert with Cognos, Power BI and other related BI tools • Experience in building complex dashboards with rich visualizations and complex data sets. • Must be able to design and build a semantic model with a scalable physical, logical and Presentation layers • Must understand complex data models and mappings, prevention of unions, stitches, unions, nested datasets, et al • Must be able to quickly ”visualize” the SQL getting passed to the database, understanding the WHERE, SELECT, GROUP BY, RANK/ORDER and aggregation functions and on what tables – based solely on the input prompts and the output layout • Must be able to talk to report authors, developers and data modelers in their own lingo • Must have client and stakeholder interaction abilities and working with cross functional team • Work closely with business stakeholders, business analysts, internal customers, developers and architects to implement Bi systems • Experience with building analytics in Azure a strong plus • Performance tuning and query optimization experience is required • Must have very good exposure to Agile project execution. • Must understand basic governor settings, server versus database side processing; DMR versus relational, pitfalls of DQM; Use of a DQ Analyzer to isolate issues • Desired experience with latest Business Intelligence and analytical technologies (Ex: Analytics, Big Data, Statistics, Algorithms, and Cloud computing etc...) • Prior experience working with financial systems and data marts is a plus • Understanding application of Machine Learning to BI a plus

CHECK OUT OUR SIMILAR JOBS

  1. Architect Jobs
  2. Systems Engineer Jobs