Data Analyst (Software Implementation) (50998)

Job DetailsJob Location: Illinois - Chicago, IL 60661Position Type: Full TimeSalary Range: $65,000.00 - $100,000.00 SalaryJob Category: EngineeringFor over forty years, Collins Engineers, Inc. (Collins) has provided specialized civil and structural engineering services to the transportation, marine, site development, and construction industries. Our offerings include Software as a Service (SaaS) implementation for our clients’ inspection, asset management, and maintenance management needs. We encourage independent, critical thinkers who grow and expand the ways in which we serve our public and private clients. We foster an environment of personal and professional growth, as well as individual responsibility, throughout our many offices and specializations. 

This position reports directly to the Atom Group Manager, or as assigned. 

TYPICAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned. 

Writes and optimizes SQL queries and builds ETL pipelines to extract, transform, and integrate data into centralized databases/warehouses 

Builds custom reports and visualizations using business intelligence tools (e.g., Tableau, Power BI, Looker Studio) 

Creates and administers a Microsoft Fabric environment supporting Power BI dashboards, including workspace setup, virtual machine ODBC maintenance, and dataflows 

Supports API integrations connecting internal platforms with third-party tools/client systems 

Uses Python, Google Apps Script, or similar scripting languages to automate recurring data processes and build automated reports pulling from cloud databases 

Uses AI tools (e.g., Claude, Gemini) as part of daily workflow to accelerate query writing and code development 

Collaborates with cross-functional teams to gather requirements for asset management dashboards and reports used for planning, budgeting, and performance tracking 

Partners with corporate departments (e.g., Safety, HR, Accounting, Pursuits) to scope and build dashboards supporting their workflows 

Presents data findings and dashboard walkthroughs to internal stakeholders and clients 

Ensures high data integrity by troubleshooting and resolving data/reporting issues, including bug reporting and data cleansing/validation during large-scale migrations 

Develops and maintains documentation, including Standard Operating Procedures (for internal team use and client self-service) and data dictionaries/process docs 

Adjusts priorities as new requests or issues arise 

Qualifications 



Bachelor's degree from an accredited institution in a related field (Information Systems, Computer Science, Data Science, Statistics, Business Administration, or similar) 





1–5 years of experience working as a Data Analyst or in a related field 





Intermediate proficiency with SQL, DAX, and/or JavaScript, and proficient in data analysis using Excel and Google Sheets 





Working knowledge of Google Workspace (Docs, Sheets, Slides, Apps Script) and Microsoft Office (Teams, Excel, Word, PowerPoint) 





Knowledge of relational databases and data warehouses (e.g., BigQuery, OneLake, AWS, Azure) 





Knowledge of business intelligence tools (e.g., Power BI, Tableau, Looker Studio) 





Experience with a scripting/programming language (Python, R) for data analysis and automation 





Experience with ETL tools or data pipeline development 





Demonstrated experience working with AI agents and assistants (e.g., Claude, Gemini, Copilot) in analytics and development contexts 





Experience with Microsoft Fabric and/or Deltek Vantagepoint preferred 





Knowledge of Asset Management principles for physical assets is preferred 





Version control (Git) experience preferred 





Strong verbal and written communication skills, including experience presenting data insights to both technical and client/leadership audiences 





Detail-oriented with strong analytical and problem-solving skills