Staff Data Engineer

Socket.dev

Durham (NC)

On-site

USD 110,000 - 160,000

Full time

2 days ago
Be an early applicant
Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Socket.dev is seeking an Analytics Engineer to design, build, and operate analytics and automations using governed enterprise data. You will deliver high-quality Power BI reporting, establish Fabric and BigQuery pipelines, and build Python-based automations and copilots.

You will join the Cloud & Service Management organization to evolve self-service analytics, scalable data architecture, and governance across the platform, with hands-on ownership of delivery and platform best practices.

Qualifications

  • 5+ years of analytics/BI/data engineering experience.
  • 3+ years of Power BI development experience.
  • Strong experience with Microsoft Fabric (Lakehouse, Warehouse, Dataflows).
  • Proficient in DAX, SQL, and data modeling.
  • Hands-on Python experience delivering ML or GenAI solutions in production.
  • Working knowledge of RAG concepts (embeddings, vector search, retrieval, grounding).
  • Experience implementing monitoring and testing for data/ML/GenAI systems.
  • Experience managing environments, security, and deployments.
  • Strong understanding of data governance and analytics best practices.

Responsibilities

  • Design, develop, and maintain Power BI reports and dashboards.
  • Build semantic models using strong dimensional modeling (star schema).
  • Write and tune DAX measures with a focus on performance and usability.
  • Implement Power BI and Looker deployment pipelines and promote content across environments.
  • Establish Fabric architecture, including Lakehouse/Warehouse and Dataflows Gen2.
  • Manage Fabric capacities, workspaces, and permissions; monitor performance and cost.
  • Develop Python-based data transformations and notebooks within Fabric.
  • Define and enforce data modeling and medallion architecture standards.
  • Build automation flows for business processes using Power Automate and Dataverse.
  • Implement error handling, logging, and operational support patterns.
  • Define Dev/Test/Prod environment strategy and governance standards.

Skills

Power BI development
DAX
SQL
Data modeling
Python ML production
GenAI solutions
RAG concepts
Data governance
Analytics engineering
Cloud data platforms

Tools

Microsoft Fabric
Looker
Dataverse
Power Automate
Power Apps
BigQuery
Azure SQL
Python

Job description

Role Overview

We are seeking an Analytics Engineer to design, build, and operate our analytics and automations as well as build of AI-powered automations and copilots using governed enterprise data. This role is responsible for delivering high-quality Power BI reporting, establishing and maintaining Microsoft Fabric and/or GCP BigQuery, and building business automations and applications using Python, Power Automate and Power Apps.

You will be part of the Cloud & Service Management organization helping to evolve our self-service analytics, scalable data architecture, and automations—while ensuring security, performance, and governance across the platform.

This is a hands-on role with ownership of both solution delivery and platform best practices.

Key Responsibilities

Analytics & Reporting

  • Design, develop, and maintain reports and dashboards
  • Build and optimize semantic models using strong dimensional modeling (star schema)
  • Write and tune DAX measures with a focus on performance and usability
  • Implement Power BI and Looker deployment pipelines and promote content across environments

Microsoft Fabric Platform

  • Establish and maintain Microsoft Fabric architecture, including:
    • Lakehouse and/or Warehouse
    • Dataflows Gen2
    • OneLake data organization
  • Manage Fabric capacities, workspaces, and permissions
  • Monitor performance, cost, and reliability of Fabric workloads
  • Develop and maintain Python-based data transformations and notebooks within Fabric
  • Use Python for data preparation, enrichment, validation, and advanced analytics
  • Define and enforce data modeling and medallion architecture standards

Automation & Applications

  • Build and maintain automation flows for business processes, approvals, and integrations
  • Work with Dataverse, connectors, and security roles
  • Implement error handling, logging, and operational support patterns

Platform Governance & Operations

  • Define Dev/Test/Prod environment strategy for reporting and automation platform
  • Implement Application Life best practices (solutions, pipelines, source control where applicable)
  • Establish governance standards to prevent platform sprawl
  • Partner with security and IT teams on access control and compliance
  • Provide guidance and enablement to analysts and citizen developers

