BI Architect

Employment Type

: Full-Time


: Information Technology

BI Architect Downtown Chicago Contract to Hire Our client, a Global Financial Services Institution is looking to hire a BI Architect for a contract to hire opportunity. For more information, please contact Rachel Salrin at Top Skills 1. Must truly understand Analytics, BI, and Data mart 2. Need to be able to source and configure solutions using current technology 3. Exceptional Communication skills - Will interact with Business Partners to create artifacts and hand them of to BAs and Devs 4. DataMart and Cognos 5. Years of Exp 5+ Nice To Have 1. Financial Services Experience -------------------------------------------------------------------------------------------------------------------- bull Must have experience designing end to end business intelligence solutions bull Must be an expert in designing data marts for business intelligence reporting bull Must be an expert with Cognos, Power BI and other related BI tools bull Experience in building complex dashboards with rich visualizations and complex data sets. bull Must be able to design and build a semantic model with a scalable physical, logical and Presentation layers. bull Must understand complex data models and mappings, prevention of unions, stitches, unions, nested datasets, et al bull Must be able to quickly 'visualize' the SQL getting passed to the database, understanding the WHERE, SELECT, GROUP BY, RANKORDER and aggregation functions and on what tables - based solely on the input prompts and the output layout bull Must be able to talk to report authors, developers and data modelers in their own lingo bull Must have client and stakeholder interaction abilities and working with cross functional teams bull Work closely with business stakeholders, business analysts, internal customers, developers and architects to implement Bi systems bull Experience with building analytics in Azure a strong plus bull Performance tuning and query optimization experience is required bull Must have very good exposure to Agile project execution. bull Must understand basic governor settings, server versus database side processing DMR versus relational, pitfalls of DQM Use of a DQ Analyzer to isolate issues bull Desired experience with latest Business Intelligence and analytical technologies (Ex Analytics, Big Data, Statistics, Algorithms, and Cloud computing etc...) bull Prior experience working with financial systems and data marts is a plus bull Understanding application of Machine Learning to BI a plus EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or 844-463-6178.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...