About Soheil
Senior Data Analyst and Engineer with 15+ years of experience designing scalable data solutions across technology, healthcare, public sector, and enterprise environments. Skilled in developing custom AI and ML systems to modernize legacy reporting, analyze business usage patterns, and drive cloud migration strategies.
Proficient in building complex ETL pipelines and leveraging cloud platforms (Azure, AWS, Google) through hands-on projects involving end-to-end pipeline orchestration, data migration and integration, LLM-based similarity search, embeddings, and metadata inference. I bring a hands-on, inventive approach to bridging traditional enterprise systems with emerging AI-native architectures.
English
Native or bilingual
Can work on-site
Halifax (up to 50km)
Experience
- Assent ComplianceData EngineerLOGISTICS AND SUPPLY CHAINJanuary 2025 - May 2025 (4 months)Ottawa, Canada
- Designed and implemented similarity scoring pipelines using OpenAI API, embedding models, Pydantic-based schemas, and custom logic to identify duplicate and overlapping reports and queries.
- Ingested JIRA ticket metadata, report usage metrics, and data access logs into SQL and Elasticsearch, creating a dashboard to highlight high-traffic reports and common data elements across the organization.
- Proposed and prototyped Snowflake migration schemas, including SQL transformation logic and reporting structure redesign based on legacy analysis insights.
- Built internal pipelines using Python, SQL, and ChromaDB to link reports, tickets, and source data, enabling clustering, deduplication, and usage trend analysis at scale.
- Tech Stack: Python, SQL, OpenAI API, Pydantic, ChromaDB, ElasticSearch, Azure SQL, MSSQL, SSRS, Snowflake (Migration Design)
- Translink (BTS Department)Data EngineerTRANSPORTATIONJune 2024 - December 2024 (6 months)Vancouver, BC, Canada
- Designed and implemented a real-time Vehicle Health Monitoring dashboard using Azure EventHub, Synapse Analytics (Pyper), and Data Explorer to ingest and analyze streaming telemetry data.
- Built scalable ingestion and transformation pipelines in PySpark and SQL to support proactive diagnostics and performance monitoring across fleet operations.
- Performed detailed data analysis across enterprise datasets, identifying anomalies, overlaps, and quality issues in coordination with data stewards and business stakeholders.
- Developed and implemented automated data quality controls and monitoring logic to enforce governance policies and improve reliability of operational data.
- Created and maintained conceptual, logical, and physical data models aligned with enterprise architecture principles and metadata standards.
- Collaborated with application support, BI, and data warehouse teams to promote consistent data definitions, support master data management initiatives, and align data models with business rules.
- •Tech Stack: Azure EventHub, Azure Synapse, PySpark, Azure Data Explorer, Azure SQL, SQL, Python
- TransLink (ERP Department)Data Conversion AnalystTRANSPORTATIONOctober 2023 - May 2024 (7 months)Vancouver, Canada
- Led the documentation and analysis of data processes across asset management, finance, and supply chain systems, using SQL, Azure SQL, and MSSQL to assess migration requirements.
- Created data dictionaries, integration flow diagrams, and logical models to support the ERP migration plan and vendor-led tooling.
- Built and supported ETL workflows using SSIS to move and transform legacy data sources into target ERP structures.
- Coordinated with stakeholders and vendor teams using Azure DevOps to manage user stories and track conversion deliverables under a Scrum framework.
- Developed traceability matrices, test plans, and UAT scenarios aligned with system specifications and data governance policies.
- Delivered post-migration SOPs and knowledge base materials to support operational readiness and service desk handoff.
- Tech Stack: SQL, MSSQL, Azure SQL, SSIS, Azure DevOps, Power BI, ERP migration tooling (vendor specific)
Recommendations
Be the first to recommend Soheil
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Health Information ManagementCanadian Health Association2013Health Information Management
- Computer Software & IT ProgramAzad University2003Computer Software & IT Program
Certifications
- Microsoft Data Science ProgramMicrosoft2020
- SQL SSIS & SSRSWeb Age Solutions2013