About the Role
Presidio is at the forefront of a global technology revolution, transforming industries through cutting-edge digital solutions and next-generation AI. We empower businesses to achieve more through innovation, automation, and intelligent insights.
Responsibilities
- 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.
- Build and operate the enterprise lakehouse on Microsoft Fabric and Microsoft Azure, implementing domain-oriented data products, medallion-layer structures, and Fabric-based semantic models.
- Develop, test, and maintain data pipelines for ingestion, transformation, and serving using Fabric-native tooling, Python, Spark, and SQL, with automated data validation.
- 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.
- Implement enterprise semantic models and certified data products to specification, encoding governed metric definitions, calculation logic, and business context.
- Implement row-level and object-level security in Fabric and OneLake that mirrors source-system permissions to protect sensitive data.
- Integrate source systems — CRM (Salesforce), CPQ, PSA, ERP, HRIS, and finance platforms — into the enterprise model.
- Modernize data flows from legacy and server-based applications into the lakehouse, with reconciliation and validation frameworks.
- 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.
- 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.
- Implement guardrails, access controls, and quality gates for AI data consumption in accordance with company policies.
- 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.
- 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.
Requirements
- 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.
Skills
- Microsoft Fabric (OneLake, lakehouse, Direct Lake)
- Microsoft Azure data & analytics services
- Data Factory
- Python/PySpark
- SQL
- Notebook-based ETL/ELT
- Version control
- Fabric deployment pipelines
- Automated validation
- Semantic and dimensional modeling (star/snowflake)
- Medallion architecture
- Data product implementation
- DAX/M
- Mainframe
- Oracle
- PostgreSQL
- SQL Server consolidation
- Salesforce/CRM administration and integration
- CPQ
- PSA
- ERP
- HRIS
- Power BI connectivity
- Tableau connectivity
- Certified data sources
- Row-level security
- RAG
- Metadata/context services
- MCP connectors
- AI data guardrails
- Power BI semantic model development
- Tableau connectivity
- Sales operations analytics
- Revenue operations analytics
- Go-to-market analytics
- Data quality tooling
- Observability
- Automated reconciliation frameworks
- Knowledge capture
- Code remediation
- Acquisition data integration
- Microsoft Fabric certifications
- Azure Data Engineer certifications
- Salesforce certifications
Location
- Remote
Work Type
- Full-time
Experience Level
- 10+ years experience
- 5+ years hands-on experience
Education Level
- Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent practical experience.
About the Company
- At Presidio, speed and quality meet technology and innovation. Presidio is a trusted ally for organizations across industries with a decades-long history of building traditional IT foundations and deep expertise in AI and automation, security, networking, digital transformation, and cloud computing. Presidio fills gaps, removes hurdles, optimizes costs, and reduces risk. Presidio's expert technical team develops custom applications, provides managed services, and enables actionable data insights and builds forward-thinking solutions that drive strategic outcomes for clients globally.
Equal Opportunity
- As an Equal Opportunity Employer, we strive to have a workforce that includes the community we serve.
- Presidio is an Equal Opportunity Employer Disability/Vets. We evaluate qualified applicants without regard to race, color, religion, sex, age, national origin, disability, veteran status, genetic information, and other legally protected categories.
- Presidio is committed to working with and providing reasonable accommodations to individuals with disabilities.
- Presidio is a VEVRAA Federal Contractor requesting priority referrals of protected veterans for its openings.
