Derex Technologies Inc Logo

Derex Technologies Inc

Senior BI Lead / Architect

Posted 4 Days Ago
Be an Early Applicant
In-Office
Chicago, IL, USA
Senior level
In-Office
Chicago, IL, USA
Senior level
Lead enterprise BI modernization by migrating Oracle ADW, OAC, Power BI, and legacy Tableau reports to Snowflake and Tableau Cloud. Build optimized dashboards with live Snowflake connections, develop semantic layers, validate data, and improve reporting performance. Integrate AWS data environments, support Oracle-to-Snowflake migration, manage GitHub CI/CD deployment automation, implement Pytest testing, and collaborate with business, data engineering, and architecture teams.
The summary above was generated by AI
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.

Similar Jobs

An Hour Ago
Hybrid
113K-183K Annually
Senior level
113K-183K Annually
Senior level
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Develop, integrate, and validate autonomous mining truck systems in virtual mine, scalability lab, and Software-in-the-Loop environments. Perform system integration and validation testing for functionality, safety, reliability, and performance. Troubleshoot software and system-level issues, analyze simulation and field data, investigate root causes, and improve autonomy capabilities including perception, positioning, path planning, and machine control. Collaborate with software, systems, and test engineering teams to translate requirements into testable solutions.
Top Skills: Autonomous Vehicle SystemsLinuxMachine Control SystemsMachine PerceptionPath PlanningPositioning SystemsRoboticsSimulation-Based TestingSoftware-In-The-Loop (Sil)
2 Hours Ago
Remote or Hybrid
Hoffman Estates, IL, USA
46K-84K Annually
Senior level
46K-84K Annually
Senior level
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Investigates and processes commercial insurance claims, determines coverage, establishes reserves, assesses damages, negotiates settlements, prepares estimates, maintains claim documentation, and identifies potential fraud or subrogation opportunities. The role requires regular communication with insureds, claimants, agents, and internal teams while ensuring compliance with policy terms, legal requirements, and company guidelines.
9 Hours Ago
Remote or Hybrid
Riverwoods, IL, USA
138K-158K Annually
Senior level
138K-158K Annually
Senior level
Fintech • Machine Learning • Payments • Software • Financial Services
Manages strategically important global partners and provides operational business support across onboarding, training, customer issue resolution, and internal systems. Leads complex, cross-functional process improvement initiatives, product and solution implementations, and strategic projects. Analyzes metrics to drive improvements, documents requirements, mitigates process and system gaps, and collaborates with technical teams and stakeholders. Coaches peers and mentors junior account executives while facilitating training.
Top Skills: Authorization And Settlement Applications

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account