Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior BI Lead / Architect

Derex Technologies

Job Description

Job Description

Company 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

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.

Vacancy posted 10 days ago
Similar jobs that could be interesting for youBased on the Senior BI Lead / Architect in Chicago, IL vacancy
  •  ...Senior Lead Architect If you are excited about shaping the future of technology and driving significant business impact in financial services, we are looking for people just like you. Join our team and help us develop game-changing, high-quality solutions. As a Senior... 
    Senior
    For contractors

    Chase

    Chicago, IL
    5 days ago
  • $124.42k - $201.85k

    Lead Pre-Sales Solutioner - Senior Portfolio Architect Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world... 
    Senior
    Full time
    Local area
    Remote work

    Capgemini

    Chicago, IL
    3 days ago
  • $142k - $214k

     ...Bitmoji, Saturn, and other digital services.We’re looking for a Senior Lead, Ad Partnerships to join Team Snapchat! The Ad Partnerships...  ...integration issues while serving as an internal advocateWork towards bi-annual OKRs such as advertiser adoption, partner-enabled... 
    Senior
    Business intelligence
    Full time
    Live in
    Work at office
    Local area
    Shift work

    Snap

    Chicago, IL
    2 days ago
  • Energy Jobline ZR is seeking a Healthcare MDM Architect to design master data management and governance for a major healthcare client. You...  ...day one, requires Hands-on Prophecy expertise, and involves leading architecture workshops, defining roadmaps, and mentoring delivery... 
    Senior

    Energy Jobline ZR

    Chicago, IL
    1 day ago
  • Company DescriptionSystem Canada resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds...
    Senior

    System Canada Technologies

    Chicago, IL
    3 days ago
  • $150k

     ...perspectives to spark change. BCG delivers solutions through leading-edge management consulting along with technology and design...  ...at the intersection of people and technology. As a Senior AI Tech Architect, you will collaborate on interdisciplinary teams of designers... 
    Senior
    Contract work
    Work at office
    Local area

    The Boston Consulting Group

    Chicago, IL
    4 days ago
  • $160k - $175k

     ...Senior Business Architect We're building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are...  ...solutions to business imperatives. You identify and lead efforts to advance and maintain vision and direction for the... 
    Senior
    Business intelligence
    Remote work
    Flexible hours
    2 days per week

    Cibc

    Chicago, IL
    1 day ago
  • $124k - $280k

     ...SectorNot ApplicableSpecialismOracleManagement LevelSenior ManagerJob Description & SummaryThe OpportunityAs a Senior Manager, Oracle HCM Cloud Functional Lead, you will guide client organizations through Oracle HCM Cloud implementations and enhancements within our... 
    Senior
    Business intelligence
    Full time
    H1b

    PwC

    Chicago, IL
    22 hours ago
  •  ...Accenture helps the world's leading enterprises reinvent by building their digital core and unleashing the power of AI to create value at speed for organizations across industries. Our strategy is to be the reinvention partner of choice for our clients and lead in the... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Chicago, IL
    3 days ago
  •  ...Position Overview: WinCenter team supports global sales professionals in driving growth across all Zones offerings. The Lead Architect will lead RFx efforts for all professional and managed services offerings (Workplace, Network, Cloud & Data Center, Security, end... 
    Contract work
    Remote work

    Zones

    Chicago, IL
    3 days ago
  • $82.7k - $120k

     ...support.This role reports directly to the Senior Manager of the Enterprise Applications and...  ...evaluations, performance improvement plans, bi-weekly 1:1s, performance reviews,...  ...Remedy/ITSM and Salesforce applications while leading or supporting process improvement initiatives... 
    Senior
    Business intelligence
    Full time
    Temporary work
    Work experience placement
    Work at office
    Flexible hours
    Shift work
    2 days per week

    TransUnion

    Chicago, IL
    5 days ago
  • $89.29k - $133.93k

     ...$89,287.00-$133,931.00Senior Architect Metra is transforming how the...  ...moves—and we're looking for a Senior Architect to help shape that future...  ...this high-impact role, you'll lead the design and delivery of...  ..., Adobe Creative Suite, Power BI, 3D modeling software, and GIS... 
    Senior
    Contract work
    For contractors
    Local area

    Metra Commuter Rail

    Chicago, IL
    3 days ago
  • $110k - $160k

     ...steward precious resources by finding more sustainable solutions. Job Summary TYLin is seeking a highly skilled and motivated Senior Architect to lead the planning and design of transit facilities across the Chicago region and broader Midwest. This role offers the... 
    Senior
    Full time
    Local area

    Landrum & Brown

    Chicago, IL
    1 day ago
  • $84.7k - $144.43k

     ...interest, you’re in the right place. We have an opening for a Senior Architect . This role could be based in the following cities:...  ...between!) DLR Group responds with solutions that are at the leading edge of the hospitality industry with designs that evoke emotion... 
    Senior
    Work at office
    Local area

    DLR Group

    Chicago, IL
    3 days ago
  • $160k - $205k

     ...We are looking for an enthusiastic Senior GenAI and LLM Architect to add to Credera’s Data capability group...  ...Our ideal candidate is excited about leading project-based teams in a client‑facing...  ...tools (RShiny, R, Python, Tableau, Power BI, D3.js, etc.) ~ Passion for leading... 
    Senior
    H1b
    Remote work
    Worldwide
    Flexible hours
    2 days per week

    Credera

    Chicago, IL
    3 days ago
  • $150k - $180k

     ...Microsoft cloud technology. The ideal candidates will have experience leading projects in a customer-facing consulting role and proven...  ...architecture reviews, governance boards, and design discussions with senior client stakeholders.Occasional escalation support for managed... 
    Senior
    Remote work
    Flexible hours

    Hitachi Solutions America

    Chicago, IL
    3 days ago
  • $60 - $80 per hour

     ...Associates Trotter and Associates, Inc. is seeking an experienced Architect to join our multidisciplinary team and help expand...  ...to: Serve as Architect of Record for assigned projects. Lead architectural work from programming and conceptual design through... 
    Senior
    Hourly pay
    Temporary work
    Work at office
    Work from home

    Trotter and Associates, Inc.

    Chicago, IL
    3 days ago
  •  ...Job Description Job Description Job Role: ServiceNow Principal Architect / Lead ITOM & HRSD Location: Remote Duration: Initially 6 Months Lead end-to-end ServiceNow support or implementations for ITOM and HRSD. Translate business requirements into scalable... 
    Remote work

    eTeam Inc.

    Chicago, IL
    26 days ago
  • $78k - $95k

     ...and processes to our work. Position Responsibilities Actively leads a project or distinct portions of a project with periodic supervision...  ...or equivalent knowledge, skills and abilities. Licensed Architect; LEED accreditation preferred. Strong verbal and written communication... 
    Senior
    Full time
    Contract work
    Work at office
    Flexible hours

    Skidmore, Owings and Merrill

    Chicago, IL
    3 days ago
  •  ...DescriptionJob DescriptionSenior Project Architect - Mission CriticalJob DescriptionThis position...  ...The Mission Critical sector is seeking a senior level architect to join a well-...  ...apply. Selected candidates are expected to lead and engage with a diverse project team that... 
    Senior
    Work at office
    Local area
    Remote work

    Harley Ellis Devereaux

    Chicago, IL
    5 days ago
  • $125k - $160k

     ...GFT is seeking a talented Senior Architect to grow our team in Chicago . This role follows a hybrid work model, requiring regular attendance...  ...In the capacity, you will be responsible for the following: Leading interdisciplinary collaboration with engineering, construction... 
    Senior
    Full time
    For contractors
    Work at office
    Remote work

    Gannett Fleming

    Chicago, IL
    3 days ago
  • $95k - $150k

     ...Senior Project Architect At EXP, we're driven to provide innovative solutions for the world's built and natural environments. As a team of engineers...  ...mentoring within the Firm. Your responsibilities include: Lead and coordinate the technical development of projects working... 
    Senior
    Full time
    Work at office

    EXP

    Chicago, IL
    2 days ago
  •  ...Senior Project Architect At NewGround, we believe the right environment can change how people work, connect, and succeed. As a leading design and delivery firm, we partner with financial institutions, healthcare providers, and corporations to turn vision into reality... 
    Senior
    Contract work
    Work at office
    Local area

    New Ground

    Chicago, IL
    2 days ago
  • $125k - $140k

     ...Marine Corps) missions, along with other US federal agencies, all over the world. We are looking for a licensed professional Architect to lead the design and construction oversight for the Jesse Brown VA Medical Center (VAMC), Chicago, IL Electronic Health Record... 
    Senior
    Full time
    Contract work
    Temporary work
    Worldwide

    Planate Management Group

    Chicago, IL
    2 days ago
  •  ...Ernst & Young Oman is seeking an Assistant Director for Commercialization Architect to drive successful product monetization strategies and support continuous improvement across various services. This role involves collaboration with teams to ensure aligned pricing models... 
    Senior
    Flexible hours

    EY

    Chicago, IL
    3 days ago
  •  ...TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.No OPT-EAD / H1-B Consultants please.Please mention your Visa Status in your emailor resume.SummaryType: Full-timeFunction: Information TechnologyExperience level: Mid-Senior LevelIndustry: Information Technology And Services
    Full time
    Immediate start

    Sonsoft

    Chicago, IL
    2 days ago
  • THE GLOBAL LEADER IN DATA & ANALYTICS RECRUITMENTHarnham Search and Selection Company Number: 05723485Harnham Search and Selection is a registered company in England and Wales. Reg no. 05723485Harnham Europe Limited Company Number: 09956940Harnham GmbH HRB: 196954Harnham...
    Work at office

    Harnham

    Chicago, IL
    2 days ago
  • $160k - $185k

    Job DescriptionLead Integration Architect, Finance Systems AutomationAbout AcrisureA global fintech leader, Acrisure empowers millions of...  ...levels possible.Job Summary:Our Workday Integration Architect leads the design, development, and deployment of Workday integrations... 
    Full time
    Immediate start
    Remote work
    Flexible hours

    Acrisure

    Chicago, IL
    4 days ago
  •  ...capabilities to provide even greater opportunities for our clients to differentiate and scale business growth.You Are:The Integration Lead Architect playing a pivotal role in ensuring that diverse software applications within an organization work seamlessly together.This... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Chicago, IL
    2 days ago
  •  ...and ITLocation: Chicago, ILContract: ContractPosted: 2026-10-08Deadline: 0001-01-01Our client, a leading organization in the technology sector, is seeking a Lead QA Architect to join their team. As a Lead QA Architect, you will be part of the Quality Assurance department... 
    Temporary work
    Flexible hours

    Experis

    Chicago, IL
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior BI Lead / Architect. Be the first to apply!