Data Analyst

Location: Remote (Canada) | Type: Full-time, Permanent | Reports to: Practice Lead, Partner About Mission Impact Partners Mission 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 Analyst About the Role We 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 Do Analyse, map, and validate data across client engagements Analyse 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 landscape Produce detailed field‑level data mapping documents with transformation rules, lookup resolution logic, default values, and data type conversions Conduct data quality assessments on source extracts to surface gaps, duplicates, orphaned records, and anomalies before migration — not after Write and optimise SQL queries to extract, profile, and validate data across source and target systems throughout the migration lifecycle Define data validation criteria and acceptance testing procedures so that client sign‑off is objective, not subjective Author integration specifications and collaborate on solution design Author integration specification documents that define data flows, transformation logic, error handling, and scheduling requirements for each integration point Map API endpoints, authentication flows, and payload structures for third‑party systems involved in integration workstreams Collaborate with the Development Lead to ensure integration designs are technically feasible and aligned with MIP’s architecture standards Build analytical models and reporting that support delivery and client decision‑making Build Power BI dashboards for migration tracking, data quality metrics, and post‑migration health reporting Leverage Microsoft Fabric capabilities — including lakehouses, dataflows, and notebooks — where they add value to migration and integration workstreams Stay current with ETL tooling and feed insights back to the team Maintain 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 suite Evaluate emerging tools and platform updates that could improve delivery, and bring recommendations to the leadership team Provide real‑world usage feedback on Data Mission: Sync and Data Mission: ETL based on project experience to shape the product roadmap Work directly with clients and contribute to business growth Facilitate data discovery workshops with client stakeholders to extract undocumented business rules, data dependencies, and migration priorities Present data quality findings, mapping proposals, and migration strategies to client stakeholders in clear, non‑technical language Act as the primary point of contact for data‑related questions during active engagements Contribute data migration and integration effort estimates to statements of work and proposals Support RFP responses with technical content on data migration methodology, tooling, and integration design What We’re Looking For 3–5 years of hands‑on experience working with data in a professional services, consulting, or implementation context Experience 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 similar Experience with Power BI and familiarity with Microsoft Fabric A track record of producing data mapping documents, integration specifications, or migration plans Strong communication skills — you can explain an orphaned lookup to a business stakeholder without their eyes glazing over Comfort working directly with clients in a consulting environment Nice to have Experience with ETL tools such as Azure Data Factory, KingswaySoft, or MuleSoft Familiarity with API integration patterns, authentication flows, and third‑party connector ecosystems Prior experience at a small or growing company where you wore multiple hats Compensation & Benefits Base Salary: $100,000 CAD per annum 15 days annual leave 5 days of learning holidays for conferences and offsites 12 statutory holidays per year 10 days annual sick leave Monthly internet allowance (up to $150 CAD) Competitive health and wellness plan, effective from day one If 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