19 Nov
|
Samee Metal Trading
|
Nashdale
19 Nov
Samee Metal Trading
Nashdale
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 in office 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 Data or similar), Transportation Management Systems (Rose Rocket), accounting software (Sage 50), or CRM platforms (HubSpot).
- Background in steel trading, metals distribution, warehousing, freight/3PL logistics, or inventory-intensive manufacturing environments.
- Post-secondary education in Information Systems, Data Analytics, Computer Science, Business Administration, or Supply Chain Management.
Pay: $55,000.00-$70,000.00 per year
Benefits:
- On-site parking
Application question(s):
- How many years of experience do you have as business data analysis, data mapping, cleansing, ETL/migration workflows, or system integration projects?
Work Location: In person
📌 Data & Integrations Analyst (Nashdale)
🏢 Samee Metal Trading
📍 Nashdale