Senior BI Lead / Architect
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. 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.
- KeyMandatory 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.
Job details
- Published
- November 12, 2026
- Last checked
- November 17, 2026
- Experience
- Senior
- Job source
- smartrecruiters
- Workplace
- On-site · Chicago, US
- First seen
- November 12, 2026
LiftmyCV exclusive data
Derex Technologies Inc hiring intelligence
Derex Technologies Inc currently has 15 active jobs tracked by LiftmyCV. 3 new jobs in the past 7 days.
Verified November 17, 2026
Active openings
15
Currently tracked by LiftmyCV
New in 7 days
3
12 new jobs in the past 30 days
Published salaries
—
Not published by this employer yet
Average opening age
18 days
Across 15 active openings
Workplace breakdown
Hiring countries
Top hiring cities
Most in-demand roles
- • AI Architect
- • AI Solutions Architect
- • Bench Sales Recruiter - USA
- • Business Systems Analyst / Data Analyst
- • DataOps Lead – P&C Domain
- • Guidewire ClaimCenter Lead
Frequently requested skills
As of November 17, 2026
Hiring insights calculated from active jobs tracked by LiftmyCV.
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inVisa sponsorship insights
Sponsorship not specified for this role
This job posting does not state whether visa sponsorship is available.
Employer H-1B filing history
DEREX TECHNOLOGIES INC.
3
certified
FY 2026
latest data
Based on U.S. Department of Labor LCA disclosure data. LCA certification is not the same as visa petition approval, and historical activity does not guarantee sponsorship for this role.
More at Derex Technologies Inc
Similar jobs from this company
- Informatica Architect with HealthcareDerex Technologies IncAlbany, USOn-site
- Data ArchitectDerex Technologies IncHartford, USOn-site
- AWS Data Architect with P&C DomainDerex Technologies IncErie, USOn-site
- Solution Architect with InsureMo PlatformDerex Technologies IncJersey City, USOn-site
- UI/UX ArchitectDerex Technologies IncWashington, USHybrid
- AI ArchitectDerex Technologies IncToronto, CAOn-site
Across the market
Similar jobs from other companies
- Architect / Senior ArchitectJTC JTC CorporationJTC SummitOn-site
- Architect/Lead ArchitectFractal Analytics Ltd.BengaluruOn-site
- Architect, IT- Data ArchitectBAXTER INOV & BUS SOL PRVT LTDBangalore, KarnatakaOn-site
- Application Architect, IT - ArchitectsAscensus LLCDresher, USOn-site
- ArchitectPSI CRODurham, USOn-site
- ArchitectStride TreglownWinchester, GBOn-site
Related job searches
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.