Job Description

Job Location: Illinois - Chicago, IL 60661
Position Type: Full Time
Salary Range: $65,000.00 - $100,000.00 Salary
Job 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