troveo - Data Engineer

• Data Pipeline Engineering • Design, build, and maintain ELT/ETL data pipelines (batch and streaming), optimizing for performance, reliability, scalability, and cost. • Design and implement conceptual, logical, and physical data models (including dimensional modeling, star/snowflake schemas). • Build and maintain transformation layers using modern tools (e.g., dbt) to create clean, well-documented, analytics-ready datasets. • Apply data modeling best practices, versioning, testing, and documentation to ensure consistency and reusability. • Data Analysis & Reporting Support • Write optimal SQL queries for data exploration, ad-hoc analysis, and troubleshooting. • Support the creation of reports, dashboards, and self-service analytics assets in collaboration with data analysts and business teams. • Translate business questions into data requirements and deliver actionable insights or datasets. • Operational Support & Data Deliveries • Monitor data pipelines and data delivery processes to ensure SLAs for timeliness, freshness, and accuracy are consistently met. • Proactively identify, troubleshoot, and resolve data issues impacting downstream consumers or business operations. • Manage incidents related to data availability and quality; participate in on-call rotations as needed. • Implement data quality checks, observability, and alerting to maintain high reliability of data deliveries. • Automate operational tasks and continuously improve data delivery processes. • Collaboration & Best Practices • Work cross-functionally with analysts, data scientists, engineers, and business stakeholders to understand data needs and deliver solutions. • Document data pipelines, models, lineage, and processes. • Contribute to data governance, security, and best practices across the data platform.