Home / Opportunities / Big Data Analyst

🇨🇦 Hamilton, ON · Canada

Big Data Analyst

Samee Metal Trading

Full-timeOn-siteSQLExcelPower BI

About the role

*Data & Integrations Analyst*

*Company:* Samee Metal Trading

*Location:* 475 Kenora Ave., Hamilton, ON (In-Office / On-Site)

*Position Type:* Full-Time, 6?9 Month Fixed-Term Contract

*Schedule:* Monday to Friday, 8:00 AM ? 4:00 PM

*Compensation:* $55,000 ? $70,000 CAD annualized (commensurate with experience)

*About Samee Metal Trading*

Samee Metal Trading manages high-volume metal trading, storage, and cross-border freight operations across Canada and the United States. To support our growing transaction volume, we are overhauling our core software ecosystem?retiring manual spreadsheets and legacy systems in favor of *PS Data* ERP, integrated with Rose Rocket (freight) and HubSpot (sales).

We are seeking a sharp, hands-on *Data & Integrations Analyst* to support the implementation of our new steel-industry ERP platform. Working in parallel with the ERP Implementation Lead, Finance, internal IT, operational departments, and PS Data, you will be responsible for source-data assessment, cleansing, migration mapping, interface coordination, reconciliation, and management reporting.

*Key Responsibilities*

* *Source-Data Assessment & Master Data Cleansing*

Assess and audit source data across legacy operational systems and spreadsheets (Sage 50, Rose Rocket, HubSpot, and manual logs), including customers, vendors, item and coil masters (grades, units of measure, storage rates, location records), inventory, purchasing, orders, and financial records.

* *Data Migration & Reconciliation*

Coordinate extraction, transformation, validation, and three planned data conversion cycles into staging and production environments alongside PS Data (subject to final vendor agreement).

* *Systems Integration & Interface Coordination*

Coordinate technical and functional requirements with IT and external vendor teams for interfaces involving Rose Rocket (outbound orders/loads; inbound delivery timestamps, PODs, and freight charges), HubSpot (pipeline/quote stages), and other approved systems?clearly distinguishing confirmed Phase 1 scope from separately quoted integrations.

* *Management Reporting & Dashboards*

Build and maintain foundational daily and weekly operational dashboards in Excel and Power BI (or native platform reporting tools) using agreed company data definitions.

* *Testing, Cutover & Governance*

Assist operational teams with user acceptance testing (UAT), transactional cutover dry runs, audit trails, and post-go-live issue resolution.

Proactively escalate data discrepancies, security or confidentiality concerns, and scope changes requiring Finance, IT, or executive approval.

*Required Qualifications*

* *Data & Migration Experience:* 1?3+ years of practical experience in business data analysis, data mapping, cleansing, ETL/migration workflows, or system integration projects. * *Advanced Spreadsheet & Validation Skills:* Expert-level Microsoft Excel proficiency (complex lookups such as XLOOKUP/INDEX-MATCH, Power Query, pivot models) with proven ability to cleanse, deduplicate, and reconcile complex operational and financial datasets. * *Integration & Technical Literacy:* Working understanding of core data integration concepts (APIs, CSV/flat-file imports and exports, field mapping, webhook triggers) and clear documentation of data flows, business rules, and test cases. * *Business & Numerical Acumen:* High numerical literacy with a solid grasp of foundational business and accounting records (invoices, purchase orders, inventory counts, freight bills, AR/AP/GL). * *Collaboration & Execution:* Strong attention to data integrity, confidentiality, and deadlines?comfortable working on-site across warehouse and trading desks while collaborating with business stakeholders, Finance, IT, and third-party providers.

*Additional Relevant Experience (Assets)*

* Proficiency in SQL, Power BI, or enterprise ETL/reporting tools for querying databases and automating visualizations. * Hands-on familiarity with metals-industry ERPs (PS