Data Analyst (Software Implementation) (50998)

For over forty years Collins Engineers Inc. (Collins) has provided specialized civil and structural engineering services to the transportation marine site development and construction include Software as a Service (SaaS)implementationfor our clientsinspectionassetmanagementand maintenance managementneeds. 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 RESPONSIBILITIESinclude 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) toscope 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

• Bachelors degree from an accredited institution in a related field (Information Systems Computer Science Data Science Statistics Business Administration or similar)

• 15 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 principlesfor physical assetsispreferred

• 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