> Markdown version of [/jobs/ext/1590195-principal-ai-data-engineer](https://www.wearedevelopers.com/jobs/ext/1590195-principal-ai-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Principal AI Data Engineer - **Company:** Presidio Networked Solutions, LLC - **Location:** Austin, TX, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Clean Code Principles, Application Programming Interfaces (APIs), Artificial Intelligence, Business Analytics Applications, Data Analysis, Audit Trail, Microsoft Azure, Business Intelligence Development, Business Systems, Cloud Computing, Code Review, Encodings, Information Systems, Computer Programming, Continuous Integration, Customer Data Management, Data as a Services, Data Architecture, Data Validation, Information Engineering, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Security, Data Systems, Dimensional Modeling, Human Resources Information System (HRIS), Python (Programming Language), Knowledge Management, PostgreSQL, Mainframes, Microsoft SQL Server, Oracle (Applications), Performance Tuning, Release Management, Power BI, Cloud Services, Salesforce.Com, Software Engineering, SQL Databases, Data Streaming, Tableau (Software), Enterprise Data Management, Azure Data Factory, Delivery Pipeline, Snowflake, Apache Spark, Microsoft Fabric, Pyspark, Information Technology, Data Management, Software Version Control, Databricks - **Published:** July 23, 2026 - **Apply:** https://jobs.localjobnetwork.com/apply/add/87816683/1 ## About the Role * Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent practical experience. * 10+ years progressive experience in data engineering, software engineering, cloud data platforms, or enterprise analytics engineering. 5+ years of hands-on experience designing, building, and operating enterprise data platforms using Microsoft Azure, Microsoft Fabric, Databricks, Snowflake, or comparable data technologies. * Significant hands-on experience building and operating enterprise data platforms in production, including lakehouse and medallion architectures, domain-oriented data products, and semantic models. * Deep, hands-on expertise with Microsoft Fabric and Microsoft Azure data services: lakehouse, Data Factory, notebooks, semantic models, deployment pipelines, and identity-based access control (e.g., Entra ID). * Proven experience consolidating heterogeneous legacy source systems (e.g., mainframe, Oracle, PostgreSQL, on-premises SQL Server) into modern cloud data platforms, including reconciliation and validation across migrations. * Strong programming skills in Python/PySpark and SQL, with experience engineering high-volume production pipelines with automated auditing, validation, and recovery patterns. * Hands-on Salesforce experience, including administration and integration of SFDC data and permission models into analytical platforms. * Experience implementing row-level security and access controls in analytics platforms that mirror source-system permission models. * Demonstrated engineering discipline: version control, structured deployment (e.g., Fabric deployment pipelines), testing, and production support. * Strong communication skills and the ability to work effectively with architects, analysts, business stakeholders, and third-party contractors. Preferred Skills and Professional Experience: * Experience building AI-ready data foundations: RAG pipelines, vector/semantic retrieval, MCP or similar connector frameworks, or agent-based data access patterns. * Experience with Power BI semantic model development (DAX, M, Tabular Editor) and/or Tableau connectivity and certified data sources. * Experience in sales operations, revenue operations, or go-to-market analytics domains, including territory, pipeline, and quota data models. * Experience with data quality tooling, observability, and automated reconciliation frameworks. * Experience working in contractor-heavy or transition environments, including knowledge capture, code remediation, and acquisition data integration. * Relevant certifications (e.g., Microsoft Fabric, Azure Data Engineer, Salesforce). ## Description Technical Leadership * Establish engineering standards, development practices, and implementation patterns for enterprise AI and data platform solutions. * Mentor engineers through architecture reviews, code reviews, technical coaching, and engineering best practices. * Evaluate emerging technologies and recommend improvements to the enterprise AI and data platform. * Partner with the AI Data Architect to translate enterprise strategy into scalable, secure, and production-ready technical solutions. * Promote engineering excellence across reliability, maintainability, automation, and operational support. * Provide technical leadership in evaluating implementation trade-offs and recommend improvements that strengthen the enterprise architecture while maintaining alignment with strategic objectives. Data Platform Engineering (Microsoft Fabric & Azure) * Build and operate the enterprise lakehouse on Microsoft Fabric and Microsoft Azure, implementing the domain-oriented data products, medallion-layer structures, and Fabric-based semantic models defined in the enterprise architecture. * Develop, test, and maintain data pipelines for ingestion, transformation, and serving using Fabric-native tooling, Python, Spark, and SQL, with automated data validation to ensure integrity and timeliness. * Administer the Fabric and Azure data environments: capacity, workspaces, deployment pipelines, monitoring, and cost management. * Own performance tuning and operational excellence for the data platform, including incident response, root-cause analysis, and continuous improvement. * Establish and maintain engineering practices for the platform: version control, CI/CD, code review, testing standards, and release management. Semantic Model & Data Product Implementation * Implement enterprise semantic models and certified data products to specification, encoding governed metric definitions, calculation logic, and business context from the metrics registry. * Implement row-level and object-level security in Fabric and OneLake that mirrors source-system permissions (e.g., Salesforce roles and visibility rules) to protect sensitive pipeline, customer, and people data. * Integrate source systems - CRM (Salesforce), CPQ, PSA, ERP, HRIS, and finance platforms - into the enterprise model so revenue, pipeline, people, cost, and customer data are consistently defined and analytics-ready. * Modernize data flows from legacy and server-based applications into the lakehouse, with reconciliation and validation frameworks that prove parity between legacy outputs and modernized models. * Connect governed, certified data sources to Data Visualization Platforms (e.g., Power BI, Tableau) and partner with BI developers to migrate duplicated logic into shared enterprise models. AI Solution Engineering * Build the retrieval and grounding infrastructure - semantic model endpoints, metadata services, RAG patterns, certified MCP connectors, and context APIs - that lets AI applications and agents answer business questions with governed data. * Engineer the enterprise context layer in partnership with the AI Data Architect and AI Enablement function, making curated business context, policies, and definitions available to AI tools. * Implement guardrails, access controls, and quality gates for AI data consumption in accordance with company policies. Data Quality & Operations * Implement automated data quality frameworks: validation rules, anomaly detection, reconciliation checks, and monitoring aligned to established quality standards. * Maintain lineage, documentation, and metadata for pipelines, models, and data products to support governance, certification, and auditability. * Support current-state assessment and knowledge capture from existing systems, prior development efforts, and third-party contractors, converting institutional knowledge into documented, maintainable code. Collaboration * Partner daily with the AI Data Architect to refine designs based on implementation realities, propose technical alternatives, and deliver iteratively. * Work with BI developers, analysts, and domain teams to gather technical requirements and deliver reliable, well-documented data products. * Mentor and review the work of internal engineers and contractors, raising the engineering bar across the data function., * Cloud & Platform: Microsoft Fabric (OneLake, lakehouse, Direct Lake), Microsoft Azure data & analytics services, Data Factory. * Engineering: Python/PySpark, SQL, notebook-based ETL/ELT, version control, Fabric deployment pipelines, automated validation. * Modeling: Semantic and dimensional modeling (star/snowflake), medallion architecture, data product implementation, DAX/M. * Legacy Modernization: Mainframe, Oracle, PostgreSQL, and SQL Server consolidation into cloud lakehouse platforms. * Business Systems: Salesforce/CRM administration and integration, CPQ, PSA, ERP, HRIS. * Analytics & BI: Power BI and/or Tableau connectivity, certified data sources, row-level security. * AI Engineering: RAG, metadata/context services, MCP connectors, AI data guardrails. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [Stephan Gillich - Bringing AI Everywhere](https://www.wearedevelopers.com/magazine/489-stephan-gillich-bringing-ai-everywhere) - [MLOps And AI Driven Development](https://www.wearedevelopers.com/magazine/82-mlops-and-ai-driven-development)