Available · Victoria, BC

TuralMansimov

Data Analyst · BI Developer · Analytics Engineer

I turn raw data into business decisions — using Power BI, Snowflake, SQL, and AI augmentation to build analytics that actually get used.

7+
Portfolio Projects
3×
Salesforce Certified
8+
Years Experience
AI
Augmented Analytics
01

About

I turn raw data into decisions. My stack: Snowflake for data modelling and Medallion Architecture, Power BI and Tableau for executive dashboards, SQL and Python for pipelines, and Claude AI connected live via MCP for AI-augmented analytics. End-to-end, no handoffs.

Across 7 portfolio projects I've processed 2.45M scooter trips, 48,890 patient records, 27,364 insurance policies, and 1,000 AI-scored support tickets. I've built star schemas, Medallion pipelines, 25-measure DAX models, and a live Salesforce-to-Power BI API connection — all documented on GitHub.

Prior roles: Head of Reporting at the Bank of Azerbaijan, Reporting Manager at Azerbaijan's Ministry of Economy where I calculated the national inflation rate, and Salesforce Developer at Arc'teryx building and maintaining automation processes from data input to reporting and dashboards. Each role was fundamentally about data accuracy, pipeline reliability, and reporting that stakeholders trusted.

Open to Data Analyst, Analytics Engineer, or BI Developer roles in Victoria or remote across Canada.

Experience

Oct 2023–Jan 2025
Salesforce Developer
Arc'teryx · Remote, Vancouver
Built and maintained automation processes from data input to reporting and dashboards across three Salesforce portals.
2013–2015
Head of Reporting
Bank of Azerbaijan
Designed daily, weekly, and annual performance reports for senior management and regulatory bodies. Promoted to department head within 2 years.
2010–2013
Reporting Manager
Ministry of Economy, Azerbaijan
Analyzed consumer market price data to calculate the national inflation rate using statistical algorithms, supporting government budget planning.
Quick Info
  • Victoria, BC (open to remote)
  • Data Analyst · BI Developer
  • mansimovtural@gmail.com
  • Certificate, Data Analytics · Feb 2026
Target Roles
  • Data Analyst
  • Analytics Engineer
  • BI Developer
02

Skills

Querying & Data
SQLDAXPower Query (M)SOQLPython
BI & Visualisation
Power BITableauExcel
Cloud & Platforms
SnowflakeMySQLDBeaverMedallion ArchitectureETL/ELT
AI Augmentation
Claude AI (MCP)Snowflake Cortex AILLM Prompt EngineeringSENTIMENT()COMPLETE()
Salesforce
Admin (ADM-201)Platform DeveloperData CloudApexLWCFlow
Collaboration
Git · GitHubJiraConfluenceAgile/ScrumVS Code
03

Projects

PROJECT / 01

HR Analytics Dashboard

AI-augmented people analytics. Claude AI connected live to Power BI via MCP. 4 report pages: Workforce Snapshot, Attrition & Retention, Talent Acquisition, Insights & Recommendations.

Power BIDAXClaude AIMCPStar Schema
35.5%
Attrition
−414
Net HC
4
Pages
PROJECT / 02

Cortex AI Sentiment Analysis

Snowflake Cortex AI LLMs to score 480 support tickets using SENTIMENT() and COMPLETE() functions, visualised in Power BI.

SnowflakeCortex AIPower BISQL
480
Tickets
LLM
AI Powered
PROJECT / 03

Supply Chain Analytics

Full Medallion Architecture (Bronze→Silver→Gold) in Snowflake with 6-page executive Power BI dashboard.

SnowflakeMedallionPower BISQL
3
Layers
6
Pages
PROJECT / 04

Healthcare Analytics Dashboard

48,890 patient records, $97M billed. Star schema with 6-page Power BI dashboard covering admissions, billing, and outcomes.

Power BIDAXStar SchemaSQL
48.9K
Patients
$97M
Billed
PROJECT / 05

Sales Analytics · Salesforce → Power BI

Live Salesforce API connection to Power BI with conversion funnel, revenue visuals, and pipeline health.

SalesforcePower BILive APIDAX
Live
Connection
CRM
Source
PROJECT / 06

Insurance Analytics

End-to-end pipeline on 27,364 auto insurance policies ($40.6M premium). Decomposed Loss Ratio into Frequency × Severity — surfaced a 37-point gap invisible to single-variable analysis.

PythonSnowflakePower BIDAXMedallion
27.4K
Policies
$40.6M
Premium
6
Pages
PROJECT / 07

Micromobility Revenue Intelligence

Full Medallion Architecture on 2.45M scooter trips. Central Austin generates 75% of trips at below-average revenue ($7.78 vs $8.70 network average) — modelled surge pricing as the fix.

SnowflakeSQLTableauMedallion
2.45M
Trips
75%
Central ATX
5
Pages

Demo Recording
AI Augmentation Demo — 7 min
Watch Claude AI connect live to the Power BI file, generate dim_date, build the data dictionary, and create the GitHub README — all in one session.
04

Contact

Available for new opportunities

Let's build something meaningful together.

Open to Data Analyst, Analytics Engineer, and BI Developer roles in Victoria BC or remote anywhere in Canada. Always happy to talk data, Power BI, Snowflake, or AI-augmented analytics.