Report Solution Analyst/Specialist

{
  "content_hash": "e73ddc9f26480c88dfe7efa4440883e084281191218b84a405fe349ca96a7a13",
  "source_hash": "f4bf8719c7da9bd2003bb1e60e65505277667eb8eb6264e4449ac879d061d2bc",
  "last_changed_at": "2026-06-03T10:54:45.027Z",
  "active_status": "active"
}

{
  "dedupe": null,
  "language": "en",
  "location": {
    "raw": "Toronto, ON, Canada",
    "city": "Toronto",
    "region": "ON",
    "country": "Canada",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": 102663,
  "salary_min": 69998,
  "inferred_at": "2026-06-21T11:27:13.360Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Toronto, ON, Canada",
      "city": "Toronto",
      "region": "ON",
      "country": "Canada",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "Canada"
    ]
  },
  "remote_policy": null,
  "salary_period": "year",
  "workplace_type": null,
  "salary_currency": "CAD"
}

{}

{
  "id": "744000129823290",
  "ref": "https://api.smartrecruiters.com/v1/companies/mufginvestorservices/postings/744000129823290",
  "name": "Report Solution Analyst/Specialist",
  "uuid": "be8adc15-bcd4-43f2-98eb-78bd91d1050a",
  "detail": {
    "id": "744000129823290",
    "name": "Report Solution Analyst/Specialist",
    "uuid": "be8adc15-bcd4-43f2-98eb-78bd91d1050a",
    "jobAd": {
      "sections": {
        "jobDescription": {
          "text": "<p>The purpose of this role is to design, develop,&#xa0;maintain&#xa0;and support&#xa0;SQL Server&#xa0;Reporting Services (SSRS) reporting solutions that provide&#xa0;accurate,&#xa0;timely&#xa0;and actionable business information. The role&#xa0;is responsible&#xa0;for&#xa0;translating business requirements into scalable reports, ensuring&#xa0;data integrity, improving reporting efficiency and enabling stakeholders to make informed business decisions through reliable reporting and analytics.</p><p><strong>Role and Responsibilities</strong></p><ul><li><p>Maintain and quality-control global reference database for various financial products including exchange traded, broker-dealer platform, and OTC derivatives&#xa0;</p></li></ul><ul><li><p>Ensure&#xa0;accurate&#xa0;and&#xa0;timely&#xa0;pricing and evaluation, perform price validation, and interact with market data vendors (Bloomberg, ICE, Markit,&#xa0;Refinitiv, etc.) such as price challenges&#xa0;</p></li></ul><ul><li><p>Responsible for set-up,&#xa0;maintenance&#xa0;and monitoring of automated processes such as trade capture, investment pricing, and OTC derivatives evaluation&#xa0;</p></li></ul><ul><li><p>Design, develop and&#xa0;maintain&#xa0;reports&#xa0;(RSL/RDL)&#xa0;and dashboards using SQL Server Reporting Services (SSRS)</p></li></ul><ul><li><p>Create and optimize SQL queries, stored procedures, functions,&#xa0;views&#xa0;and datasets&#xa0;</p></li></ul><ul><li><p>Gather business requirements and translate into reporting solutions.&#xa0;Work with cross-functional teams to deliver reporting solutions&#xa0;</p></li></ul><ul><li><p>Troubleshoot report performance and data issues, support report deployment,&#xa0;testing&#xa0;and ongoing enhancements</p></li></ul>",
          "title": "Job Description"
        },
        "qualifications": {
          "text": "<ul><li>2&#xa0;years’&#xa0;of hands-on experience developing and supporting SSRS reports in a production environment or in a similar position</li><li>Bachelor’s degree is a minimum</li><li>Master's in finance, Economics, Business Analytics, Mathematics, Computational Finance, Financial Engineering, or other quantitative fields preferred</li><li>CFA, FRM or enrolment in such professional programs is strongly desired</li><li>Experience is financial services industry, or related area is an asset</li></ul><p><strong>Essential:</strong></p><ul><li><p>Strong experience with SQL Server&#xa0;Reporting Services (SSRS)</p></li></ul><ul><li><p>Proven experience writing complex SQL queries, stored procedures, views,&#xa0;functions&#xa0;and performance optimization&#xa0;</p></li></ul><p><strong>Preferred:</strong></p><ul><li><p>Experience&#xa0;with Bloomberg, Refinitiv,&#xa0;ICE, IHS Markit, and/or other market data vendors&#xa0;</p></li><li><p>Working knowledge with VBA,&#xa0;Python&#xa0;or other scripting languages&#xa0;</p></li><li><p>Experience gathering and translating business requirements into reporting and analytical solutions&#xa0;</p></li></ul><ul><li><p>Experience with report deployment, scheduling, subscriptions,&#xa0;report&#xa0;maintenance&#xa0;and automated delivery.&#xa0;</p></li></ul><ul><li><p>Working knowledge with Advent Geneva&#xa0;</p></li></ul>",
          "title": "Qualifications"
        },
        "companyDescription": {
          "text": "<p>Experience something Brilliantly Different with a career with MUFG Investor Services.</p><p>Who are we?</p><p>MUFG Investor Services is a trusted partner to many of the world’s largest public and private funds, providing asset servicing and operational solutions built for alternatives. With over $1 trillion in client assets under administration, we offer fund administration, banking, payments, fund financing, foreign exchange overlay, corporate and regulatory services, custody, business consulting, and more. Operating from 17 locations worldwide, we help clients mitigate risk, enhance efficiency, and navigate the operational complexities of today’s investment management landscape. As a division of Mitsubishi UFJ Financial Group (MUFG), one of the world’s largest financial institutions with approximately $3 trillion in assets, we combine deep expertise with the strength and stability of a leading financial institution. To learn more, visit us at <a href=\"http://www.mufg-investorservices.com\" rel=\"noopener noreferrer\">www.mufg-investorservices.com</a>.</p><p>Still interested?</p><p>#LI-Hybrid</p>",
          "title": "Company Description"
        },
        "additionalInformation": {
          "text": "<p>What's in it for you to join MUFG Investor Services?</p><p>Take a look at our careers site and you'll find everything you'd expect from a career with the fastest-growing business at one of the world's largest financial groups. Now take another look. Because it's how we defy expectations that really defines us. You'll feel that difference in all kinds of ways. Our vibrant CULTURE. Connected team. Love of innovation, laser client focus, and next-level LEARNING &amp; DEVELOPMENT. Oh, and we really walk the talk when it comes to HYBRID WORKING. So why settle for the ordinary? Apply now for a Brilliantly Different career. We thank all candidates for applying; however, only those proceeding to the interview stage will be contacted.</p><p>This is a newly created position.</p>",
          "title": "Additional Information"
        }
      }
    },
    "jobId": "344645bd-ae63-475a-8270-a529d154de0a",
    "active": true,
    "company": {
      "name": "MUFG Investor Services",
      "identifier": "MUFGInvestorServices"
    },
    "creator": {
      "name": "",
      "avatarUrl": ""
    },
    "jobAdId": "4e444c69-5170-4d5c-bac2-9e278c9c1f8e",
    "applyUrl": "https://jobs.smartrecruiters.com/MUFGInvestorServices/744000129823290-report-solution-analyst-specialist?oga=true",
    "function": {
      "id": "finance",
      "label": "Finance"
    },
    "industry": {
      "id": "financial_services",
      "label": "Financial Services"
    },
    "language": {
      "code": "en",
      "label": "English",
      "labelNative": "English (US)"
    },
    "location": {
      "city": "Toronto",
      "hybrid": false,
      "region": "ON",
      "remote": false,
      "country": "ca",
      "latitude": "43.6548253",
      "longitude": "-79.388447",
      "fullLocation": "Toronto, ON, Canada"
    },
    "refNumber": "REF3866M",
    "department": {
      "id": 11372191,
      "label": "Genesis"
    },
    "postingUrl": "https://jobs.smartrecruiters.com/MUFGInvestorServices/744000129823290-report-solution-analyst-specialist",
    "visibility": "PUBLIC",
    "customField": [
      {
        "fieldId": "626301f450e9a03d73e17820",
        "fieldLabel": "Hours Worked",
        "valueLabel": "37.5"
      },
      {
        "fieldId": "6262ffe85570fc2f07f42f3a",
        "valueId": "055ec051-a858-4469-b04b-873f1129458b",
        "fieldLabel": "Position Sub Type",
        "valueLabel": "Pre-Emptive Backfill"
      },
      {
        "fieldId": "5f3fd9d30f50b04713a8684c",
        "valueId": "11372191",
        "fieldLabel": "Department",
        "valueLabel": "Genesis"
      },
      {
        "fieldId": "6262ff41f22ad467cd58c281",
        "fieldLabel": "Corporate Job Title",
        "valueLabel": "Junior Associate Director, Investment Data and Valuations"
      },
      {
        "fieldId": "62ccac5057a47b5442c66fc9",
        "valueId": "34982e08-6953-46a7-bcfc-591a277093fe",
        "fieldLabel": "Sub Department Code",
        "valueLabel": "IDV-IDV"
      },
      {
        "fieldId": "5f3fd9d30f50b04713a8684b",
        "valueId": "default",
        "fieldLabel": "Brands",
        "valueLabel": "MUFG Investor Services"
      },
      {
        "fieldId": "626300642ea6bf323c991c22",
        "valueId": "16185",
        "fieldLabel": "Line Manager",
        "valueLabel": "Jeffery Hong"
      },
      {
        "fieldId": "6263029adf35942488dedeed",
        "valueId": "aa4a3af6-e399-40c5-960e-e70986771dd5",
        "fieldLabel": "Organisation",
        "valueLabel": "MFS"
      },
      {
        "fieldId": "6262ff222ea6bf323c991c21",
        "valueId": "9a7f275f-678a-4e68-a69f-b230cbc0b4cd",
        "fieldLabel": "In-Rank",
        "valueLabel": "Junior Associate Director"
      },
      {
        "fieldId": "6262fef02ea6bf323c991c20",
        "valueId": "c6fff0f0-f516-4fea-b52a-7db20ff6f464",
        "fieldLabel": "Rank",
        "valueLabel": "Senior Associate"
      },
      {
        "fieldId": "62b0ebbe3af53d24739a8236",
        "valueId": "ca25f18f-0b04-4d9d-a649-e37ff84d62a2",
        "fieldLabel": "LoB's (For Finance)",
        "valueLabel": "Hedge"
      },
      {
        "fieldId": "629e16b3ac51a6561f3d34d4",
        "valueId": "fff4bddb-b35d-48ac-b31d-d65536a429cc",
        "fieldLabel": "Is this an Internal Promotion ?",
        "valueLabel": "No"
      },
      {
        "fieldId": "626302585570fc2f07f42f3c",
        "fieldLabel": "Reason for Hire",
        "valueLabel": "Strategic - IDV Project Support. IDV to realize upon completion."
      },
      {
        "fieldId": "6262ff7a41d4647b0eb45fb5",
        "valueId": "b72a34c6-60ef-4b88-90bc-10512f5e8d60",
        "fieldLabel": "Position Type",
        "valueLabel": "New"
      },
      {
        "fieldId": "62630096f22ad467cd58c282",
        "valueId": "3e6e406e-7b62-4b93-b4e2-e33a4ce6bd71",
        "fieldLabel": "Salary Range",
        "valueLabel": "Ontario IDV Junior Associate Director"
      },
      {
        "fieldId": "62630244c1d4314172d0041c",
        "valueId": "453f56a8-6dd9-4b9b-a78c-fcec68bdb808",
        "fieldLabel": "Salary Period",
        "valueLabel": "Year"
      },
      {
        "fieldId": "6262fdda50e9a03d73e1781f",
        "valueId": "MUFG Fund Services (Canada) Limited",
        "fieldLabel": "Legal Entity",
        "valueLabel": "MUFG Fund Services (Canada) Limited"
      },
      {
        "fieldId": "COUNTRY",
        "valueId": "ca",
        "fieldLabel": "Country/Region",
        "valueLabel": "Canada"
      },
      {
        "fieldId": "6262fe30470c3462cf349f97",
        "valueId": "6bd2f7b7-b146-43c6-aecc-588bc5d85cc9",
        "fieldLabel": "CRM Location",
        "valueLabel": "Toronto"
      },
      {
        "fieldId": "6262fdb5df35942488dedeeb",
        "valueId": "712c6352-53b7-4b1a-a724-a41bd2a0bdc8",
        "fieldLabel": "Office Location",
        "valueLabel": "Toronto"
      },
      {
        "fieldId": "6262fd6798235311311fa3bb",
        "valueId": "1bf432e6-f6da-4146-b7eb-a080a9c686f2",
        "fieldLabel": "Department Code",
        "valueLabel": "IDV"
      },
      {
        "fieldId": "6262fe7e69f68919d25b8d20",
        "valueId": "4ca97bf5-c3f3-47cb-bdc7-700c7e0141b1",
        "fieldLabel": "Employment Type",
        "valueLabel": "Permanent Full Time"
      },
      {
        "fieldId": "6271263e5b3a642e04d867f2",
        "valueId": "MFS",
        "fieldLabel": "BL",
        "valueLabel": "MFS"
      }
    ],
    "referralUrl": "https://jobs.smartrecruiters.com/external-referrals/company/MUFGInvestorServices/publication/be8adc15-bcd4-43f2-98eb-78bd91d1050a?dcr_ci=MUFGInvestorServices",
    "compensation": {
      "max": 102663,
      "min": 69998,
      "period": "YEARLY",
      "currency": "CAD"
    },
    "defaultJobAd": true,
    "releasedDate": "2026-06-02T17:33:50.653Z",
    "experienceLevel": {
      "id": "mid_senior_level",
      "label": "Mid-Senior Level"
    },
    "typeOfEmployment": {
      "id": "permanent",
      "label": "Full-time"
    }
  },
  "company": {
    "name": "MUFG Investor Services",
    "identifier": "MUFGInvestorServices"
  },
  "jobAdId": "4e444c69-5170-4d5c-bac2-9e278c9c1f8e",
  "function": {
    "id": "finance",
    "label": "Finance"
  },
  "industry": {
    "id": "financial_services",
    "label": "Financial Services"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "Toronto",
    "hybrid": false,
    "region": "ON",
    "remote": false,
    "country": "ca",
    "latitude": "43.6548253",
    "longitude": "-79.388447",
    "fullLocation": "Toronto, ON, Canada"
  },
  "refNumber": "REF3866M",
  "department": {
    "id": "11372191",
    "label": "Genesis"
  },
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "6262ffe85570fc2f07f42f3a",
      "valueId": "055ec051-a858-4469-b04b-873f1129458b",
      "fieldLabel": "Position Sub Type",
      "valueLabel": "Pre-Emptive Backfill"
    },
    {
      "fieldId": "5f3fd9d30f50b04713a8684c",
      "valueId": "11372191",
      "fieldLabel": "Department",
      "valueLabel": "Genesis"
    },
    {
      "fieldId": "62ccac5057a47b5442c66fc9",
      "valueId": "34982e08-6953-46a7-bcfc-591a277093fe",
      "fieldLabel": "Sub Department Code",
      "valueLabel": "IDV-IDV"
    },
    {
      "fieldId": "5f3fd9d30f50b04713a8684b",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "MUFG Investor Services"
    },
    {
      "fieldId": "626300642ea6bf323c991c22",
      "valueId": "16185",
      "fieldLabel": "Line Manager",
      "valueLabel": "Jeffery Hong"
    },
    {
      "fieldId": "6263029adf35942488dedeed",
      "valueId": "aa4a3af6-e399-40c5-960e-e70986771dd5",
      "fieldLabel": "Organisation",
      "valueLabel": "MFS"
    },
    {
      "fieldId": "6262ff222ea6bf323c991c21",
      "valueId": "9a7f275f-678a-4e68-a69f-b230cbc0b4cd",
      "fieldLabel": "In-Rank",
      "valueLabel": "Junior Associate Director"
    },
    {
      "fieldId": "6262fef02ea6bf323c991c20",
      "valueId": "c6fff0f0-f516-4fea-b52a-7db20ff6f464",
      "fieldLabel": "Rank",
      "valueLabel": "Senior Associate"
    },
    {
      "fieldId": "62b0ebbe3af53d24739a8236",
      "valueId": "ca25f18f-0b04-4d9d-a649-e37ff84d62a2",
      "fieldLabel": "LoB's (For Finance)",
      "valueLabel": "Hedge"
    },
    {
      "fieldId": "629e16b3ac51a6561f3d34d4",
      "valueId": "fff4bddb-b35d-48ac-b31d-d65536a429cc",
      "fieldLabel": "Is this an Internal Promotion ?",
      "valueLabel": "No"
    },
    {
      "fieldId": "6262ff7a41d4647b0eb45fb5",
      "valueId": "b72a34c6-60ef-4b88-90bc-10512f5e8d60",
      "fieldLabel": "Position Type",
      "valueLabel": "New"
    },
    {
      "fieldId": "62630096f22ad467cd58c282",
      "valueId": "3e6e406e-7b62-4b93-b4e2-e33a4ce6bd71",
      "fieldLabel": "Salary Range",
      "valueLabel": "Ontario IDV Junior Associate Director"
    },
    {
      "fieldId": "62630244c1d4314172d0041c",
      "valueId": "453f56a8-6dd9-4b9b-a78c-fcec68bdb808",
      "fieldLabel": "Salary Period",
      "valueLabel": "Year"
    },
    {
      "fieldId": "6262fdda50e9a03d73e1781f",
      "valueId": "MUFG Fund Services (Canada) Limited",
      "fieldLabel": "Legal Entity",
      "valueLabel": "MUFG Fund Services (Canada) Limited"
    },
    {
      "fieldId": "COUNTRY",
      "valueId": "ca",
      "fieldLabel": "Country/Region",
      "valueLabel": "Canada"
    },
    {
      "fieldId": "6262fe30470c3462cf349f97",
      "valueId": "6bd2f7b7-b146-43c6-aecc-588bc5d85cc9",
      "fieldLabel": "CRM Location",
      "valueLabel": "Toronto"
    },
    {
      "fieldId": "6262fdb5df35942488dedeeb",
      "valueId": "712c6352-53b7-4b1a-a724-a41bd2a0bdc8",
      "fieldLabel": "Office Location",
      "valueLabel": "Toronto"
    },
    {
      "fieldId": "6262fd6798235311311fa3bb",
      "valueId": "1bf432e6-f6da-4146-b7eb-a080a9c686f2",
      "fieldLabel": "Department Code",
      "valueLabel": "IDV"
    },
    {
      "fieldId": "6262fe7e69f68919d25b8d20",
      "valueId": "4ca97bf5-c3f3-47cb-bdc7-700c7e0141b1",
      "fieldLabel": "Employment Type",
      "valueLabel": "Permanent Full Time"
    },
    {
      "fieldId": "6271263e5b3a642e04d867f2",
      "valueId": "MFS",
      "fieldLabel": "BL",
      "valueLabel": "MFS"
    },
    {
      "fieldId": "626301f450e9a03d73e17820",
      "fieldLabel": "Hours Worked",
      "valueLabel": "37.5"
    },
    {
      "fieldId": "6262ff41f22ad467cd58c281",
      "fieldLabel": "Corporate Job Title",
      "valueLabel": "Junior Associate Director, Investment Data and Valuations"
    },
    {
      "fieldId": "626302585570fc2f07f42f3c",
      "fieldLabel": "Reason for Hire",
      "valueLabel": "Strategic - IDV Project Support. IDV to realize upon completion."
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2026-06-02T17:33:50.653Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "mid_senior_level",
    "label": "Mid-Senior Level"
  },
  "typeOfEmployment": {
    "id": "permanent",
    "label": "Full-time"
  }
}