| Location | Chicago, IL |
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.
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