[Remote] Data Engineer
Note: The job is a remote job and is open to candidates in USA. Trilon 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. This role is responsible for designing, developing, and maintaining scalable data integrations and transformations in Azure and Microsoft Fabric, ensuring reliable, high-quality data to support business intelligence and innovation.ResponsibilitiesServe 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 issuesDevelop 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 standardsImplement 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 toolsDevelop 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 systemsCollaborate 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 integrationsPartner 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 pipelinesSkills5 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 activitiesCompany OverviewFounded in 1977, DRMP is a multi-discipline civil engineering and surveying firm that develops innovative and sustainable design solutions for infrastructure in the public, private and industrial sectors. It was founded in 1977, and is headquartered in Orlando, Florida, USA, with a workforce of 501-1000 employees. Its website is http://drmp.com.Company H1B SponsorshipDRMP has a track record of offering H1B sponsorships, with 1 in 2026, 3 in 2025, 5 in 2024, 4 in 2023, 3 in 2021, 2 in 2020. Please note that this does not guarantee sponsorship for this specific role.