Data Analyst Intern

Colliers Engineering & Design is seeking an Intern to join our Data Analytics Development team for Summer 2026. The candidate will be involved with transforming raw data into organized and valuable reports that gather meaningful business insights.

Colliers Engineering & Design, an affiliate of Colliers, is a trusted provider of multi-discipline engineering, design and consulting services to public and private sector clients. Headquartered in Holmdel, New Jersey with over 80 offices throughout the United States, we specialize in providing a comprehensive suite of services including: civil/site, transportation, MEP (mechanical, electrical & plumbing) engineering, architecture, geospatial/survey, infrastructure, governmental, geotechnical/environmental, telecommunications and utilities engineering. We employ over 3,000 talented professionals who utilize the most advanced technologies to deliver customized solutions for our clients.

• Work with our Data Analytics/Power BI developers in the Software Development Department.
• Perform tasks on Power BI desktop and service (Basic to Advance) like managing ETL (Extract Transform and Load) workflow, model relationships, and creating visuals.
• Perform modeling tasks independently using advance Power Query steps, DAX formulas, Measures etc.
• Keep track of various reports, dashboards, and targets.
• Connecting various data sources to Power BI and Fabric (SQL based BST, Files, SharePoint, Azure, or such databases).
• Analytical thinking for translating data into meaningful statistics & information.
• Developing and implementing data analyses, data collection systems, and other strategies that optimize statistical efficiency and quality of data.
• Acquiring data from primary or secondary data sources and partnering with a data warehouse team to maintain databases.
• Filtering and cleaning data to ensure accuracy.
• Creating visualizations and reports for internal and external stakeholders.
• Developing dashboards and other tools to help stakeholders understand key metrics.
• Documenting requirements for reports and data visualizations.
• Microsoft Fabric tasks, including reviewing pipelines, monitoring refreshes, documenting and cataloging workspaces and assisting with basic dataset or model updates.
• Supporting ad hoc analysis requests.

• Pursuing a Bachelor's degree in Computer Science, Data Analysis, or IT related field.
• Experience using data visualization tools (Tableau or Power BI).
• Familiarity with SQL databases.
• Ability to interpret results using statistical techniques and communicating findings effectively.
• Able to identify, analyze, and interpret trends or patterns in complex data sets.
• Should be creative in terms of producing visuals and showing data in presentable format.
• Ability to read, write and understand English for purposes of comprehending written job-related communications and verbal instructions and interactions.

Compensation: $18.00 to $26.00 per hour (depending on qualifications)

At Colliers Engineering & Design, our people are our most important resource. That’s why we are committed to providing all our employees with a safe, comfortable work environment, potential for career advancement, and the ability to impact society through their projects as well as Company sponsored activities. 

Our interns are given opportunities to learn in a variety of settings. Multidisciplinary engineering, surveying, and architectural design projects provide interns an opportunity to see the work in real-life settings, working side by side with other professionals in their chosen field.  They are also able to participate in educational opportunities that build a variety of transferrable skills valuable in every career. Our Career Exploration Series provides interns with chances to network and learn from the professionals doing the work and growing our business. Interns also complete a series of reflections, problem solving activities, contests, drawings, and create end of summer presentations which help showcase their learning and experiences. Additional networking and trainings specific to the students' areas of study are also made available to students throughout the Summer Internship program.  

Our internship program is designed to help grow our organization organically with talented individuals starting their careers all over the country. On average, we make full-time, permanent offers to students approaching graduation within a year more than 50% of the time. We want great talent to start their careers here stay with CED and its affiliates for their entire career!  

We have created an internal culture that provides the resources and technology needed to encourage personal and professional growth opportunities through reimbursement for education; a free in-house resource for hundreds of educational and self-enrichment courses; mentorship program; wellness program; Women’s Organization and ongoing philanthropic opportunities. We make as many of these opportunities available to our interns, as well as our regular employees as possible. 

Apply today to learn how you can join our team of professionals, so we can help you Accelerate Your Success!