Senior Data Warehouse Engineer

Forterra

55d•$155,000 - $180,000•Remote

About The Position

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.

Requirements

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.

Nice To Haves

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

Responsibilities

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.

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume