- Salary
- $150k – $175k/yr
- Location
- Napa
- Workplace
- Remote
- Type
- Full-time
- Department
- Engineering
- Seniority
- Senior
- Source
- Pinpoint
Description
Senior Data Platform Engineer
Department: Development Operations (Dev)
Employment Type: Full Time
Location: Napa
Compensation: $150,000 - $175,000 / year
Description
Who We Are | Endsight is a fast-growing IT Managed Service Provider built on one core belief:
When we help others thrive, we thrive too.
We partner with small and mid-sized organizations, including nonprofits, to ensure their technology performs flawlessly so they can focus on what they do best.
We’re a team that learns fast, leans in, and looks out for one another. Life here feels like being part of a great university. You’ll grow quickly, connect deeply, and do work that truly matters.
Purpose: What You’ll Do
- 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
Who Thrives Here
- Take pride in helping others succeed
- Love mastering your tools and improving your craft
- Communicate clearly and stay composed under pressure
- Are energized by teamwork and mutual respect
- Want to grow in a place where your success helps everyone win
Qualifications
- 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)
Benefits & Compensation
- Medical: Company pays 100% of the base plan for the employee and family
- Dental & Vision
- 401(k) with employer matching
- Accrued Paid Time Off
- 9 Paid Holidays
- Career Development support and programs
- $150,000 – $175,000 base salary