jobapplier

Senior BI Lead / Architect

Derex Technologies Inc

Skills

Required

  • BI
  • Snowflake architecture
  • SQL
  • data modeling
  • data integration
  • performance tuning
  • AWS
  • cloud services
  • data architecture
  • storage
  • data pipelines
  • dashboard development
  • deployment
  • optimization
  • GitHub

Preferred

  • CI/CD pipelines
  • Pytest
  • Warehouse Management Systems
  • WMS
  • Logistics
  • warehouse operations
  • supply chain analytics
  • Snowflake connections
  • performance optimization

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.

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.
  • BI deployment automation using GitHub CI/CD and automated testing with Pytest.
  • Collaborate with Business, Data Engineering, and Architecture teams.

Requirements

  • Strong hands-on experience in Snowflake architecture, SQL, data modeling, data integration, and performance tuning.
  • Strong experience with AWS cloud services, data architecture, storage, and data pipelines.
  • Expertise in dashboard development, deployment, optimization, and live Snowflake connectivity.
  • Experience migrating OAC, Power BI, and legacy Tableau reports to Tableau Cloud.
  • Understanding of Oracle ADW and Oracle-to-Snowflake migration.
  • Experience with certified semantic layers, business metrics, and data validation.
  • Snowflake Data Platform | AWS | Snowflake SQL | Tableau Cloud | BI Migration | Semantic Layer | GitHub CI/CD
  • 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.

Preferred

  • GitHub, CI/CD pipelines, and Pytest.
  • Working knowledge preferred.
  • Experience in Warehouse Management Systems (WMS) or Logistics.
  • Understanding of warehouse operations, supply chain analytics, and operational KPIs.

Position

Senior BI Lead / Architect Location : Chicago, IL Work Mode: 4 Days a week onsite

  • All your information will be kept confidential according to EEO guidelines.
  • Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services.