Senior BI Lead / Architect
- Location
- Chicago, IL
- Job type
- Full-time
- Level
- Executive
- Experience
- 10+ years
- Listed
- Today
Skills & highlights for this role
- Snowflake
- AWS
- Tableau Cloud
- BI migration
- semantic layer design
Also useful
- Oracle Analytics Cloud
- Snowflake Cortex AI
- GitHub CI/CD
- Pytest
How well does your resume fit this job?
Upload your resume to see your score for this Derex Technologies Inc. role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
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
Additional Information
All your information will be kept confidential according to EEO guidelines.
About the Company
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.
From Derex Technologies Inc.'s careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Senior BI Lead / Architect role at Derex Technologies Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Common questions
Where is the Senior BI Lead / Architect job at Derex Technologies Inc. located?
This Senior BI Lead / Architect position at Derex Technologies Inc. is located in Chicago, IL. Always check Derex Technologies Inc.'s application page for specific state eligibility or relocation policies.
What qualifications are required for Senior BI Lead / Architect at Derex Technologies Inc.?
For the Senior BI Lead / Architect role, Derex Technologies Inc. highlights 10+ years of relevant experience; experience with Snowflake, AWS, Tableau Cloud, BI migration, semantic layer design. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Senior BI Lead / Architect position at Derex Technologies Inc.?
This listing links directly to Derex Technologies Inc.'s SmartRecruiters application page. You can apply directly on Derex Technologies Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.