Data Solutions Specialist

Overview

Amico Accelerate : Amico Accelerate is Amico's corporate innovation program focused on scaling enterprise data, analytics, and AI tooling to improve project, schedule, and financial intelligence across the organization. Role Summary : The Data Solutions Specialist builds and supports Amico's enterprise data foundation by developing reliable data pipelines, curated datasets, and standardized models. The role enables consistent, governed reporting in Power BI and supports automation, advanced analytics, and AI-driven workflows across business units. Responsibilities

Enterprise Data Pipelines (Build & Maintain)

Design, build, and maintain production-grade data pipelines that integrate enterprise and project systems into a centralized data environment. Improve reliability through structured refresh processes, monitoring, and exception handling (failure recovery, source-change response, and stability controls). Onboard new data sources and business domains using repeatable patterns (templates and standards) rather than one-off engineering. Data Platform Delivery (Microsoft Fabric)

Build and maintain data products in Microsoft Fabric to support scalable ingestion, transformation, and storage. Partner on performance optimization and capacity-aware delivery as data volume and processing needs grow across finance and project workflows. Reporting Enablement (Power BI)

Deliver clean, governed datasets and semantic-ready structures that enable trusted reporting in Power BI. Reduce report-level transformation by standardizing tables, metrics, and refresh-ready datasets for reuse across reporting suites. Data Quality, Validation & Controls

Implement validation checks and reconciliation routines that increase trust in reporting outputs and reduce manual verification. Establish testing and release discipline (unit/integration/regression where applicable) and operational controls such as retry logic and incremental processing patterns. Documentation & Standards

Document pipelines, refresh schedules, model structures, dependencies, and business rules to reduce knowledge concentration and ensure continuity. Create reusable engineering patterns (templates, naming conventions, and standards) to improve delivery speed and consistency as the program scales. Workflow Automation (End-to-End Processing)

Design and implement end-to-end automated workflows for collecting, staging, processing, validating, and delivering data to reporting products. Build repeatable automation patterns in Fabric (e.g., Dataflows Gen2 for scalable transformations and Spark notebooks for advanced engineering when needed). Standardize downstream consumption by publishing curated Lakehouse tables as consistent outputs. Implement operational scheduling and repeatable processing cycles for recurring workflows, particularly finance-related reporting with increasing cadence. Automate manual, multi-step processes (multiple inputs, reconciliations, audit checks) to minimize manual intervention. Nice to Have

AI-Enabled Data Products & Process Improvement

Support AI-enabled workflow adoption by strengthening data foundations that automate integration, cleansing, and recurring reporting outputs. Contribute to predictive and forecasting-oriented datasets relevant to project delivery and performance management. Create AI-ready curated datasets with controlled lineage and governance to reduce repetitive manual steps and enable downstream automation. Qualifications

Must-Have Qualifications

Experience in data engineering, data integration, analytics engineering, or a similar role delivering production datasets and pipelines. Strong SQL skills and the ability to build repeatable transformation logic and curated datasets. Experience integrating data across enterprise platforms and maintaining reliable refresh processes and operational controls. Experience with modern analytics/data platforms; Microsoft Fabric and Power BI experience is strongly preferred. Strong documentation discipline with the ability to build and maintain institutional knowledge (technical documentation, data definitions, and pipeline notes). Preferred Qualifications

Experience in enterprise construction or other project-based environments. Hands-on experience with Oracle enterprise platforms, including Oracle Autonomous Data Warehouse (ADW), Fusion Data Intelligence (FDI), and Oracle Analytics Cloud (OAC). Experience integrating Oracle-based financial and project data into enterprise analytics platforms. Exposure to data governance, stewardship, and enterprise reporting standards. Core Competencies

Execution-focused, with an emphasis on structured, supportable outputs and clear documentation. Strong troubleshooting and root-cause analysis for pipeline failures, refresh issues, and upstream source changes. Ability to work across business and technical teams, translating requirements into scalable, governed data products. About Us

Amico is a leading, Canadian-owned and operated construction company specializing in large-scale infrastructure projects. With a strong track record in general contracting, civil engineering and road building, we deliver complex infrastructure solutions that shape the communities of Ontario. Our expertise spans major infrastructure projects, including highways, bridges, and critical public works that require meticulous planning, innovative engineering, and precise execution. At Amico, we believe in fostering collaboration and empowering our team to tackle ambitious challenges head-on. By leveraging cutting-edge technology and proven project management practices, we consistently deliver high-quality infrastructure projects, regardless of their scale or complexity. At Amico we don’t just build projects; we build careers, communities, and a lasting legacy. Being part of our team means playing a pivotal role in shaping Ontario’s most impactful infrastructure developments, while gaining hands-on experience. Join us and be part of something bigger. About The Team

At Amico, we are committed to providing an environment of mutual respect where equal opportunities are available to all applicants and teammates. Accommodation is available upon request for applicants throughout the recruitment and selection process. We thank all applicants for their interest. However, only those selected for an interview will be contacted.

#J-18808-Ljbffr