Business Intelligence Analyst Intern Jobs in Romeoville, IL

Description
Smithbucklin, a 650-person, employee-owned professional services company with more than 70 years of success serving the association market, with primary offices in Chicago and Washington, D.C., is looking for a Business Intelligence Analyst to join our team in our Chicago office and serve our association management client organization, the International Society of Transport Aircraft Trading (ISTAT).
The International Society of Transport Aircraft Trading (ISTAT) is the leading global association serving the global aviation trading and finance industry. With more than 6,000 members worldwide, ISTAT connects professionals through conferences, networking, education, and thought leadership while advancing the long-term success of the aviation industry.
ISTAT is seeking a curious, analytical, and collaborative Business Intelligence Analyst to help transform organizational data into meaningful business intelligence that supports better decision-making across the organization.
Reporting to the Executive Director, the Business Intelligence Analyst will collect, organize, analyze, and visualize data from multiple business systems to develop interactive dashboards, reports, and analytical tools that support membership, conferences, sponsorship, education, and executive reporting. Working closely with the Executive Director and colleagues across the organization, the Analyst will help turn business questions into intuitive dashboards and actionable insights while continuously improving data quality, reporting processes, and organizational intelligence.
This position is ideal for someone who enjoys solving problems, building interactive dashboards, learning new technologies, leveraging AI to improve productivity, and continuously finding better ways to organize and present information. The successful candidate is naturally curious, enjoys learning independently, and is comfortable researching new tools and techniques to solve business challenges.
At Smithbucklin, we embody a culture driven by optimism, ambition, expertise, and thoughtfulness, where every team member is empowered to exceed expectations and deliver exceptional results for our clients. Join us in shaping the future of association management, where our values serve as the cornerstone of our success.
What You Will Do
Business Intelligence & Dashboard Development

• Develop and maintain interactive dashboards and reports using Microsoft Power BI, AI, and other tools.
• Design dashboards that support membership, conferences, sponsorship, education, and executive reporting.
• Continuously improve dashboards to make information more accessible, interactive, and useful for decision-making.
• Work closely with the Executive Director and staff to translate business questions into meaningful reports and visualizations.
• Produce recurring and ad hoc reports for staff, volunteer committees, senior leadership, and the Board of Directors.

Data Management & Reporting

• Collect, organize, validate, and maintain data from multiple organizational systems.
• Help improve data quality by identifying duplicate, incomplete, or inconsistent information.
• Develop reporting standards that promote consistency and accuracy across the organization.
• Serve as ISTAT's primary resource for organizational reporting and data quality.
• Partner with the Information Technology team to support reporting requirements, data integrations, and ongoing data improvement initiatives.

Cross-Functional Collaboration

• Partner with colleagues across Membership, Conferences, Sponsorship, Education, Marketing, Finance, and other functional areas to understand reporting needs and develop practical solutions.
• Support volunteer committees by developing dashboards and reports that facilitate informed discussions and decision-making.
• Provide guidance to colleagues on available dashboards, reporting capabilities, and data visualization tools.

Innovation & Continuous Improvement

• Continuously evaluate reporting processes and recommend opportunities to improve efficiency, automation, and usability.
• Leverage AI-enabled tools and emerging technologies to improve productivity, accelerate analysis, and develop innovative reporting solutions.
• Independently research technical challenges, identify practical solutions, and continuously expand technical knowledge.
• Stay informed about new capabilities in Microsoft Power BI, AI-enabled analytics, and business intelligence technologies.

Basic Qualifications

• Bachelor's degree in Business Analytics, Information Systems, Data Analytics, Statistics, Business Administration, Computer Science, or a related field, or equivalent professional experience.
• Three or more years of experience in business intelligence, data analytics, reporting, or a related analytical role.
• Experience developing interactive dashboards using Microsoft Power BI.
• Advanced Microsoft Excel skills, including working with large datasets.
• Strong analytical, organizational, and problem-solving skills with exceptional attention to detail.
• Excellent written and verbal communication skills with the ability to present information clearly to both technical and non-technical audiences.
• Demonstrated ability to manage multiple priorities while delivering accurate, timely, and high-quality work.
• Demonstrated curiosity, initiative, and the ability to independently research technical challenges, learn new technologies, and develop practical solutions.
• Enthusiasm for leveraging AI-enabled tools to improve productivity, reporting, and business intelligence.

Preferred Qualifications

• Familiarity with Power Query, DAX, or similar data transformation and reporting tools.
• Experience creating interactive reports and visualizations that communicate complex information in a clear and intuitive manner.
• Experience working with multiple business systems and integrating data from different sources into centralized dashboards

Where Do You Fit?
Whether you are just beginning your career or are a mid- or senior-level professional, working at Smithbucklin will offer you countless opportunities to develop transferable skills, acquire meaningful knowledge and gain rich experiences at an accelerated pace. By working collaboratively with smart, ambitious, multi-talented, genuine and hardworking colleagues, you will build meaningful, deep and enduring relationships that will serve you well throughout your career, regardless of your chosen path. In addition, as a 100 percent employee-owned company, Smithbucklin offers all of our people - regardless of position or compensation - an equal chance to experience the fulfillment and reap the benefits of ownership. As owners, our employees control the destiny of Smithbucklin and are unified in the goal of building a great, enduring company.
Smithbucklin is a hybrid work environment with in-office days established as Monday, Tuesday, and Thursday. Employees will work a standard 40-hour week, with the possibility of additional hours based on project deadlines.
Smithbucklin considers several factors when determining compensation, including a candidate's recent coursework, training, experience, and certifications, among other considerations. The expected pay for this role is $59,000-63,000.
Equal Employment OpportunityAt Smithbucklin, Equal Employment Opportunity is our commitment and goal. All qualified candidates will receive consideration for employment without regard to race, national origin, gender, age, religion, disability, sexual orientation, veteran status, marital status or any other protected status designated by federal, state or local law. Applicants are encouraged to confidentially self-identify when applying. Employment is contingent upon successful completion of a reference and background investigation based on position.
Smithbucklin will not sponsor applicants for work visas and as a precondition of employment. You must be authorized to work in the United States permanently.