Data Engineer — Build Scalable Pipelines & BI Tools

Landmark Foundation Group; St. Louis (MO); On-site; USD 110,000 - 150,000; Full time

Job summary

Landmark Foundation Group in the United States is seeking a hands-on Data Engineer to build pipelines, models, and applications that help our operating companies measure performance and make better decisions.

You will connect data from Salesforce, NetSuite, Accutrax, ArcSite and other sources using Snowflake, Fivetran, dbt, and Streamlit, supported by Python-based AWS Lambda functions and Terraform deployment scripts.

Qualifications

• 3–6 years of data engineering, analytics engineering, or related development role.
• Strong SQL and Python with analytical modeling and REST API integrations.
• Hands-on experience with Snowflake, Fivetran, and dbt.
• Experience building Streamlit apps for business users.
• Familiarity with AWS Lambda, Terraform, and Git-based development and deployment.

Responsibilities

• Build and maintain automated ingestion into Snowflake using Fivetran and custom Python integrations in AWS Lambda.
• Develop tested, documented dbt models connecting customer, sales, job, and financial data across brands.
• Build Streamlit applications for data exploration, reporting, and business workflows.
• Monitor data freshness, completeness, and accuracy; troubleshoot issues and root causes.
• Maintain Terraform deployment scripts and Git-based workflows for repeatable changes.
• Optimize Snowflake performance, cost, and access controls; document models and dependencies.
• Partner with stakeholders to define metrics and onboard additional brands and systems.

Skills

SQL & Python

Analytical modeling

REST API integrations

Maintainable code

Tools

Snowflake

Fivetran

dbt

Streamlit

AWS Lambda

Terraform

Git-based workflows

Job description

Landmark Foundation Group in the United States is seeking a hands-on Data Engineer to build pipelines, models, and applications that help our operating companies measure performance and make better decisions.

You will connect data from Salesforce, NetSuite, Accutrax, ArcSite and other sources using Snowflake, Fivetran, dbt, and Streamlit, supported by Python-based AWS Lambda functions and Terraform deployment scripts.