Data Analyst (Software Implementation)

About the role

This position reports directly to the Atom Group Manager, or as assigned, within Collins Engineers, Inc. (Collins), a firm with over forty years of specialized civil and structural engineering services for transportation, marine, site development, and construction industries. We provide Software as a Service (SaaS) solutions for inspection, asset management, and maintenance management needs, fostering an environment of personal and professional growth, independent thinking, and individual responsibility across our offices and specializations.

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.