Senior BI Lead / Architect

Derex Technologies Inc

Chicago (IL)

On-site

USD 130,000 - 180,000

Full time

8 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Derex Technologies Inc is seeking a Senior BI Lead/Architect in Chicago to drive BI modernization. The role focuses on migrating Oracle ADW and Oracle Analytics Cloud to Snowflake and Tableau Cloud, with hands-on work across Snowflake, SQL, and AWS.

The candidate will rebuild dashboards with Tableau Cloud, ensure live Snowflake connections, and enforce design standards. 4 days onsite work model, collaboration across analytics, data engineering, and architecture teams.

Qualifications

  • 10+ years of BI experience with Snowflake, AWS and Tableau Cloud.
  • Experience migrating Oracle ADW/OAC to Snowflake and Tableau Cloud.
  • Strong SQL, data modeling, and performance optimization skills.
  • Experience with GitHub CI/CD pipelines and Pytest for automated testing.

Responsibilities

  • Analyze and rationalize existing OAC, Power BI, and legacy Tableau reports.
  • Migrate and rebuild dashboards using Tableau Cloud with live Snowflake connections.
  • Work with Snowflake data, SQL, data modeling, and performance tuning.
  • Leverage AWS services and integrate AWS data environments with Snowflake.
  • Utilize certified semantic layers to maintain consistent metrics and reporting standards.
  • Perform data validation and reconciliation between legacy reports and new Tableau dashboards.
  • Support Oracle ADW to Snowflake migration and enterprise BI modernization.
  • Implement dashboard design standards and optimize reporting performance.
  • Collaborate with Business, Data Engineering, and Architecture teams.

Skills

Snowflake
AWS
Tableau Cloud
BI Migration
Semantic Layer
GitHub CI/CD
Cortex AI

Job description

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

Job Description

Location: Chicago, IL

Work Mode: 4 Days a week onsite

Job Summary:

We are looking for a Senior BI Lead / Architect with 10+ years of experience in Business Intelligence, Snowflake, AWS, and enterprise BI modernization. The role involves migrating the existing Oracle ADW and Oracle Analytics Cloud (OAC) environment to Snowflake and Tableau Cloud. The candidate should have strong hands-on expertise in Snowflake data platforms, AWS cloud services, Tableau Cloud, and BI migration.

Key Responsibilities:

  • Analyze and rationalize existing OAC, Power BI, and legacy Tableau reports.
  • Migrate and rebuild dashboards using Tableau Cloud with live Snowflake connections.
  • Work extensively with Snowflake data, SQL, data modeling, and performance optimization.
  • Leverage AWS cloud services and integrate AWS data environments with Snowflake.
  • Utilize certified semantic layers to maintain consistent business metrics and reporting standards.
  • Perform data validation and reconciliation between legacy reports and new Tableau dashboards.
  • Support Oracle ADW to Snowflake migration and enterprise BI modernization.
  • Implement dashboard design standards and optimize reporting performance.
  • Manage BI deployment automation using GitHub CI/CD and automated testing with Pytest.
  • Collaborate with Business, Data Engineering, and Architecture teams.
  • Required Skills
  • Snowflake: Strong hands-on experience in Snowflake architecture, SQL, data modeling, data integration, and performance tuning.
  • AWS: Strong experience with AWS cloud services, data architecture, storage, and data pipelines.
  • Tableau Cloud: Expertise in dashboard development, deployment, optimization, and live Snowflake connectivity.
  • BI Migration: Experience migrating OAC, Power BI, and legacy Tableau reports to Tableau Cloud.
  • Oracle Data Platform: Understanding of Oracle ADW and Oracle-to-Snowflake migration.
  • Semantic Layer: Experience with certified semantic layers, business metrics, and data validation.
  • DevOps & Automation: GitHub, CI/CD pipelines, and Pytest.
  • Snowflake Cortex AI: Working knowledge preferred.

Preferred Domain Experience:

  • Experience in Warehouse Management Systems (WMS) or Logistics.
  • Understanding of warehouse operations, supply chain analytics, and operational KPIs.
  • Key Mandatory Skills: Snowflake Data Platform | AWS | Snowflake SQL | Tableau Cloud | BI Migration | Semantic Layer | GitHub CI/CD
Additional Information

All your information will be kept confidential according to EEO guidelines.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior BI Architect - Snowflake & Tableau Cloud Migration
Senior BI Architect - Snowflake & Tableau Cloud Migration

Derex Technologies Inc • Chicago (IL)

On-site
USD 130,000 - 180,000
Database Developer/Architect with Snowflake
Database Developer/Architect with Snowflake

RZS Recruitment • New York (NY)

Hybrid
USD 110,000 - 120,000
Sr. Snowflake Data Engineer
Sr. Snowflake Data Engineer

BravoTECH • Plano (TX)

On-site
USD 120,000 - 150,000
Data Analyst
Data Analyst

EPAM Systems • United States

Remote
USD 70,000 - 100,000
Data Solutions Lead
Data Solutions Lead

Adactin Software • United States

Remote
USD 140,000 - 210,000
Senior Snowflake Architect: Lead Data Solutions
Senior Snowflake Architect: Lead Data Solutions

Compunnel Inc. • Alpharetta (GA)

Hybrid
USD 180,000 - 240,000
Senior Data Engineer & Oracle DBA for Enterprise Data
Senior Data Engineer & Oracle DBA for Enterprise Data

Compunnel Inc. • Merrimack (NH)

On-site
USD 120,000 - 180,000
Senior Data Analyst – Enterprise Data & Analytics
Senior Data Analyst – Enterprise Data & Analytics

ASB Resources • New York (NY)

On-site
USD 110,000 - 150,000
Senior Data Engineer
Senior Data Engineer

Eliassen Group • United States

Remote
USD 101,000 - 162,000
Senior Snowflake Developer
Senior Snowflake Developer

TekDallas • Boston (MA)

Hybrid
USD 130,000 - 185,000