Location: Remote (Canada) | Type: Full-time, Permanent | Reports to: Practice Lead, PartnerAbout Mission Impact PartnersMission Impact Partners is an AI Frontier Company specializing in Microsoft Power Platform. We rescue failed implementations, rebuild foundations, and enable organizations to unlock AI-driven productivity. Our proprietary data migration and integration products transform complex projects into seamless solutions.We are a small, growing company with big ambitions. Every person on the team has a direct impact on what we build, how we deliver, and where the business goes next. If you want to work somewhere your contributions are visible and your voice carries weight, this is the place.Data AnalystAbout the RoleWe are looking for a Data Analyst who understands that data is the foundation of every implementation we deliver. Migrations fail and integrations break when data is misunderstood, poorly mapped, or inadequately validated. This role exists to make sure that never happens on our watch.As Data Analyst, you will be embedded in project delivery from discovery through go-live, owning the data layer across our client engagements. You will analyse source systems, produce detailed data mapping documents, author integration specifications, and ensure data quality at every stage of the project lifecycle. You will work directly with clients — facilitating workshops, presenting findings, and translating technical complexity into business language.This is a hands‑on role for someone with real experience in data migration and integration across CRM platforms. You will need strong SQL skills, experience with Power BI and Microsoft Fabric, and a working knowledge of Microsoft Power Platform or an equivalent relational SaaS CRM system such as Salesforce, HubSpot, or Dynamics 365. We are not looking for someone who needs to learn what a data mapping document is; we are looking for someone who has written dozens of them and knows why precision matters.What You’ll DoAnalyse, map, and validate data across client engagementsAnalyse source system data structures, schemas, and relationships across Dynamics 365, Salesforce, legacy CRMs,



and other platforms to build a comprehensive understanding of each client’s data landscapeProduce detailed field‑level data mapping documents with transformation rules, lookup resolution logic, default values, and data type conversionsConduct data quality assessments on source extracts to surface gaps, duplicates, orphaned records, and anomalies before migration — not afterWrite and optimise SQL queries to extract, profile, and validate data across source and target systems throughout the migration lifecycleDefine data validation criteria and acceptance testing procedures so that client sign‑off is objective, not subjectiveAuthor integration specifications and collaborate on solution designAuthor integration specification documents that define data flows, transformation logic, error handling, and scheduling requirements for each integration pointMap API endpoints, authentication flows, and payload structures for third‑party systems involved in integration workstreamsCollaborate with the Development Lead to ensure integration designs are technically feasible and aligned with MIP’s architecture standardsBuild analytical models and reporting that support delivery and client decision‑makingBuild Power BI dashboards for migration tracking, data quality metrics, and post‑migration health reportingLeverage Microsoft Fabric capabilities — including lakehouses, dataflows, and notebooks — where they add value to migration and integration workstreamsStay current with ETL tooling and feed insights back to the teamMaintain a working knowledge of ETL and data integration tools across the Power Platform and Salesforce ecosystems — including Azure Data Factory, KingswaySoft, Scribe Online, CData, DBSync, MuleSoft, and MIP’s own Data Mission suiteEvaluate emerging tools and platform updates that could improve delivery, and bring recommendations to the leadership teamProvide real‑world usage feedback on Data Mission: Sync and Data Mission:



ETL based on project experience to shape the product roadmapWork directly with clients and contribute to business growthFacilitate data discovery workshops with client stakeholders to extract undocumented business rules, data dependencies, and migration prioritiesPresent data quality findings, mapping proposals, and migration strategies to client stakeholders in clear, non‑technical languageAct as the primary point of contact for data‑related questions during active engagementsContribute data migration and integration effort estimates to statements of work and proposalsSupport RFP responses with technical content on data migration methodology, tooling, and integration designWhat We’re Looking For3–5 years of hands‑on experience working with data in a qualified services, consulting, or implementation contextExperience with Microsoft Power Platform, Dataverse, or an equivalent relational SaaS CRM system (Salesforce, HubSpot, Dynamics 365)Proficiency in SQL — you are comfortable writing extraction queries, profiling datasets, and validating migration outcomes across SQL Server, Azure SQL, or similarExperience with Power BI and familiarity with Microsoft FabricA track record of producing data mapping documents, integration specifications, or migration plansStrong communication skills — you can explain an orphaned lookup to a business stakeholder without their eyes glazing overComfort working directly with clients in a consulting environmentNice to haveExperience with ETL tools such as Azure Data Factory, KingswaySoft, or MuleSoftFamiliarity with API integration patterns, authentication flows, and third‑party connector ecosystemsPrior experience at a small or growing company where you wore multiple hatsCompensation & BenefitsBase Salary:$100,000 CAD per annum15 days annual leave5 days of learning holidays for conferences and offsites12 statutory holidays per year10 days annual sick leaveMonthly internet allowance (up to $150 CAD)Competitive health and wellness plan, effective from day oneIf you are the kind of person who finds satisfaction in turning messy, ambiguous data into something clean and trustworthy — and you want to see that work make a real difference for clients — we want to hear from you.#J-18808-Ljbffr

📌 Data Analyst - C$100,000 A Year - Remote (Toronto)
🏢 Mission Impact Partners
📍 Toronto