Data Engineer

Department: IT Location: Remote- USA Compensation: $116,000 - $155,000 / yearDescriptionTrilon is building a supercharged, technology-enabled future for our people and partners. The Data Engineer plays a key role in that mission by building and maintaining the data platform that powers Trilon’s enterprise analytics, automation, and AI capabilities.Reporting to the Vice President, Data & DevOps, this role is responsible for designing, developing, and maintaining scalable data integrations and transformations in Azure and Microsoft Fabric. The Data Engineer ensures that Trilon’s data platform delivers reliable, high-quality, and well-structured data to support business intelligence, operations, and innovation.This role serves as the primary custodian of Trilon’s integrated data model and is instrumental in developing a unified, extensible architecture that scales with continued acquisitions. The Data Engineer designs and builds secure Power BI semantic models for consumption by analysts and decision-makers, ensuring consistent and governed access to enterprise data. This role also partners closely with the AI and Innovation vTeam to prepare data for analytics, machine learning, and retrieval-augmented generation (RAG) applications.Key ResponsibilitiesData Platform Engineering and MaintenanceServe as the primary owner and technical steward of the Trilon enterprise data platformDesign, develop, and maintain data pipelines and workflows using Azure Data Factory, Synapse, and Microsoft FabricBuild and manage data transformations, orchestration, and automation across structured, semi-structured, and unstructured data sourcesEnsure scalability, reliability, and performance of the data platform as Trilon continues to grow through acquisitionImplement monitoring and alerting to proactively detect and resolve pipeline or data quality issuesData Integration and ModelingDevelop and maintain integrations between Trilon’s enterprise systems, cloud services, and acquired partner environmentsDesign and maintain a unified, scalable data model that harmonizes data across business systemsBuild secure, governed, and high-performance Power BI semantic models optimized for analytics and self-service reportingCollaborate with business analysts and data consumers to ensure data models support enterprise reporting needs and KPIsPartner with cybersecurity and infrastructure teams to ensure data models and access patterns meet compliance and governance standardsData Quality and GovernanceImplement validation and quality checks to ensure accuracy, completeness, and timeliness of enterprise data setsMaintain metadata, lineage, and documentation to promote transparency and reusabilityDefine and enforce data quality and consistency standards across all integrated sourcesCollaborate with the Technology Asset Manager and Service Platform Manager to align system integrations and data governanceSupport data cataloging, discovery, and classification initiatives within Microsoft Purview or equivalent toolsAutomation, Optimization, and ResilienceDevelop automated frameworks for ingestion, transformation, and validation using Azure-native tools and pipelinesImplement DevOps principles for data workflows including version control, testing, and deployment automationOptimize pipeline performance, resource utilization, and data freshnessBuild resilience and fault tolerance into data operations to ensure reliability and recoveryCreate reusable components and templates to streamline integration of new data sources and partner systemsAI and Innovation EnablementCollaborate with the AI and Innovation vTeam to prepare and structure data for AI, ML, and RAG-based applicationsDevelop and maintain data pipelines that support model training, evaluation, and fine-tuningCurate and transform unstructured data for retrieval, embedding, and vectorization within AI applicationsEnsure data readiness for generative AI tools, chat interfaces, and knowledge retrieval systemsStay informed of emerging AI data engineering trends and Microsoft Fabric AI integrationsCollaboration and Cross-Domain PartnershipPartner with application and infrastructure teams to ensure reliable and secure data exchange across systemsCollaborate with business stakeholders and analysts to understand reporting needs and deliver usable data modelsSupport integration engineers in onboarding new firms and ensuring their data aligns with Trilon’s enterprise modelWork closely with cybersecurity and compliance teams to enforce data protection, retention, and access policiesProvide documentation, architecture diagrams, and operational standards for the data platform and pipelinesSkills, Knowledge and Expertise7 or more years of experience in data engineering, data integration, or data platform developmentStrong hands-on experience with Azure Data Factory, Azure Synapse, Microsoft Fabric, and related Azure data servicesProficiency in SQL, DAX, Power Query, and data modeling for Power BIExperience designing and maintaining Power BI semantic models, datasets, and row-level security configurationsFamiliarity with data governance, cataloging, and lineage management in tools like Microsoft PurviewExperience building and optimizing cloud data pipelines with structured, semi-structured, and unstructured dataUnderstanding of data preparation for AI and machine learning applications, including RAG architecturesExposure to engineering and geospatial data such as CAD, BIM, and GISStrong analytical and problem-solving skills with a focus on scalability and performanceExcellent collaboration and communication skills across technical and business audiencesBachelor’s degree in Computer Science, Data Engineering, or related field preferredMicrosoft certifications such as Azure Data Engineer Associate or Fabric Analytics Engineer Associate are a plusMay require occasional travel to Trilon offices or partner locations for integration or collaboration activitiesAbout TrilonTrilon was formed with the vision of building the next Top 20 infrastructure consulting firm in North America by bringing together some of the nation’s best infrastructure consulting firms, focused on delivering practical and sustainable infrastructure solutions. Trilon is backed by Alpine Investors, a PeopleFirst Private Equity Firm. Trilon currently comprises 5,500+ staff across the US. For more information, visit www.trilon.com.Pay TransparencyThe base salary range for this role is indicated in the posting. This range reflects the company’s good faith estimate of the compensation for this position at the time of posting. Final compensation will be determined based on factors such as experience, skills, qualifications, internal equity, and geographic location.