BI Developer in Burr Ridge, Illinois at A-Rent Test Equipment, LLC

BI Developer (Databricks / SQL / AI Enablement)

Company Overview:

A-Rent Test Equipment is a fast-growing company dedicated to supporting the reliability of the electrical grid. We specialize in renting a multimillion-dollar fleet of cutting-edge electrical test equipment to clients nationwide, enabling the testing and maintenance of critical infrastructure like switchgear, transformers, and cables. Our market-leading customer service ensures we are the first call for our clients’ test equipment needs. By supporting the maintenance and modernization of the nation’s aging electrical infrastructure, we play a vital role in ensuring grid reliability and sustainability.

We also serve fast-growing industries like datacenters and solar energy, contributing to the technologies of the future. As we position our business for significant growth, we are committed to leveraging innovation and operational excellence to maintain our reputation as an industry leader.

About Our Role:?

We are seeking a specialized Data Engineering & Business Intelligence developer to accelerate the scalability, reliability, and strategic value of our data platform. This role is critical to standardizing data pipelines, improving reporting accuracy, and enabling faster, data-driven decision-making across the business.

The BI Developer will report directly to the Director of Systems and Business Intelligence. This role is full-time and hybrid, based in our Burr Ridge, Illinois office with additional travel to our satellite locations in Phoenix, Houston and Virginia.

What You Will Do:?

1. AI Knowledge Base & Application Infrastructure
   • Expand existing vectorized email knowledge base to create a broad context for AI Tools with a variety of applicable inputs (Outlook, Teams, LinkedIn, SharePoint, Databricks etc.)
   • Enable internal AI tools (custom GPTs, Claude, etc.) to accelerate processes across finance, operations, logistics & marketing
   • Build Databricks Apps to for internal and external facing tools to streamline a variety of business processes. (prepopulated quotes, customer info scraping, shipper tracking number statuses, etc)
   • Establish data governance, access controls, and indexing strategies to support AI-ready data and retrieval. Streamline permissions processes for tools & users
2. Data Platform & Pipeline Optimization
   • Consolidate fragmented data pipelines into a modular, reusable pipeline framework. Develop and optimize materialized views and job orchestration for performance and maintainability
   • Create discrepancy reporting and audit mechanisms to improve financial accuracy
   • Build reliable CSV ingestion pipelines and standardized ingestion patterns
   • Resolve data model issues (e.g., circular references in customer dimensions) to improve data consistency
3. Business Intelligence & KPI Automation
   • Develop and maintain executive-level Power BI dashboards
   • Automate leadership KPIs to eliminate manual reporting and improve decision speed
   • Develop a Shipping Optimization dashboard using inventory snapshots and order frequency
   • Establish which types of reporting can be replaced using AI tools with refined context.
4. AI-Accelerated Development & Best Practices
   • Leverage modern AI tools to accelerate development such as code generation, query optimization, and documentation
   • Implement best practices for AI-assisted engineering, including prompt engineering, reusable development patterns, and automation of repetitive data and reporting tasks
   • Identify and implement opportunities to embed AI into business processes to improve efficiency and reduce manual effort
5. Perform additional duties as assigned

Qualifications:

• Around 2 years of proven experience building Power BI dashboards and data models
• Strong expertise in Databricks (Apps, Jobs, Workflows, Delta Sharing)
• Working knowledge of LLMs (e.g., Chat GBT, Claude) and their practical applications
• Advanced SQL and data modeling experience
• Experience with data pipeline design, ingestion, and orchestration
• Familiarity with data quality, governance, and performance optimization?
• Must be authorized to work in the U.S. without sponsorship.

Hours

• Full-time, Permanent, No less than 40 hours per week

What We Offer:

• PTO and Paid Holidays
• Generous medical, dental, vision, and 401(k) offerings
• A team that cares about you and invests in growth