Apply on Employer Site

Forterra · 8 hours ago

Senior Data Warehouse Engineer

United States

Full-time

Hybrid

Senior Level

$155K/yr - $180K/yr

5+ years exp

Forterra is a leading provider of autonomous systems for ground-based movement in the working world. They are seeking 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.

Defense & Space

Growth Opportunities

No H1B

Security Clearance Required

U.S. Citizen Only

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

Qualification

SnowflakeSQLPythonData modelingData governanceData quality monitoringMLOpsBig DataIoT DataUnstructured dataTechnical aptitudeProblem solvingLeadership

Required

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

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

Preferred

Big Data/IoT Data experience

Experience working with unstructured data

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.

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