• Design, build, and maintain production grade ETL pipelines using MySQL and external data sources • Integrate third party systems and APIs, including Integrate.io • Implement CDC and incremental loading strategies for efficient and reliable refresh • Manage schema changes, late arriving data, and source inconsistencies • Design and maintain analytical models including fact and dimension tables • Build and evolve data marts and a centralized data warehouse • Implement monitoring, documentation, and pipeline standards • Ensure data quality, consistency, and operational resilience • Provide technical leadership and define data engineering best practices

Role Description The Forterra Data Team is seeking an experienced Staff Data Engineer to support the implementation and development of data pipelines, the data warehouse, and other key components of the data platform. In this role, you will be instrumental in building the data foundation that enables insights for developing a best-in-class ecosystem of autonomy products. - Build and orchestrate pipelines for ingestion and transformation of data collected from Forterra's vehicles and internal systems. - Design, build, and maintain our enterprise data warehouse on Snowflake, ensuring optimal performance, cost-efficiency, and scalability. - Gather requirements from both technical and non-technical stakeholders to deliver end-to-end data products. - Support user and role provisioning, implement RBAC policies, support audits and conduct user access reviews. - Establish data modeling standards and data governance frameworks, creating dimension and fact tables that serve analytics, machine learning, and reporting use cases. - Implement data quality monitoring, anomaly detection, tests, and alerting. - Document definitions, metrics, and KPIs and assist in the development of a data dictionary. Qualifications - 6+ years of hands-on experience in data engineering, data warehousing, or analytics engineering roles. - Expert SQL knowledge and Python proficiency. - Experience with modern data warehouses (Snowflake, Redshift, BigQuery, etc.), data transformation, and orchestration tools (dbt, Airflow, Dagster, Prefect). - Experience with cloud infrastructure. - Understanding of software engineering best practices including version control, CI/CD pipelines, code review processes, and infrastructure-as-code. - Understanding of MLOps and experience with implementation of AI/ML technologies. Requirements - Big Data/IoT Data experience. - Experience working with unstructured data. - Experience working with GovCloud and FedRamp. Education & Experience - Bachelor's Degree in STEM field or related degree. US Salary Range $145,000.00—$175,000.00. The salary range for this role is an estimate and is based on a wide variety of compensation factors. The salary offered to candidates will vary based on a variety of factors including (but not limited to) relevant work experience, education, specialized training, critical expertise, training, and more. Benefits - Premium Healthcare Benefits: Three plan options, including an HSA-eligible plan, with Forterra covering 80% of the plan premium for you and your dependents. - Basic Life/AD&D, short and long-term disability insurance plans 100% covered by Forterra, plus the option to purchase additional life insurance for you and your dependents. - Extremely generous company holiday calendar including a winter break in December. - Competitive paid time off (PTO) offering 20 days accrued per year. - A minimum of 7 weeks fully paid parental leave for birth/adoption. - A $9k annual tuition reimbursement or professional development stipend. - Fully stocked beverage refrigerators with all the Celsius your little heart desires. - 401(k) retirement savings plan, including traditional, Roth 401(k), and after-tax deferral with company match up to 4%. Company Description Forterra is an equal-opportunity employer, providing and promoting equal employment opportunity in accordance with local, state, and federal laws. Forterrans are unique, talented individuals who are united through a shared passion to deliver autonomous systems that enable national resilience and a robust supply chain. All qualified applications will receive equal consideration for employment.

• Implementar soluções adequadas em engenharia de dados conforme a necessidade do projeto; • Utilizar programação e manutenção de códigos para preparar dados; • Atuar de forma a definir e construir banco de dados relacionais com arquitetura distribuída para processamento de Big Data; • Extrair, transformar e carregar (ETL) dados de um banco de dados para outro; • Efetuar a análise de requerimentos dos usuários; • Realizar pesquisa, desenho e desenvolvimento de novos programas de software; • Prover dados que geram valor para as áreas de negócio; • Identificar maneiras de melhorar a confiabilidade, a eficiência e a qualidade dos dados; • Disseminar conhecimento analítico entre o time e para a organização.

• Conectar talentos de tecnologia a projetos reais, de alto impacto • Trabalhar em projetos complexos e com múltiplas integrações • Colaborar com times de alta performance • Oferecer suporte e crescimento profissional