Data Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Act as the primary owner and technical steward of Trilon’s enterprise data platform.

• Design, develop, and maintain data pipelines and workflows utilizing Azure Data Factory, Synapse, and Microsoft Fabric.

• Construct and oversee data transformations, orchestration, and automation across structured, semi-structured, and unstructured data sources.

• Ensure the scalability, reliability, and performance of the data platform as Trilon expands through acquisitions.

• Implement monitoring and alerting mechanisms to identify and resolve pipeline or data quality issues.

• Develop and uphold integrations between enterprise systems, cloud services, and acquired partner environments.

• Design and maintain a cohesive, scalable data model across business systems.

• Create secure, governed Power BI semantic models for analytics and self-service reporting.

• Enforce data validation, quality checks, metadata, lineage, documentation, and governance standards.

• Develop automated ingestion, transformation, and validation frameworks using Azure-native tools.

• Apply DevOps principles including version control, testing, and deployment automation.

• Optimize pipeline performance, resource utilization, and data freshness.

• Incorporate resilience and fault tolerance into data operations.

• Prepare and structure data for AI, machine learning, and RAG-based applications.

• Develop pipelines that support model training, evaluation, and fine-tuning.

• Curate unstructured data for retrieval, embedding, and vectorization.

• Collaborate with application, infrastructure, cybersecurity, compliance, business, and AI teams.

• Assist in onboarding acquired firms and aligning with Trilon’s enterprise data model.

• Provide documentation, architecture diagrams, and operational standards.

⛳️ Requirements

• A minimum of 7 years of experience in data engineering, data integration, or data platform development.

• Strong practical experience with Azure Data Factory, Azure Synapse, Microsoft Fabric, and related Azure data services.

• Proficiency in SQL, DAX, Power Query, and data modeling for Power BI.

• Experience in designing and maintaining Power BI semantic models, datasets, and row-level security configurations.

• Familiarity with data governance, cataloging, and lineage management using tools like Microsoft Purview.

• Experience in building and optimizing cloud data pipelines with structured, semi-structured, and unstructured data.

• Understanding of data preparation for AI and machine learning applications, including RAG architectures.

• Exposure to engineering and geospatial data such as CAD, BIM, and GIS.

• Strong analytical and problem-solving skills with an emphasis on scalability and performance.

• Excellent collaboration and communication skills across technical and business stakeholders.

• Bachelor’s degree in Computer Science, Data Engineering, or a related field preferred.

• Microsoft certifications such as Azure Data Engineer Associate or Fabric Analytics Engineer Associate are advantageous.

• May require occasional travel to Trilon offices or partner locations for integration or collaboration activities.

🏝️ Benefits

• Trilon is supported by Alpine Investors, a PeopleFirst Private Equity Firm.

• Pay transparency: the base salary range reflects the company’s good faith estimate; final compensation takes into account experience, skills, qualifications, internal equity, and geographic location.

• May require occasional travel to Trilon offices or partner locations for integration or collaboration activities.