Note: The job is a remote job and is open to candidates in USA. The Pan American Health Organization (PAHO), the Regional Office of the World Health Organization (WHO), is seeking a Data, Analytics and AI Consultant to support its Microsoft Fabric data and analytics platform. The consultant will manage daily platform operations, data engineering, semantic modeling, security, governance, AI-enabled analytics, documentation, and the development of a prioritized platform evolution roadmap.
Responsibilities
- Review the assigned work queue each working day; acknowledge new tasks; confirm scope, priority, acceptance criteria, dependencies, effort, and target completion date
- Deliver tasks by the agreed due date. If delivery is at risk, notify the Senior Advisor Applications Development and Support, promptly and propose a recovery plan or revised date for approval
- Keep task records current with progress, decisions, blockers, testing evidence, deployment status, and next actions
- Work with ITS units, data owners, and PAHO departments to gather requirements, assess impacts, translate needs into feasible solutions, and demonstrate completed work
- Operate and support Fabric capacities, tenant settings, domains, workspaces, gateways and connectivity, OneLake, Lakehouses, Warehouses, SQL endpoints, Data Factory items, notebooks, semantic models and related Power BI services
- Monitor capacity utilization, throttling, job concurrency, pipeline and notebook execution, refreshes, query performance, failures, costs and service health; tune or scale workloads within approved limits
- Investigate incidents and recurring failures across ingestion, transformation, storage, semantic models, gateways, access and reports; document root cause, corrective action and prevention when required
- Maintain schedules, service identities, connections, credentials, operational checks, recovery procedures and support runbooks for production services
- Provide level 2/3 support and coordinate with Microsoft, UNICC, vendors and internal teams when an issue requires escalation
- Operate and administer the Microsoft Fabric estate on a daily basis, including tenant settings, domains, workspace structures, item lifecycle, licensing assignment, and platform configuration in line with PAHO governance requirements
- Manage capacity provisioning, utilization monitoring, throttling and smoothing analysis, workload isolation, and cost optimization on F-SKU capacities using the Fabric Capacity Metrics App; maintain a consumption forecast against contracted entitlement
- Monitor and support pipelines, Dataflows Gen2, notebooks, warehouse and lakehouse workloads, and semantic model refreshes; resolve failures, latency, and performance degradation; identify root causes and sustainable corrective actions
- Maintain and improve deployment pipelines, workspace Git integration, and environment promotion across development, test, and production
- Own backup, resiliency, and recovery for OneLake data and workspace artifacts, including documented and periodically tested recovery procedures for production workloads
- Handle incidents, service requests, problems, and changes through PAHO’s corporate IT service management platform, respecting agreed service levels and change control requirements
- Design, build, and maintain ingestion and transformation processes using Fabric Data Factory pipelines, Dataflows Gen2, Spark notebooks, shortcuts, and mirroring, applying incremental and cost-efficient patterns
- Implement and maintain a medallion (bronze / silver / gold) structure with explicit ownership, contracts, and quality controls between layers
- Develop, maintain, and troubleshoot integrations with PAHO corporate systems — in particular the Workday-based PMIS covering human resources, finance, procurement, and grants data — as well as Salesforce, SharePoint, SQL sources, and external data providers, using approved APIs, report-as-a-service extracts, event-driven patterns, and secure authentication mechanisms
- Design and maintain dimensional and semantic models (star schema, slowly changing dimensions, Direct Lake), DAX measures, certified datasets, and row-level and object-level security aligned to PAHO’s data access rules
- Implement data quality, reconciliation, validation, and lineage controls; investigate and resolve data discrepancies with the relevant data owners and document the outcome
- Provide second-level technical support and guidance to PAHO report developers and business power users on modeling, performance, and reporting standards
- Establish and thereafter maintain a complete and current baseline of the Fabric environment, covering architecture, domain and workspace structure, capacity allocation, data sources and flows, semantic models, security model, integrations, dependencies, operational procedures, and ownership, so that the platform can be operated and handed over by any qualified engineer without reliance on undocumented knowledge
- Review the current configuration of capacity, workspaces, pipelines, semantic models, and security against Microsoft reference architecture, well-architected guidance, and PAHO standards; document deviations, risks, technical debt, and remediation options with associated effort and benefit estimates
- Identify, quantify, and — once approved — implement optimization opportunities across capacity consumption and cost, refresh and query performance, pipeline design, storage, and licensing
- Define, document, and apply platform engineering standards covering naming conventions, workspace and domain strategy, environment separation, source control and CI/CD, promotion and change gates, monitoring and alerting, data quality, and documentation
- Produce and maintain a prioritized twelve-to-eighteen-month evolution roadmap for the data and analytics platform, covering architecture, governance, capacity, integration, semantic layer, and AI enablement, sequenced with effort, dependencies, risks, cost implications, and resourcing requirements, for ITS management decision
- Provide ITS management with objective, evidence-based analysis of platform health, risk exposure, and improvement priorities on a recurring basis
- Assess, pilot, and where approved operationalize Fabric-native AI capabilities, including Copilot in Fabric and Power BI, data agents, AI functions in notebooks, and semantic model preparation for natural-language querying
- Build AI-ready data products and semantic layers that can be securely grounded and consumed by PAHO’s Copilot Studio and Power Platform agent portfolio, Azure AI services, and other approved AI solutions
- Propose and prototype practical, measurable use cases — such as automated data quality and anomaly detection, forecasting, natural-language reporting, and document or text analytics — presenting expected benefit, consumption impact, and cost before any scaling decision
- Apply PAHO’s AI governance, data protection, information classification, and responsible AI requirements; document grounding sources, guardrails, evaluation scenarios, known limitations, and human oversight arrangements
- Monitor the Microsoft Fabric and Azure AI roadmap and advise ITS on which capabilities are sufficiently mature for institutional adoption and which should remain experimental, with a clear rationale in each case
- Apply least-privilege access controls across tenant, domain, workspace, item, and data levels, including workspace roles, sharing settings, and conditional access aligned with PAHO requirements
- Manage Microsoft Entra ID service principals and app registrations used for Fabric and Power BI automation, including permission scoping, API access configuration, and credential and secret rotation
- Administer and validate row-level and object-level security in semantic models, including membership-based security patterns and deployment-time integrity checks
- Support Microsoft Purview integration, sensitivity labels, data loss prevention policies, cataloguing, and audit logging in line with approved governance standards
- Collaborate with ITS Information Security on reviews, incidents, access recertification, integration dependencies, and remediation activities; do not implement unapproved production changes
- Maintain architecture and configuration records, solution designs, data dictionaries, lineage documentation, integration specifications, test evidence, deployment records, runbooks, and task history for all material changes
- Store all code, notebooks, pipeline definitions, configuration, documentation, and work products in PAHO-approved repositories, with version control applied
- Provide demonstrations, walkthroughs, and structured knowledge-transfer sessions to PAHO staff and authorized support resources, including hands-on enablement on the standards and procedures established
- Submit the required monthly activity report and support any ITS reporting requirements toward PAHO management and governance bodies
- An executive summary and a complete register of every task assigned during the month, plus open tasks carried forward
- For each task: identifier, title, requester or owner, assignment date, priority, agreed due date, status, completion date, and task-record reference
- For each task: a concise summary of work performed, changes made, testing and approval completed, deployment outcome, documentation produced, and result achieved
- For delayed, blocked, cancelled, or re-scoped tasks: reason, impact, required action, mitigation, and approved revised date; plus priorities for the following month
- Platform operations for the period: pipeline and semantic model refresh success rates, incidents and problems, production changes and releases, and preventive actions taken
- Fabric capacity utilization and consumption against contracted entitlement, with a projection to the end of the contract period, plus cost optimization actions taken or proposed
- Progress against the baseline documentation, standards, and evolution roadmap deliverables, including documentation coverage of production workspaces, pipelines, and semantic models
- Risks, technical debt, security findings, recommendations, and planned focus for the following month
Skills
- University degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field from a recognized institution
- At least five years of progressively responsible experience in data engineering, analytics, and business intelligence in complex enterprise environments, of which at least three years in a large, multi-location or multi-entity organization
- At least two years of hands-on production experience with Microsoft Fabric since its general availability, complemented by prior Power BI Premium and/or Azure Synapse Analytics experience
- Demonstrated responsibility for a Microsoft Fabric environment at organizational scale, including capacity administration, domain and workspace design, CI/CD, security, and platform standards, and not solely report or pipeline development
- Demonstrated experience documenting, rationalizing, and modernizing an existing analytics environment that has grown organically, including establishing standards and defining a subsequent evolution roadmap adopted by management
- Advanced SQL and Python (PySpark); experience with Delta Lake and Parquet; proven experience in dimensional and semantic modeling and advanced DAX
- Demonstrated experience integrating enterprise SaaS and ERP systems with analytics platforms using APIs, connectors, and event-driven patterns
- Demonstrated ability to work autonomously, manage a prioritized backlog, maintain accurate work records, document rigorously, deliver by agreed deadlines, and communicate effectively with technical and non-technical stakeholders
- Microsoft Certified: Fabric Data Engineer Associate (DP-700) and/or Fabric Analytics Engineer Associate (DP-600) is required
- English: Fluency in written and spoken English is required
- Experience integrating Workday (report-as-a-service, Workday APIs, Prism Analytics) with Microsoft Fabric or Azure data platforms is highly desirable
- Practical experience with AI-enabled analytics, including Copilot in Fabric or Power BI, data agents, Azure OpenAI, retrieval and embedding pipelines, together with the judgement to assess maturity, cost, and institutional readiness realistically. Highly desirable
- Microsoft Certified: Fabric Data Engineer Associate (DP-700) and/or Fabric Analytics Engineer Associate (DP-600) is required or strongly preferred
- Power BI Data Analyst Associate (PL-300), Azure Solutions Architect Expert (AZ-305), Azure AI Engineer Associate (AI-102), and Information Protection and Compliance Administrator (SC-400) certifications are desirable
- Other languages: Working knowledge of Spanish is desirable; knowledge of French or Portuguese is an asset
Benefits
- Remote (Off-Site) work arrangement
Company Overview