Data Engineer

We are seeking a detail-oriented Data Engineer to support the design, development, and optimization of data pipelines and data models. This role will focus on transforming raw data into structured, reliable datasets that drive business intelligence, reporting, and advanced analytics initiatives. Key Responsibilities • Partner with cross-functional stakeholders to understand business requirements and translate them into scalable data models • Design, build, and maintain data pipelines supporting batch and near real-time data processing across multiple data sources and integrations • Develop and manage data models and schema design, including dimensional modeling for analytics and reporting use cases • Build and maintain dbt models, ensuring consistency, testing, and documentation best practices • Create and optimize ETL/ELT processes with strong emphasis on data integrity, traceability, and lineages • Implement data quality frameworks, monitoring controls, and alerting mechanisms to proactively identify issues • Investigate and resolve data issues, perform root cause analysis, and implement preventative solutions • Develop and maintain documentation for data pipelines, models, and processes • Optimize performance through query tuning, indexing, and efficient data processing strategies • Support the stability and reliability of data pipelines, ensuring timely resolution of data interruptions • Assist in the decommissioning of legacy pipelines following migration and archival processes Required Qualifications • Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience • 4+ years of experience designing and managing data pipelines, data modeling, and transformation workflows using dbt • Experience with Databricks or similar platforms (e.g., Snowflake, Microsoft Fabric) • Strong proficiency in SQL, including database design, complex queries, performance optimization, and stored procedures • Experience using Python for data processing, scripting, or automation • Hands-on experience working with data transformation and analytics workflows Preferred Qualifications • Experience with data ingestion tools such as Fivetran • Exposure to SAP ECC data extraction or similar ERP systems • Familiarity with infrastructure-as-code tools (e.g., Terraform)