Senior BI Architect @ Chicago, IL

Hello All,

Please find the below requirement details and send the most suitable resume to Ranjith.dandabathini@sstech.us

 

Position: Senior BI Architect

Location: Chicago, IL

Duration: 8 Months+

 

 

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. FS Experience

 

This role will backfill two former FTEs. The role will be on the Enterprise Analytics Team where they do large scale projects and smaller projects for external clients. The HM shares these resources across 15 projects. This is a great opportunity for people who like to work on interesting projects in all areas of the business. There are projects tied to Machine Learning and AI projects so there will be several opportunities to work with cutting-edge technology. There is currently one person working in this capacity since the other two left the team. We really need someone who can come in and hit the ground running. This role will interface with business partners across the enterprise, in addition to on and off shore developers, as well as BAs. Please be sure to ask potential candidates what is their specific experience with Data Marts and Cognos. Please outline these two questions in your supplier summaries. This will be a contract to hire so also add FT salary expectations to the summary.

 

------------------------------------------------------------------------------------------------------------------------------

 

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 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 a plus

 

 

Regards,

Ranjith Dandabathini

System Soft Technologies

Ranjith.dandabathini@sstech.us

727-860-7634