Senior BI Lead / Architect

Derex Technologies Inc

  • Chicago, IL
  • On-site
  • Senior level
  • 10+ yrs experience
  • Business Intelligence / Data Analytics
  • Visa: not specified

The role in 30 seconds

This role leads the migration of an existing Oracle ADW and Oracle Analytics Cloud environment to Snowflake and Tableau Cloud for Derex Technologies Inc's client. The Senior BI Lead/Architect rationalizes legacy reports, rebuilds dashboards with live Snowflake connections, and establishes certified semantic layers and reporting standards. The position requires deep hands-on expertise across Snowflake, AWS, Tableau Cloud, and enterprise BI migration, with DevOps automation via GitHub CI/CD and Pytest.

Is this role a fit for you?

The backgrounds this role is most likely to hire from, as RoleStack reads the posting.

Strong match

  • Data platform / ML pipeline
  • B2B enterprise platform / workflow software
  • Enterprise-scale
  • Growth-stage

Workable stretch

  • B2B infrastructure / API / developer tools
  • Internal tooling / back-office systems
  • Regulated environment

Harder transition

  • B2C consumer-facing application
  • Embedded systems / hardware-adjacent
  • Startup / greenfield

Industry: Horizontal agnostic (BI/analytics), with preferred supply chain/logistics exposure. See your personal match score

What they're really screening for

Must-haves

  • CORE 10+ years of experience in Business Intelligence
  • CORE Strong hands-on experience in Snowflake architecture, SQL, data modeling, data integration, and performance tuning
  • CORE Strong experience with AWS cloud services, data architecture, storage, and data pipelines
  • CORE Expertise in Tableau Cloud dashboard development, deployment, optimization, and live Snowflake connectivity
  • CORE Experience migrating OAC, Power BI, and legacy Tableau reports to Tableau Cloud
  • PLUS Understanding of Oracle ADW and Oracle-to-Snowflake migration
  • PLUS Experience with certified semantic layers, business metrics, and data validation
  • PLUS DevOps & Automation: GitHub, CI/CD pipelines, and Pytest
  • CORE Strong SQL skills
  • PLUS Data modeling and performance optimization

Nice-to-haves

  • PLUS Working knowledge of Snowflake Cortex AI
  • PLUS Experience in Warehouse Management Systems (WMS) or Logistics
  • PLUS Understanding of warehouse operations, supply chain analytics, and operational KPIs

Résumé keywords for this role

Terms the posting stresses. Include the ones you can honestly back up.

Tools & technologies

  • Snowflake
  • Snowflake Cortex AI
  • Snowflake SQL
  • AWS
  • Tableau Cloud
  • Tableau
  • Oracle ADW
  • Oracle Analytics Cloud (OAC)
  • Power BI
  • GitHub
  • CI/CD
  • Pytest
  • SQL

Concepts & phrases

  • Senior BI Lead / Architect
  • enterprise BI modernization
  • Snowflake data platform
  • Tableau Cloud
  • live Snowflake connections
  • BI migration
  • certified semantic layers
  • business metrics
  • data validation and reconciliation
  • dashboard design standards
  • reporting performance
  • GitHub CI/CD
  • Oracle ADW
  • Oracle Analytics Cloud
  • Warehouse Management Systems

Words that count as the same thing: "OAC" ≈ Oracle Analytics Cloud · "Oracle ADW" ≈ Oracle Autonomous Data Warehouse, Oracle Autonomous Data Warehouse Cloud · "BI Migration" ≈ Business Intelligence Migration, BI platform migration, report migration · "Semantic Layer" ≈ certified semantic layer, metrics layer, business metrics layer · "CI/CD" ≈ continuous integration/continuous deployment, deployment automation

Check my résumé against these keywords

Hiring at Derex Technologies Inc

Open senior roles RoleStack tracks right now, posted in the last 30 days.

More open roles at Derex Technologies Inc

Full job description from Derex Technologies Inc

From Derex Technologies Inc's posting. View the original

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.

Show full description Show less

Position: Senior BI Lead / Architect

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

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

FAQ

How much experience do you need?

The posting asks for 10+ years in business intelligence. It is a senior-level role.

Does Derex Technologies Inc sponsor visas for this role?

The posting does not say whether visa sponsorship is available. Ask the recruiter before you apply.

Is this role remote?

It is an on-site role.

What tools and technologies does the posting mention?

Snowflake, Snowflake Cortex AI, Snowflake SQL, AWS, Tableau Cloud, Tableau, Oracle ADW, Oracle Analytics Cloud (OAC), Power BI, GitHub, CI/CD, Pytest, SQL.