Analytics Engineer: AI Copilots, Fabric & Power BI

Socket.dev; Durham (NC); On-site; USD 110,000 - 160,000; Full time

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

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.