Data Analyst (Software Implementation) (50998)

Collins Engineers, Inc•Chicago, IL

4d•$65,000 - $100,000•Onsite

About The Position

For 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.

Requirements

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
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

Nice To Haves

Experience with Microsoft Fabric and/or Deltek Vantagepoint preferred
Knowledge of Asset Management principles for physical assets is preferred
Version control (Git) experience preferred

Responsibilities

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