SQL Business Intelligence Data Warehouse Architect

Job Title: SQL Business Intelligence Data Warehouse Architect

Location of role: Skokie, IL 60076 - Need to come onsite for Drug Screen - Mostly Remote role with very little time onsite, may go hybrid in 2023. Do not know yet. Need to live within a 2 hour radius of Skokie, IL or be relocating close by

Salary or Hourly range: 105K to 120K depending on experience

Direct hire Role - Fulltime

Key Points of the role:

Our ideal candidate will have:

6+ years of enterprise data warehouse industry with Business Intelligence tools ideally strong exp with Tableau/Cognos, and writing Reports/Dashboards in design, development, architecture.

4+ years of experience in writing complex SQL

Experience and understanding of data sources including 3rd party RDBMS, SQL server and Oracle

Experience in Reports QA/QC testing a plus

Sharing on-call production support with other members of the team.

Familiarity with healthcare industry or healthcare information systems is a plus

In this role, you will:

Support various BI Enterprise Application Servers, Security and users

Designing, developing and maintaining business intelligence solutions

Develop Reports/dashboards in business intelligence reporting tools SQL Server Reporting Services, Crystal Reports, Tableau, Cognos

Responsible for the identification of data items through research, analysis, profiling, data mining, and data discovery of the source data from Epic and other clinical ancillary systems.

Gathers business requirements by conducting meetings/interviews, and facilitating large-group/cross-functional sessions with customers, while containing the scope of the initiative.

Interact with business analysts and IT analysts to efficiently and clearly interpret business requirement specifications.

Design and develop complex SQL queries.

Document data standards, requirement specifications, and business processes.

Build relationships across the enterprise, working with analytics and data teams for insights and best practice sharing

Company relocation - At this time, client will NOT relocate for this role

If applying for this role - Please take each key point and provide number of years experience and what you would rate yourself, 1 thru 10 (10 being expert) for each key point. Send your resume and notes on the role to expediate our recruiting services.