Senior Data Platform Engineer

Endsight is a fast-growing IT managed service provider that helps small and mid-sized organizations ensure their technology performs reliably. The Senior Data Platform Engineer will build and standardize the company’s Microsoft Fabric-based data integration platform, develop API integrations and MCP servers, and establish engineering standards. The role also involves evaluating technical methods, documenting decisions, collaborating with domain owners, and enabling other engineers through documentation, reviews, and pairing.

Responsibilities:

• Designing and refining medallion-layered architecture in Microsoft Fabric for Endsight and client environments
• Evaluating and building reference implementations for data ingestion and API integration methods, including incremental and change-data-capture patterns, schema-drift handling, and secrets management
• Building MCP servers to Endsight 's internal security and reliability standards, covering authorization scope, fault handling, and injection resistance
• Authoring, publishing, and maintaining engineering standards, enabling other engineers to implement these standards through documentation, review, and pairing
• Taking a share of the team's research and evaluation queue and co-authoring the decision framework for what belongs in the central data platform
• Collaborating with existing domain owners to raise the technical bar

Requirements:

• Two or more years of hands-on production experience with Microsoft Fabric, including lakehouse and warehouse design, medallion architecture, notebooks (PySpark and/or Python), ingestion pipelines, semantic models, and deployment pipelines
• Demonstrated API integration experience: REST and OAuth2, pagination, rate limiting, incremental and change-data-capture patterns, idempotent retries, and secrets management, in systems running unattended in production
• Demonstrated experience building and shipping MCP servers, including tool design, authorization scoping, structured error handling, and resistance to prompt injection
• Strong Python and SQL, infrastructure-as-code, and Git-based workflow
• A documented record of evaluating competing technical methods, writing the standard, and getting other engineers to adopt it
• A documented record of raising technical standards working in coordination with a team
• Comfort working with incompletely defined requirements and pushing back constructively on scope
• Breadth across the Azure data platform: Data Factory, Synapse, Purview, Key Vault, Entra application registration, Azure DevOps
• MSP or professional services background, including familiarity with PSA/RMM data models (ConnectWise, HaloPSA, NinjaOne) and multi-tenant data isolation
• Experience With Other Orchestration Platforms (n8n, Rewst)
• Power Platform and Power Automate
• Experience migrating off a legacy business intelligence or reporting estate
• Experience integrating financial systems data (QuickBooks, Business Central, Adaptive Planning)
• Relevant Microsoft certifications (DP-600, DP-700, or equivalent)