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 not limited to) relevant work experience, education, specialized training, critical expertise, training, and more. Equity in Forterra is included in most of our full-time, high-demand roles and is therefore considered part of Forterra’s overall compensation package. In addition to base salary and equity, Forterra offers competitive benefits for full-time employees including:

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

Your recruiter will be able to share more information about our salary and benefits offering during the hiring process.

CLEARANCE ELIGIBILITY - This position may require eligibility to obtain and maintain a U.S. security clearance. For more information about U.S. Security Clearances: click here. 

Forterra is an equal-opportunity employer, providing and promoting equal employment opportunity in all personnel practices. 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 applicants will receive consideration for employment without regard to any factor, including veteran and disability status, and criminal history, in accordance with applicable local, state, and federal laws.

Forterra is also committed to working with and providing reasonable accommodations to individuals with disabilities. Please let your recruiter know if you need an accommodation at any point during the interview process.

To see Forterra’s candidate data privacy policy, please visit Forterra Legal | Job Applicant Privacy Notice.