Senior Data Warehouse Engineer

About Forterra

Forterra is a leading provider of autonomous systems for ground-based movement in the working world. Amongst some of the earliest innovators in the field of driverless technology, Forterra is focused on building systems that protect front-line soldiers and enable civilian workers in our industrial base. Forterra is the go-to provider of ground autonomy solutions for the U.S. Department of Defense, which harnesses the technology for asymmetric warfare in critical conditions.

About the role

The Forterra data team seeks an experienced Senior Data Warehouse Engineer to support the implementation and development of the cloud data warehouse and other key components of the data platform. In this role, you'll be instrumental in building the data foundation that provides insights for building the best-in-class ecosystem of autonomy products.

What you'll do

• 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.
  
  

Minimum Qualifications

Mission-First Mindset - We put the needs of the mission and our customers first and understand that the

US and its allies have no preordained right to victory in any future conflict.

Ownership Mentality - We’re looking for owners; those who have a natural bias to assume responsibility, a

healthy dose of skepticism, and contribute to a culture of performance.

Technical Aptitude and Intellectual Curiosity - We are first and foremost a technology company, working at

the leading edge of capabilities like machine learning, autonomy, distributed networking, and multi-modal

sensor fusion.

Structured Thinker and Problem Solver - Leading technical programs requires clear communication and

well-thought-out plans. A solution-driven approach, the ability to distill complexity into its essential,

digestible components, and the ability to supervise execution are critical to ensure mission success.

360 Degree Leader - We are a non-hierarchical organization with a matrix structure that is dynamic and

evolving. We expect you to be self-aware enough to recognize your position of unstated leadership within

the company. You should have a demonstrated ability to lead and influence people through both formal

and informal constructs and in situations where there is lack of clarity across teams.

• 5+ years of hands-on experience in data engineering, data warehousing, or analytics engineering roles.
• Expert SQL knowledge and Python proficiency.
• Experience with the modern data warehouses (Snowflake, Redshift, BigQuery, etc), data transformation, and orchestration tools (dbt, Airflow, Dagster, Prefect).
• Experience with modern data stack tools such as Fivetran/Airbyte for ingestion, Looker/Tableau for visualization, and reverse ETL tools like Census/Hightouch.
• Understanding of software engineering best practices including version control, CI/CD pipelines, code review processes, and infrastructure-as-code.
• Basic understanding of MLOps and some experience with implementation of AI/ML technologies.

Preferred Qualifications

• Big Data/IoT Data experience.
• Experience working with unstructured data.
  
  

US Salary Range
 $155,000 - $180,000

Location

Remote

Up to 25% Travel

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