Collaboration & Leadership

  • Translate business requirements into scalable technical solutions
  • Contribute to platform roadmap and continuous improvement efforts

Agentic AI & ML Enablement

  • Design and deliver agentic AI solutions that automate multi-step business workflows (tool use, planning, and human-in-the-loop approvals) using enterprise data and governed actions.

  • Build RAG (retrieval-augmented generation) patterns over Fabric/OneLake (document ingestion, chunking, embeddings, retrieval evaluation) to power analytics copilots and self-service Q&A.

  • Develop and operate ML pipelines (feature engineering, training, evaluation, batch/real-time inference) using Python and approved ML frameworks.

  • Establish LLMOps/ModelOps practices: prompt/version control, offline evaluation, regression testing, monitoring (quality, drift, cost, latency), and safe rollback.

  • Implement AI security and governance: data access controls, prompt/data leakage prevention, PII handling, model risk reviews, and audit logging for agent actions.

  • Partner with stakeholders to identify high-value use cases and deliver measurable outcomes(time saved, defect reduction, SLA improvements).

Required Qualifications

  • 5+ years of experience in analytics, BI, or data engineering roles
  • 3+ years of hands‑on Power BI development experience
  • Strong experience with Microsoft Fabric (Lakehouse, Warehouse, Dataflows)
  • Proficient in DAX, SQL, and data modeling
  • Hands‑on experience with:
    • Power Automate (cloud flows, approvals, integrations)
    • Power Apps (Canvas apps)
    • Dataverse
  • Hands‑on Python experience delivering ML or GenAI solutions in production (notebooks-to-service, APIs, scheduled jobs, or integrated automations).
  • Working knowledge of RAG concepts (embeddings, vector search, retrieval, grounding, evaluation).
  • Experience implementing monitoring and testing for data/ML/GenAI systems (data quality checks, model/prompt evaluation, logging/telemetry).
  • Experience managing environments, security, and deployments
  • Strong understanding of data governance and analytics best practices

Preferred Qualifications

  • Experience designing enterprise-scale analytics platforms
  • Familiarity with Azure services (Azure SQL, Data Factory, Synapse)
  • Familiarity with GCP BigQuery and Looker
  • Experience with CI/CD concepts for Power BI and Looker
  • Power Platform or Microsoft analytics certifications
  • Experience working in a Center of Excellence (CoE) model
  • Experience with Azure OpenAI / Azure AI Foundry (or equivalent) and enterprise deployment patterns.
  • Experience with orchestration frameworks (e.g., Semantic Kernel, LangChain, Autogen) and tool/function calling.

#LI-P1

Get your free, confidential resume review.
or drag and drop your file here.
Similar jobs

Similar jobs worth comparing

Data Architect
Data Architect

CBTS • Oak Brook (IL)

On-site
USD 180,000 - 280,000
Data & Analytics Engineer
Data & Analytics Engineer

ML6 Search + Talent Advisory • Bristol (VA)

On-site
USD 90,000 - 135,000
Developer Enterprise Fabric and BI
Developer Enterprise Fabric and BI

Socket.dev • Norwood (OH)

On-site
USD 110,000 - 150,000
AI Business Intelligence Developer
AI Business Intelligence Developer

Communication Service for the Deaf (CSD) • Austin (TX)

On-site
USD 90,000 - 130,000
Data Engineer/Data Analyst
Data Engineer/Data Analyst

Midland Industries • Kansas City (MO)

On-site
USD 90,000 - 130,000
Data Engineer
Data Engineer

Cornerstone Global Partners (CGP Group) • Schaumburg (IL)

On-site
USD 100,000 - 130,000
Senior Data Engineer
Senior Data Engineer

Fracht Sweden AB • Houston (TX)

On-site
USD 120,000 - 150,000
AI Business Intelligence Developer
AI Business Intelligence Developer

Communication Service for the Deaf, Inc • United States

On-site
USD 110,000 - 170,000
ETL Developer / Power BI
ETL Developer / Power BI

247Hire • Burbank (CA)

On-site
USD 100,000 - 130,000
Manager, Data and Analytics
Manager, Data and Analytics

Forward Air Corporation • Coppell (TX)

On-site
USD 120,000 - 150,000